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

Article, Knowledgebase

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

View Our Client Testimonials

View Our Knowledge Base

Share:

Subscribe

Sage Referral Partner Sage VIP

Subscribe To Our Newsletter

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

You have Successfully Subscribed!