Currencies and Exchange Rates
This chapter contains all essential information regarding currencies and exchange rates. It is divided into the following sections:
- Setting up Foreign Currencies
- Assigning Foreign Currency to Customer
- Assigning Foreign Currency to Vendor
- Assigning Foreign Currency to Bank Account
- Activating Foreign Currencies for Documents
- Enabling Currency Exchange Rate Service
- Updating Exchange Rates
- Adjusting Exchange Rates
Setting up Foreign Currencies
In the Currencies table, you can set up foreign currencies. Your own currency, e.g., Euro, is not displayed because it is used by default and controlled by your regional settings. To set up a new foreign currency, proceed as follows:
- Use the quick search (ALT+Q) to find the Currencies page.
- Click on New in the menu bar.
- Fill in the fields on the currency card according to the following table:
FastTab | Field | Description |
---|---|---|
General | Code | Enter a unique code in this field, e.g., CAD. |
Description | Enter a unique description in this field, e.g., Canadian Dollar. | |
ISO Code | Enter the three-letter currency code as defined in ISO 4217 in this field. | |
Symbol | Enter a symbol for the currency in this field, e.g. $. | |
Unrealized Gains Acc. | Enter the general ledger account to which unrealized exchange rate gains are posted when you run the batch job Adjust Exchange Rates. | |
Realized Gains Acc. | Enter the general ledger account to which realized exchange rate gains are posted. | |
Unrealized Losses Acc. | Enter the general ledger account to which unrealized exchange rate losses are posted when you run the batch job Adjust Exchange Rates. | |
Realized Losses Acc. | Enter the general ledger account to which realized exchange rate losses are posted. | |
EMU Currency | Activate this toggle switch if the currency is an EMU currency. | |
Last Date Modified | This field indicates the most recent date on which data in the Currency table was changed. | |
Last Date Adjusted | This field indicates the date on which the exchange rates were last adjusted. It corresponds to the time of the last execution of the Adjust Exchange Rates batch job. | |
Payment Tolerance % | This field indicates the percentage by which a payment or refund may deviate from the invoice or credit memo amount. | |
Max. Payment Tolerance Amount | This field indicates the maximum allowable amount by which a payment or refund may deviate from the invoice or credit memo amount. | |
EMU Import | Select one of the following options for the EMU import in this field: Select Disabled if the currency should not be considered during the exchange rate import. Select Insert if new lines are to be created for new date entries. Select Update if existing exchange rate lines are to be adjusted as required. Select Insert and Update if both existing lines are to be adjusted and new date entries added. | |
Rounding | Invoice Rounding Precision | Enter the interval size for rounding amounts in this currency. In the Currency table, you can specify individual invoice rounding for each currency. |
Invoice Rounding Type | Specify in this field whether the invoice amount should be rounded up or down. | |
Amount Rounding Precision | Enter the interval size for rounding amounts in this currency. | |
Amount Decimal Places | Enter the number of decimal places to display amounts in this currency. | |
Unit-Amount Rounding Precision | Enter the interval size for rounding unit prices, i.e., item prices per unit, in this currency. | |
Unit-Amount Decimal Places | Enter the number of decimal places to display amounts in this currency in this field. | |
Appln. Rounding Precision | Enter the interval within which rounding differences are permissible when an entry in this currency is to be cleared against an entry in another currency. | |
Conv. LCY Rndg. Debit Acc. | Enter the conversion information, which must also include a debit account, if you want to create correction lines for rounding differences in general journal lines using the Insert Conv. LCY Rndg. Lines function. | |
Conv. LCY Rndg. Credit Acc. | Enter the conversion information, which must also include a credit account, if you want to create correction lines for rounding differences in general journal lines using the Insert Conv. LCY Rndg. Lines function. | |
Max. VAT Difference Allowed | Enter the maximum allowed VAT adjustment for the currency. | |
VAT Rounding Type | Specify how VAT should be rounded when calculated for this currency. | |
Reporting | Realized G/L Gains Account | Enter the general ledger account to which exchange rate gains from currency adjustments between the local and reporting currency are posted. |
Realized G/L Losses Account | Enter the general ledger account to which exchange rate losses from currency adjustments between the local and reporting currency are posted. | |
Residual Gains Account | Enter the general ledger account to which rounding gains are posted when accounting is performed in both the local and reporting currency. | |
Residual Losses Account | Enter the general ledger account to which rounding losses are posted when accounting is performed in both the local and reporting currency. |
- Click on Home > Exch. Rates in the menu bar.
- Fill in the table to set up the exchange rates manually. If you are using a Currency Exchange Rate Service, this step is not necessary, as the rates are updated automatically. You’ll find more information on updating exchange rates in the Updating Exchange Rates section.
You have successfully set up a foreign currency.
Assigning Foreign Currency to Customer
In TRASER DMS 365, you have the option to assign foreign currencies directly on the customer card. All documents, such as quotes, orders and invoices, for this customer will then be automatically created in the assigned currency. To assign a foreign currency to a customer, proceed as follows:
- Use the quick search (ALT+Q) to find the Customers page.
- Open the desired customer.
- Navigate to the Invoicing FastTab.
- Select the desired foreign currency code in the Currency Code field.
You have successfully assigned a foreign currency to a customer. All newly created documents for this customer are automatically processed in the assigned currency. If set up, exchange rates are also automatically applied when posting the documents.
Assigning Foreign Currency to Vendor
In TRASER DMS 365, you have the option to assign foreign currencies directly on the vendor card. “Incoming orders, invoices and credit memos for this vendor are then automatically processed in this currency. To assign a foreign currency to a vendor, proceed as follows:
- Use the quick search (ALT+Q) to find the Vendors page.
- Open the desired vendor.
- Navigate to the Invoicing FastTab.
- Select the desired foreign currency code in the Currency Code field.
You have successfully assigned a foreign currency to a vendor. All newly created documents for this vendor are automatically processed in the assigned currency. If set up, exchange rates are also automatically applied when posting the documents.
Assigning Foreign Currency to Bank Account
In TRASER DMS 365, bank accounts can be maintained in different currencies. This is especially important if your company holds foreign currency accounts with banks. All payments and postings through this account are then automatically processed in the assigned currency. To assign a foreign currency to a bank account, please proceed as follows:
- Use the quick search (ALT+Q) to find the Bank Accounts page.
- Open the desired bank account.
- Navigate to the Posting FastTab.
- Select the desired foreign currency code in the Currency Code field.
You have successfully assigned a foreign currency to this bank account. All payments and postings through this account are then automatically processed in the assigned currency. If set up, exchange rates are also automatically applied when processing documents.
Activating Foreign Currencies for Documents
TRASER DMS 365 allows you to print amounts in client currencies directly on your documents. The function is currently available in the following documents:
Area | Document Types |
---|---|
Sales | Sales Quote, Sales Order, Sales Return Order, Sales Credit Memo, Sales Invoice |
Service | Service Quote, Service Order, Service Credit Memo |
Rent | Rental Quote, Rent Contract, Rental Invoice, Rental Credit Memo, Sub-Rent Contract, Sub-Rent Invoice, Sub-Rent Credit Memo |
Note
The procedure is described below using the example of a sales order. You can apply these steps to the other documents that are mentioned above. The functionality is the same for all documents.
To activate the function, please proceed as follows:
- Use the quick search (ALT+Q) to find the Sales Orders page.
- Open an existing sales order.
- Navigate to the Invoice Details FastTab.
- Activate the Print Values in Customer Currency toggle switch.
You have successfully specified that foreign currencies should be printed in the selected report. The report of the corresponding document will show the customer currency amounts, which are calculated using the current exchange rate and displayed next to the document currency amounts.
Enabling Currency Exchange Rate Service
The currency exchange rate service helps you automatically adjust and update exchange rates. Please proceed as follows to enable a currency exchange rate service:
- Use the quick search (ALT+Q) to find the Currency Exchange Rate Services page.
- Select the ECB exchange rate service and click Enable in the menu bar.
You have successfully enabled the currency exchange rate service.
Updating Exchange Rates
Note
The following instructions assume that you have already set up a currency exchange rate service. If you prefer to set exchange rates manually, see Setting up Foreign Currencies for more information.
You can set up a job queue to update the exchange rates. This ensures that the foreign currency rates are automatically updated at specified intervals. To do so, please proceed as follows:
- Use the quick search (ALT+Q) to find the Currency Exchange Rate Services page.
- Open an existing currency exchange rate service card.
- Click Job Queue Entry in the menu bar.
- In the General FastTab, fill in the basic information for the job queue entry, such as the object type, object ID and an appropriate description.
- Navigate to the Recurrence FastTab.
- Activate the toggle switches for the weekdays on which the exchange rates should be automatically updated via the job queue.
- Make additional settings as needed.
- In the menu bar, click Start > Set Status to Ready to complete the job queue setup.
You have successfully set up a job queue for the automatic updating of exchange rates.
Tip
If no job queue entry has been set up for automatic updating, you can update the exchange rates manually. To do this, open the Currencies page via the quick search (ALT+Q) , select Exchange Rate Service from the menu bar, and then choose Update Exchange Rates. The exchange rate values are then updated with the latest rates from the exchange rate service.
Adjusting Exchange Rates
Note
The following instructions assume that you have already set up a currency exchange rate service.
Since exchange rates fluctuate constantly, they must be adjusted regularly to ensure that foreign currency amounts in the general ledger remain accurate. An update adjusts the current rates but does not correct transactions that have already been posted. In such cases, manual adjustment via the currency exchange rate service is required. To adjust the rates for posted customer, vendor and bank account entries, please proceed as follows:
- Use the quick search (ALT+Q) to find the Currencies page.
- Click on Home > Adjust Exchange Rate in the menu bar.
- In the Options FastTab, make the desired settings.
- If needed, you can also set up various filters in the corresponding FastTabs.
- Now, run the report.
You have successfully adjusted the exchange rates.