Skip to content
logo Knowledgebase

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

Created on  | Last modified on 

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:

  1. Select the document you want to amend, then click Edit.
  2. Select the data fields that show base currency and replace them with the FOREIGN equivalent below:

    Data fieldReplace with
    INVOICE.NET_AMOUNTINVOICE.FOREIGN_NET_AMOUNT
    INVOICE.GROSS_AMOUNTINVOICE.FOREIGN_GROSS_AMOUNT
    INVOICE.TAX_AMOUNTINVOICE.FOREIGN_TAX_AMOUNT
    INVOICE_ITEM.NET_AMOUNTINVOICE_ITEM.FOREIGN_NET_AMOUNT
    INVOICE_ITEM.TAX_AMOUNTINVOICE_ITEM.FOREIGN_TAX_AMOUNT
    INVOICE_ITEM.GROSS_AMOUNTINVOICE_ITEM.FOREIGN_GROSS_AMOUNT

    TIP: For help adding data fields, you can view our help guide. Read more >



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