Foreign Currency, General Ledger How to import Foreign Currency Exchange Rates in a Cashbook Batch

Foreign Currency, General Ledger How to import Foreign Currency Exchange Rates in a Cashbook Batch

Article credit: Sage 

Learn how to import Foreign Currency Exchange Rates in a Cashbook Batch

Description

This article explains how to import Foreign Currency Exchange Rates on a Cashbook Batch import   

Resolution

We’ll explain how to achieve the above by the following scenario:

1. Go to Common | Foreign Currency | Currency Exchange Rate for the relevant currency.

2. Setup all the various exchange rates for the specific days as per below example.

3. Setup a dummy foreign currency cashbook with at least 4 different transaction lines using any foreign currency Supplier/Customer account, transaction dates and Foreign Payment amounts etc

4. Save the Cashbook batch (not posted).

5. Go to File | Export and export the batch as below (select your own export location and file to be created.

6. Find an open the exported file and edit the values as below.

7. When done, save the changes and CLOSE the CSV file. This file will now be used as an import file.

8. Back in the cashbook batch clear all the lines and click the Save button.

9. Go to File | Import and browse for the import file with the selections as below.

10. When imported, notice that the correct and expected exchange rates have been populated per transaction.

Disclaimer: These articles refer to possible solutions and a platform to share information. Each article describes a method that solved a query (knowledge gathered from previous sites) and how Sage Evolution should operate. These articles make reference to a specific Sage Evolution version, however the thought process can be generalised. Please note the information contained in these articles should be treated as guidelines and adapted to accommodate differences in business processes and IT environments. Articles may not be applicable to all environments. If this article did not resolve your query please contact Kiteview Technologies Support Department on:  (+27) 010 005 6678.

About Us
Kiteview Technologies (Pty) Ltd was founded in May 2010 to provide the Sage Evolution Business Management solution to the SME market. The management team of Kiteview have combined +30 years of experience in the delivery of small to mid-market Financial & Business Management solutions. This experience, combined with a sound project implementation methodology has helped in Kiteview’s growth, becoming a Platinum status partner for SAGE Pastel within just 1 year.

Contact Us

For An Obligation Free Quote

How CFOs are using technology to improve business processes

How CFOs are using technology to improve business processes

Article credit: Sage 

In the past, the CFO role might have been more comparable to someone focused on crunching the numbers, rather than the C-suite figurehead we know now.

CFOs were more focused on history – generating reports about the past through business processes.

Today, if you are in the CFO role, your business needs you to focus on strategy, analysing both current and future growth prospects.

You need to have a more holistic view of business operations and market development, being in tune with customers, products and services, all the while increasing value.

But how can you deal with these increasing demands both now and the future? With technology.

Technology is what you to transition from being the manager of finances via a view of the past to become the person in charge of unlocking of the most valuable future opportunities.

Technology is integral to modern businesses.

Without technology, digital transformation is impossible, and your finance function won’t be ready and equipped to meet the challenges both now and one, five and 10 years down the line.

You need to embrace innovation and arm your finance team with the right tools to improve and increase effectiveness.

Finance leaders agree that technology is the top way to improve the effectiveness of the finance function.

So what should you be focusing on when it comes to using technology to improve your finance processes? We cover some key areas in this article.

Data quality and data science

What is it?

Data science, as applied to finance, is where you build systems and processes to extract data, which allows you to draw insight you can use to predict the future, and make evidence-based decisions and suggest improvements.

Why should you adopt it?

According to executive search firm Leathwaite, 51% of finance functions are already using data quality and data science, while 36% are planning to use it.

With data science and better data quality, you can better understand customer needs and dig out patterns that help you know where you should put your investment.

Steps to take to adopt it

To put data at the heart of long-term business success you should focus on six areas:

  • Make a case for data as integral to the business strategy by identifying proof of concept projects
  • Align the analytics capability and delivery with priority business requirements
  • Help instil the right leadership and culture
  • Provide training to help individuals recognise decision biases – the psychological assumptions that often lead to poor decision-making
  • Provide easy-to-use tools for users of data
  • Transform the analytics-based insights into actions, and align incentives, rewards and measurement accordingly.

Automation

What is it?

Automation, as it relates to finance, is the use of financial software to automate tasks such as accounts reconciliation and preparing financial statements and reports, without the need for humans to spend lots of time doing so.

Why should you adopt it?

Automation can relieve your finance team of menial and tedious tasks, allowing you and your team to spend more time on more strategic tasks.

Steps to take to adopt it

1. Understand what kind of automation you need

Every business is different, and it’s crucial to get the best value for the automation you implement and the best for your business needs.

There are different types – from variations that help businesses automate daily tasks, to more advanced types that combine with machine learning to perform more complex actions in response to human interaction.

2. Start automation in the right departments

You’ll know from a bit of analysis which tasks automation would help. Automation could undoubtedly help in back-office processes in the finance department.

It could automate processes in areas such as marketing, legal, sales and the supply chain. Aim for quick wins allowing you to visualise a future roadmap.

3. Ask if automation makes economic sense

When looking at the opportunities for automation within departments, you should question how economically viable these opportunities are for the business.

For instance, you should investigate the return on investment. Get the relevant stakeholders in from the departments in question and try and create a business case.

4. Get management buy-in

You need to get information straight from stakeholders on what they understand when it comes to automation and how it would be able to benefit them.

You and other members of the leadership team should help the wider business understand what automation can do and how it could make their working lives more comfortable, letting them focus on more critical, less repetitive tasks.

5. Work at the right speed

The IT team can provide technical expertise and to make sure the implementation runs smoothly and at the right pace.

The technical leadership need to adopt a strategy of starting small, getting the business used to the technology, and expanding it out when the company gets used to the changes.

AI/machine learning

What is it?

Artificial intelligence (AI) is an all-encompassing term that covers all technology that can mimic human intelligence and has been in development since the 1950s.

A type of AI, machine learning allows systems to learn and improve through experience, without needing to be explicitly programmed.

Why should you adopt it?

Machine learning means computers can handle new experiences through analysis, self-training, observation and experience.

It allows computers to learn automatically without human intervention or assistance through complex algorithms so you can analyse massive amounts of data.

21% of finance teams are already using AI/machine learning, while 46% are planning to use it.

Steps to take to adopt it

Initially ask these fundamental questions:

  • Can the application of AI/machine learning make your business run more effectively and efficiently?
  • Can AI/machine learning solve your business problems?
  • Can AI/machine learning make your business more profitable?

The likelihood of AI solving some of your biggest challenges grows as the technology gets closer to maturity. You must have a clear focus on what AI/machine learning can do to achieve your business goals – this must be the driving force.

If you’re thinking about practical AI/machine learning business applications, you could look at how computers process and identify patterns in data.

They do this much more effectively and efficiently than humans, allowing much better insight.

Standardised, ‘off-the-shelf’ AI/machine learning services might address simple scenarios such as image recognition and voice to text.

But advanced predictive scenarios that provide more business value require much more sophisticated and customised solutions tailored to their specific business and operational needs.

Adopt use tech to be more effective

As a CFO, you’re in the prime position to oversee the technology needed to support and grow your business, drive digital transformation, and commit your company to change.

Of course technology by itself won’t lead to improvement – that’s why you’re there to set clear goals and make sure the right tools are used in the right way.

Support your business in investing in the right technologies through your knowledge of what they can do to drive your company forwards.

About Us
Kiteview Technologies (Pty) Ltd was founded in May 2010 to provide the Sage Evolution Business Management solution to the SME market. The management team of Kiteview have combined +30 years of experience in the delivery of small to mid-market Financial & Business Management solutions. This experience, combined with a sound project implementation methodology has helped in Kiteview’s growth, becoming a Platinum status partner for SAGE Pastel within just 1 year.

Contact Us

For An Obligation Free Quote

Digital transformation is about mindset and possibilities

Digital transformation is about mindset and possibilities

Article credit: Sage 

Organisations need to adopt the agile decision-making mindset that Silicon Valley is renowned for where management lacks the right mindset to change and the company’s organisational practices are flawed, a digital transformation process may simply result in magnifying those flaws rather than transforming them.

Digital transformation has to be viewed as a continuous process and mindset rather than a one-off implementation. The common denominators in achieving a successful digital transformation include having finance leaders who understand that the following elements add up to strategic agility:

  • Understanding the existence of blurred lines within the technology stack of data, infrastructure and applications;
  • How unravelling tightly integrated systems makes them more flexible; and
  • Understanding that by minimising the differences among processes, their company will be better able to leverage all of its data.

Because of the need for these elements, responsibility for the process has shifted over the past five years from the chief information officer to the CFO, or even the CEO. These C-suite roles have to be integrated with support not only of each other but also technological and business transformation. This is why the role of the CFO is evolving at such a pace.

At the start of this shift, in 2017 research by Bersin revealed that close to 90% of organisations surveyed reported that while they are undergoing digital disruption, 70% felt that they were not ready to address this digital transformation.

They recognised gaps in their existing leadership capability, digital mindset, operating models and skills set. These points have been identified in our CFO 3.0 report as increasing the responsibility of the CFO, leaders which are already typically responsible for major projects with major financial impact.

The CFO 3.0 — Digital transformation beyond financial management report explains that, since budgetary approval is a key element of digital strategy, the finance function has also moved to the center of digital strategy. Our report is a new guide that looks at the evolution of finance leaders.

 

Here are  five tips to change mindsets

  1. A critical aspect of changing mindsets is to leverage insiders — use internal staff who have intimate knowledge of what works and what doesn’t in the company’s daily operations. All too often, organisations seeking to transform (whether digital or otherwise) bring in outside consultants who tend to apply one-size-fits-all solutions in the name of best practice.
  2. To succeed in digital transformation, finance leaders are well advised to go back to the fundamentals: focus on changing the mindset of employees, as well as the organisational culture and processes, before deciding what digital tools to use and how to use them. What they envision to be the future of the organisation must guide the choice of technology, not the other way round.
  3. Changing mindsets becomes even more critical where teams are working remotely. The CFO 3.0 report finds that since lockdown began, 27% of finance leaders have taken on the additional responsibility of managing remote workers. With the rise in people working remotely comes the need to work as collaboratively as possible to ensure maximum support and productivity.
  4. Personal growth mindset: Instill in people the belief that they can learn something new. Digital dexterity is one of the most critical skills for employees to learn to be able to understand technology and, more importantly, how they can apply it in their jobs for the better.
  5. Promote a complex problem-solving and critical thinking mindset: In today’s context, the only constant changes. As jobs become less routine and more strategic, workers need to become more mentally agile and be able to adapt to changes fast to solve complex problems in the real world.

Reskilling and upskilling

These skills are unlikely to be widely available, so recruitment may not be the answer. The solution will be for companies to constantly reskill and upskill their own people, and to instill a digital mindset. In this way, people can come to recognise opportunities to use technology to generate more revenue or to digitally disrupt their existing operating models. Businesses need to become more innovative and to provide more chances to their people to make frequent use of technology.

This will go some way to assuage real fears regarding job security in terms of the future of work and the impact of artificial intelligence and machine learning over the next five to 10 years. Workers need to understand that most digital technologies provide possibilities for efficiency gains and customer intimacy — but in the absence of the right mindset, digital transformation may simply magnify efficiency flaws rather than cure them.

About Us
Kiteview Technologies (Pty) Ltd was founded in May 2010 to provide the Sage Evolution Business Management solution to the SME market. The management team of Kiteview have combined +30 years of experience in the delivery of small to mid-market Financial & Business Management solutions. This experience, combined with a sound project implementation methodology has helped in Kiteview’s growth, becoming a Platinum status partner for SAGE Pastel within just 1 year.

Contact Us

For An Obligation Free Quote

Order Entry | Inventory Zero: Reserved Quantity on Inventory Enquiries  Item Information after entering it on Sales Order

Order Entry | Inventory Zero: Reserved Quantity on Inventory Enquiries Item Information after entering it on Sales Order

Article credit: Sage 

Summary

Zero Reserved Quantity on Inventory Enquiries | Item Information after entering it on Sales Order in Sage 200 Evolution

Description

This article discusses why you may observe a zero Reserved Quantity on the Inventory Enquiries | Item Information screen after entering it on a Sales Order for the same stock item.  

For example, in this scenario notice the zero Reserved Quantity value below:

 after the following Reserved Quantity was entered on the processed Sales Order.

Resolution

Consider the following advice to resolve the above query:

1. First notice that as per design:

  • the captured Reserved Quantities on the Sales Order
  • will only display on the Inventory Enquiries | Item Information screen,
  • if the Sales Order  (SO) has been Placed, and not processed.  

 

2. In the scenario below, the SO was processed as below

3. The result is that the above entered Reserved quantities is automatically relayed into Quantity on Sales Order on the Inventory Enquiries | Item Information screen, and not on the Reserved Quantities field below.

4. Also notice below that the Quantity Available is 50 = 100 (original units and seen on the Available field above) – 50 confirmed on sales order above.

5. Therefore, only if you make use of the Place Order (and not process) button,

will the Reserved Quantity be populated as can be seen below

6. Also note:

The Quantity on Sales Order is 25 = 20 units from the first Sales Order plus 5 units from the second Sales Order

 

Disclaimer: These articles refer to possible solutions and a platform to share information. Each article describes a method that solved a query (knowledge gathered from previous sites) and how Sage Evolution should operate. These articles make reference to a specific Sage Evolution version, however the thought process can be generalised. Please note the information contained in these articles should be treated as guidelines and adapted to accommodate differences in business processes and IT environments. Articles may not be applicable to all environments. If this article did not resolve your query please contact Kiteview Technologies Support Department on:  (+27) 010 005 6678.

About Us
Kiteview Technologies (Pty) Ltd was founded in May 2010 to provide the Sage Evolution Business Management solution to the SME market. The management team of Kiteview have combined +30 years of experience in the delivery of small to mid-market Financial & Business Management solutions. This experience, combined with a sound project implementation methodology has helped in Kiteview’s growth, becoming a Platinum status partner for SAGE Pastel within just 1 year.

Contact Us

For An Obligation Free Quote

How CFOs can set their businesses on the track to recovery

How CFOs can set their businesses on the track to recovery

Article credit: Sage 

With South Africa complying to lockdown requirements from the government, businesses continue to face challenges.

Lord Sorrell, founder of advertising agency WPP and once CFO for Saatchi & Saatchi, says this about coronavirus: “It’s not like the dot-com bust, it’s not like 9/11, it’s not like the great financial crisis; it’s almost like a war.”

As the CFO, in the combat against coronavirus, you’re playing an important role.

You may be fortunate to be in an industry that’s experiencing high growth during these pandemic times. Lockdowns and working from home have resulted in a boom in sectors that provide products and services such as DIY and home entertainment.

Driving digital transformation

Businesses and the way they operate are undergoing a process of evolution. Customers and employees are changing and have access to a plethora of business tools that weren’t available before.

Who is driving this digital transformation? Well, according to our recent research, it’s you, the CFO.

CFOs help to shape and drive business direction and strategy. You’re more aligned with managing directors and CEOs – you don’t just crunch the numbers. You’re now required to provide up-to-date information, financial analysis and forecasting at rapid speeds

Today, the financial profession plays a key role in their organisation’s digital strategy in medium businesses, with 9 in 10 financial decision-makers doing precisely that. Meanwhile, 15% say they are fully responsible for digital transformation.

Currently, it’s not only about looking backwards into the rear-view mirror and analysing past performance. It’s about becoming a future CFO and looking forwards.

Three things to change within the finance function

When it comes to moving with the times, digitalisation is critical, with data changing the dynamics of decision making.

Technology and tools are now available to automate your financial processes. You can add the ‘why’ to what happened, using data for strategic insight.

It’s a new era where advanced technology such as artificial intelligence and machine learning are finally becoming genuine options for your business.

Here are three things to keep your finance team moving in the right direction.

1. Move from spreadsheets to software

Spreadsheets have associations with finance – think of the CFO stereotype burning the midnight oil, buried deep into the intricacies of Excel.

Today, you don’t have the time to spend hours interpreting data to create meaningful charts and graphs. And you certainly don’t want to deal with the frustrations of tying the data you have in spreadsheets together.

The right financial software can automate these processes, saving you hours in building the reports you need to present to the business.

It provides the data visibility that will help you add value to business strategy and set a suitable course in the future.

You’ll find excellent value in business intelligence, in the form of insightful dashboards and reports you can auto-generate.

2. Implement automation

Digitalisation holds great promise, but it’s no good if you spend your time collecting and preparing data, rather than analysing it. We’ve found 70% of CFOs agree that administration harms team productivity.

Your financial team’s strategic responsibilities mean it’s essential you give the grunt work to machines.

You can automate menial tasks that involve data entry such as invoice-chasing, payroll and expense management, freeing you up to make smart decisions quickly that can lead to benefits for the business.

3. Invest in financial technology

Businesses are already well aware of the impact financial technology has on improving productivity – more than 80% believes it plays a crucial role in tomorrow’s finance function.

Business leaders are aware of the benefits through centralisation with increased cost efficiencies, flexibility, integration and security. So, it’s no wonder that it can empower business.

And think about where can you be most effective. By enabling a connected operating environment that provides greater automation and advances in real-time insights, your business can truly prosper.

Take the right steps to implement change

Having the right technology is all well and good. But before you rush in and implement it, you need to understand whether your team is culturally ready for automation and other cloud technologies.

According to our research, it shouldn’t be a huge problem – 82% of financial decision-makers are already comfortable with using automation for daily accounting tasks.

However, there will be challenges.

Our research revealed 27% of financial decision-makers didn’t think their business was culturally ready for more automation.

Even though you may feel you understand the value of disruptive technologies, other employees and even those on the board may not feel that way.

Start by involving key players within the business in detailing a new automation strategy, so all parties can agree on what you can or should automate.

Take them through the process, so the team are developing and upskilling together.

Indeed, 73% of financial decision-makers believe the introduction of new technology needs a detailed implementation and roll-out plan to ensure it carefully aligns with the culture of an organisation.

The reluctance to further adopt technology may be down to more than just culture.

Amid the growing use of technology within businesses, your team may be worried about the extent to which roles will be automated in the future.

For companies to get the most from technology, there needs to be an alignment between strategy and the culture and reassurance that roles won’t be lost but will instead change focus towards positions that add move value to the business.

Final thoughts

Shaping the strategy is akin to shaping the business, and you are the visionary. You’re responsible for predicting the direction of the company, uncovering hidden opportunities and closing gaps within an organisation that is increasingly data and insights-driven.

As such, it’s worth making investments in digital platforms, tools and systems today so your business can prosper both now and in the future.

About Us
Kiteview Technologies (Pty) Ltd was founded in May 2010 to provide the Sage Evolution Business Management solution to the SME market. The management team of Kiteview have combined +30 years of experience in the delivery of small to mid-market Financial & Business Management solutions. This experience, combined with a sound project implementation methodology has helped in Kiteview’s growth, becoming a Platinum status partner for SAGE Pastel within just 1 year.

Contact Us

For An Obligation Free Quote

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!