Multi Currency and Finance Integration

In the finance integration, it displays the data relating to debtors, sales, wages, uninvoiced sales and unpaid wages that have been allocated to account codes to use in financial applications.

The changes for multi currency have been applied to Debtors and Invoiced Sales.

Debtors extract has had an additional column added to output the debtor’s invoice currency.
Sales invoices have additional columns available that output the currency conversion values.
Uninvoiced sales do not have currency values because the timesheet transactions have not been processed through Invoice Batch Creation which is where the currency conversions take place.
Wages only have net pay converted for the convenience of paying into a different country and not for the balancing of the general ledger

The following columns have been made available for managing currency values.

Field	Description	Rules

Field	Description	Rules
Debtor
Debtor Currency Code	This is the currency code of that the debtor wishes to receive invoices in	Column displayed if the billing company country has multi currency feature enabled. Displays the currency code that is set against the debtor. If the debtor does not have a currency code, the billing company currency code will be output as default.
Sales
Currency Code	The currency code of the invoice/credit note	Column displayed if the billing company country has the multi currency feature enabled. This is the currency code that was used in the invoice. If the debtor did not have a currency code, the billing company currency is displayed.
Exchange Rate	Exchange Rate used on the invoice/credit note	Column displayed if the billing company country has the multi currency feature enabled. The exchange rate that was used on the invoice/credit note. If there was no exchange rate, 1.00 is displayed.
Currency Invoice Total	The currency invoice total before tax	Column displayed if the billing company country has the multi currency feature enabled. If there was no converted currency, it is populated with the same figure as the Invoice Total amount column.
Currency Invoice Total Inc Tax	The currency invoice total including tax	Column displayed if the billing company country has the multi currency feature enabled. If there was no converted currency, it is populated with the same figure as the Invoice Total Inc Tax column.
Currency Tax Total	The currency invoice tax total	Column displayed if the billing company country has the multi currency feature enabled. If there was no converted currency, it is populated with the same figure as Tax Total column.
Currency Bill Amount	The currency bill amount where a different currency was used to the base currency	Column displayed if the billing company country has the multi currency feature enabled. If there was no converted currency, it is populated with the same figure as the bill amount column.
Currency Tax Amount	The currency tax amount where a different currency was used to the base currency	Column displayed if the billing company country has the multi currency feature enabled. If there was no converted currency, it is populated with the same figure as the tax amount column.