Language:


Using Currencies in Invoices and Other Sub System Transactions - Item Prices

This page describes adding Items to and changing prices in Sub System Transactions in Currency.

---

When you add Items to a transaction such as an Invoice, Sales Order or Purchase Order, their prices will be converted from your home Currency to the transaction Currency using the conversion rates shown on the 'Currency' card.

If you wish to change the conversion rates in a particular transaction, you can do so providing you have not selected the Prevent Base Rate Changes and Prevent Foreign Rate Changes options in the relevant Currency record. If you need to change the conversion rate, it is recommended that you do so before adding any Items to the transaction, to ensure their prices are converted correctly. Prices of any Items that you have already added to the transaction may or may not be updated if you change the Currency or conversion rate, as follows:

  • If you change the Currency in a Sales or Purchase Order, Quotation or Opportunity, prices of any Items that you have already added to the transaction will be updated so that they are now expressed in the new Currency. If you change the Currency in a Goods Receipt, prices of existing Items will again be updated, but this time the value in your home Currency will be changed (i.e. the Cost Price in each row will be updated).

  • If you change the date in any transaction, conversion rates will be updated automatically. In the case of Invoices, Sales Orders, Quotations and Project Budgets, the prices of any Items already in the transaction will be updated automatically and immediately, providing you are using the Update Prices on records with Currency when changing Dates option in the Item Settings setting in the Sales Ledger. In a Goods Receipt, the Cost Price in each existing row will always be updated.

  • If you change the conversion rate in a Goods Receipt, the Cost Price in each existing row will always be updated.

  • If you change the Currency, date or conversion rate in an Invoice, Sales Order, Quotation or Opportunity and the prices of Items already in the transaction are not updated automatically, you can update them by selecting 'Update Currency Price List Items' from the Operations menu (Windows/Mac OS X) or Tools menu (iOS/Android).
In general, if the Exchange Rate or Base Currency Rate has changed, you should first go to the System module and enter the new rates before you start entering the day's transactions.

The Base field in the footer area of the Opportunity, Quotation, Sales Order and Sales Invoice windows will show the total value of the transaction (including VAT if appropriate) in your home Currency.

In Quotations, Sales Orders and Sales Invoices, the Sum, VAT and TOTAL figures will be rounded using the rounding rules that you have specified for the Currency/Register/Payment Term combination in the Currency Round Off setting. If you have not specified rounding rules for that combination in the Currency Round Off setting, rounding rules will be taken from the Round Off setting. In other registers, rounding rules will only be taken from the Round Off setting.

---

Using Currencies in transactions of various kinds:

Go back to: