OVERVIEW
Sales, Jobs and Purchase Orders can be prepared in currencies other than the normal system currency. Any currency that you wish to use must be defined in the currency control window.
Each Customer and Supplier can be given a default currency for Sales, Jobs and Purchase Orders.
Parts can have up to five currency prices. For this, the currency symbols must be defined in the Company Details Maintenance window.
This article is part of the Vision Setup Guide. Click Here to return to the Setup Guide.
File Path
The file path File > System Manager > Currencies… takes you to the Currency Control window. This window has three tabs.
Setup Currencies Tab
Setting up currencies
To set up a currency select the New button.
You can enter up to three characters in the currency symbol field eg. GBP or EUR
Warning – You must NOT enter your local currency which is defined in the Company Details Maintenance window.
In the Decimal character field enter the appropriate symbol for the decimal of that currency eg: for GBP enter p or for EUR enter C.
Enter the currency name in the Name field eg. Great British Pound or Euro
Click save.
Warning – Once you have created a currency record, you will not be able to change the symbol.
BUTTONS AND FIELDS
Currency Symbol
The symbol, of up to three characters, you enter here identifies the currency uniquely.
Decimal Character
In this field you enter the decimal character of your chosen currency
TIP – If you use the # (hash or pound) character as your currency decimal character the cent portion of an amount printed in words on documents such as sales orders, invoices and cheques is suppressed. This feature is provided for large scale currencies such as Rupees and Yen.
Name
This is the currency name
Cancel Button
This will abort the process currently in session.
Save Button
This will confirm and save the new currency.
New Button
This creates a new blank record for you to enter details of a new currency.
Delete Button
Selecting this will permanently delete the currently selected record from the file.
INFORMATION – When you attempt to delete a currency using this button, the system will first check that the currency is not used elsewhere. This can be a slow process. Checks are carried out that the currency is not used in:
1. Company Details part currency prices
2. Invoices that have not yet been paid
3. Jobs
4. General Ledger accounts
5. Purchase Orders
6. Sales Orders
7. Customers
8. Suppliers
Having completed the checks without locating any references to the currency, you will be asked to confirm the deletion, otherwise you will be prevented from deleting it.
Adjust Rate Tab
In this tab you can adjust exchange rates for foreign currency accounts.
BUTTONS AND FIELDS
Currency List Field
Here you will see a list of all currencies you have entered in the Setup Currencies tab.
Currency Field
This shows the currency you have highlighted ready to work on.
Last changed Field
Here you will see the date and time the highlighted currency was last amended.
Exchange Rate
The value of the currency in relation to 1 unit of your normal currency. For example, if your normal currency is US Dollars and you wish to deal in UK Pounds, the exchange rate will be approximately 0.670000 (USD being worth approximately GBP0.67). You can use up to 14 decimal places, however normal currency trading is to 4 decimals (6 in Euro zone).
Reciprocal Rate
The value of the reciprocal of the foreign currency exchange rate.
European Monetary Union
With this extended area you can:
1. Calculate an exchange rate from its reciprocal.
2. Enter a triangulation currency which must be already defined as a normal currency. Then enter the exchange rate (or reciprocal) of the currency you are creating.
3. Enter a value in the currency or your local currency for which ECU triangulation rounding will apply.
All three will compute a new exchange rate for your new currency, which can be accepted with an Ok.
Print Analysis of Outstanding A/P and A/R Currency Transactions button
This provides a report for all A/P and A/R transactions that have some due amount and are in a foreign currency. It shows the local value of the transaction and the value calculated from the current currency exchange rate. The difference is potentially the exchange loss or profit that will occur, were the rates to remain as they currently are.
You can change the Destination of the report by selecting the ‘Report Destination’ menu command. This function is only available if you have the Ledgers license option.
TIP – This can be used for assessing a Provision for Foreign Exchange Movement, which would typically be a balance sheet account adjusted by way of a month-end journal.
Print List button
Selecting this button will cause a report to be printed of the subject matter. You can change the Destination of the report by selecting the ‘Report Destination’ menu command.
Revert to Saved
This will abandon any changes made and revert to the last saved version.
Apply New Rates
Select this button to apply the amended listed rates. You will be asked for a log comment.
Re-value System
To re-value Orders and Accounts to the latest currency rates, where applicable. This function opens the Currency Re-valuation window.
Adjust Rate Tab
In this tab you can see a history list of all rate changes for each currency.
Changes Log List
You can see the date, and time each rate was changed by highlighting each currency in the list above. You can also see the old and new rates and which user made the change. You can edit the comments field.
Print Log Button
This will print a currency changes log for the highlighted currency.
This article is part of the Vision Setup Guide. Click Here to return to the Setup Guide.
Compiled in Program Version 6.00. Help date last modified on 24 June 2021
Class wAcCurrency (Currancy Control) FP: File > System Manager > Currencies…
