Foreign Trader - Print an invoice in your customer's currency

How to print invoices in the customer's currency using Foreign Trader in Sage 50 Accounts.

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 the customer.

If your layout only shows values in your base currency, you can edit the layout to include the FOREIGN variables:

1. Select the document you want to amend, then press Edit.
2. 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 >

3. On the menu bar press File, then choose Save As.
4. Enter a new file name then press Save.
5. On the menu bar select File, then press Exit.