Currency rate

When you run the Currency correction processing from the Customer transaction, Supplier transaction or General ledger transaction tables, the program locates the currency correction exchange rate in the following, prioritised sequence:

1. From the Calculate rate field in the Currency rate table.
   • Retrieves the exchange rate on the date that is equal to the date that you enter in the dialog box for the Currency correction processing.
2. From the Calculate rate field in the Currency rate table.
   • Retrieves the exchange rate on the date that is closest and lower than the date that you enter in the dialog box for the Currency correction processing.
3. From the Calculate rate field in the Currency table.
   • Retrieves the exchange rate.
4. From the Sales rate field in the Currency rate table.
   • Retrieves the exchange rate on the date that is equal to the date that you enter in the dialog box for the Currency correction processing.
5. From the Sales rate field in the Currency table.
   • Retrieves the exchange rate on the date that is closest and lower than the date that you enter in the dialog box for the Currency correction processing.
6. From the Sales rate field in the Currency table.
   • Retrieves the exchange rate.

This field MUST be filled out if you are subject to the MOSS (Mobile One Stop Shop) VAT regulation.

When the program searches for the exchange rate for a given date, it chooses the exchange rate in the row where the value in From date field is equal to the date in question or the first which is less than this date. The program skips rows with no value in the Currency rate field.

If there is no such row in the Currency rate table, the Currency table is used.

Date Used

Voucher lines

On the vouchers, the program will match the from date to the following possible dates in the following order from highest to lowest priority.

1. Voucher date in the Voucher table.
2. Value date in the Voucher table.
3. Value date in the Batch table
4. Today's date

If the value in the From date field is changed and the Currency no. field in the Voucher table is updated again, the exchange rate is updated as well.

When filling in missing values in the Voucher record in connection with import, the value in the Value date field from the Batch record is not used.

Budget lines

In the Budget line table the date in the Date field will used as a basis, or the current day's date if the field is not filled in. If the Date field in the Budget line table is changed and the Currency no. field has a value, the exchange rate is updated as well.

Price refunds

In the Price refund table, the current date is used as the basis. This applies to both manual and automatic completion in the table.

Totals Lines

When printing totals lines in reports, the current date is used as the basis.

Accounting reports

The current date is used as the basis in the dialog boxes for these reports and processings:

• The Account statement for customers, Account statement for suppliers, Balance list for customers and Balance list for suppliers reports in the Associate table.
• The profit and loss and balance sheet reports.
• The Change default currency processing in the Company information table.

Order

In the Order, Order line and Reservation tables, the current date or the value in the Order date, Trans. date or Confirmed delivery date fields are used, depending on what is chosen in the Comparison date field in the Company information table. This also be used as the basis when looking up in the Price- and discount matrix and Stock balance tables.

This also applies when a currency number is suggested in the Associate table, and in the Product transaction table for invoice plan differences.

When the Order date or Confirmed delivery date fields in the Order table changes, the value in the Exchange rate and Cost exchange rate fields will be fetched again in the order head. This happens according to the current value in the Comparison date field in the Company information table.

When the Trans. date or Confirmed delivery date fields in the Order line table changes, the value in the Exchange rate and Cost exchange rate fields will be fetched again on the order line. This happens according to the current value in the Comparison date field in the Company information table.

Note:

The exchange rate must temporarily be the same on the order and on all order lines.

Misc.

The same dates as stated above are used as the basis when calculating equivalent amounts in EURO with the exception that values from head rows are not considered.

The value in the Voucher date field in the Updated voucher table is also used as the basis in the Updated voucher, Customer transaction, Supplier transaction, General ledger transaction, Capital asset transaction, Open customer entry and Open supplier entry tables.

In the Product transaction table, the value in Trans. date field is used as the basis.

Justification

In connection with exchange rate justification when printing order documents, the invoice date stated in the order document dialog box is used as the basis.

The date is validated using the regional settings in Windows.