Summary
How to print invoices in the customer's currency using Foreign Trader in Sage 50 Accounts.
Description
All standard layouts in the software are set up to automatically show the invoice values in the customer's currency.
This is because they contain FOREIGN variables. For example FOREIGN_INVOICE_NET shows the net amount of the invoice, but is flexible to change the currency depending on customer.
Let's take a look.
Resolution
If your layout only shows values in your base currency, you can edit the layout to include the FOREIGN variables:
- Select the document you want to amend, then click Edit.
- Select the data fields that show base currency and replace them with the FOREIGN equivalent below:
Data field Replace with INVOICE.NET_AMOUNT INVOICE.FOREIGN_NET_AMOUNT INVOICE.GROSS_AMOUNT INVOICE.FOREIGN_GROSS_AMOUNT INVOICE.TAX_AMOUNT INVOICE.FOREIGN_TAX_AMOUNT INVOICE_ITEM.NET_AMOUNT INVOICE_ITEM.FOREIGN_NET_AMOUNT INVOICE_ITEM.TAX_AMOUNT INVOICE_ITEM.FOREIGN_TAX_AMOUNT INVOICE_ITEM.GROSS_AMOUNT INVOICE_ITEM.FOREIGN_GROSS_AMOUNT
TIP: For help adding data fields, you can view our help guide. Read more > - On the menu bar click File, then click Save As.
- Enter a new file name then click Save.
- On the menu bar click File, then click Exit.