Versions Compared

Old Version 2

changes.mady.by.user Vicky Lau

Saved on

compared with

New Version Current

changes.mady.by.user Vicky Lau

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

6. Excel file with selected field and existing database record to be export.

NOTE:

(1) DON'T change the package information in Row 1

(2) DON'T change the table field name (i.e. column name) and the column sequence

7. Update the exchange rate in excel file

(1) Change the new start date (in this case example, we want to update exchange rate for April 2023)date 

(2) Enter the updated Relational Exch. Rate Amount 

...

8. Save the excel file after updated

9. Go back to Configuration Package, Select Excel => Import from Excel

Image Modified

10. Click Choose... to select file for import

Image Modified

11.  Click Import to import the excel file

Image Modified

12.  Select “Functions” => “Apply Data” 

13. Review Currency Exchange Rate

*Please see how to reset system filter in How to preview Exchange Rate for all Currency in a single page

 Image Modified