Inventory, Order Entry, Point Of Sale, Job Costing: Inserting, showing, displaying  Foreign Currency Abbreviation on source document/report layouts, if not using User Defined Fields

Learn how to insert, show, display the Foreign Currency Abbreviation on source document/report layouts if not using User Defined Fields, in Sage 200 Evolution.

This article discusses insert, showing the Foreign Currency Abbreviation on source document/report layouts. This is especially relevant when you don’t want to use a User Defined Field. 

For instance, you are trading with a US Dollar Foreign Currency customer/supplier and need to show the USD foreign currency symbol on the printed source document (Customer/Supplier Invoice).

 

 

First, note the following: 

This article assumes that you have a basic understanding of how to navigate to and work in the Report Writer’s Design screen in order to edit, and maintain source document/report layouts. 

If not, please consult with your local Sage 200 Evolution Business Partner.

 

Apply the following steps to achieve the above outcome:

1. Go to Common | Maintenance | Company Details | Company tab.

2. Identify a field that is not in use and that you will not like use in the future, e.g., Telephone 2 or Fax.

3. Capture the relevant foreign currency abbreviation. In this case, it is USD.

4. Save your changes when done.

5. Navigate to and open the relevant source document layout’s Design screen. This layout could be one of your currently customised layout.

6. On the Design screen, insert a new DBText field in the required location on the layout.

7. Define the new DBText field as follows:

• Data Pipeline: CompanyDetails
• Field: Telephone 2 (this should be the same field as used in Step 3 above).

       

8. When done, save your changes.

9. When the customised source document/report is printed, the above inserted foreign currency abbreviation should now be displayed.