The Financial and Distribution Exchange Rate files are in one file. This file contains potential for multiple rate tables with a common process for retrieving and calculating exchange rates. Control files have been created that contain the various rate tables, rules, exchange rate descriptions and base currencies used by your Company.
Each business process is labelled with an identifier called ‘rate type’ in ********/EXC-RTYP. Control file ********/EXC-SEL points each rate type to a rate table so there is flexibility in separating or combining rates for various purposes.
| Rate type (********/EXC-RTYP) | Rate type code |
| STD AVG | 1 |
| STD EOM | 2 |
| Blank (User definition) | 4 |
| TMSDS/PSI-EXCD | 5 |
| STD COST | 6 |
| APMEND | 7 |
| CUSTOMS | 8 |
| WS CHARGE | 9 |
Following control files are required to be setup:
- ********/EXC-DSC Foreign Currency exchange codes
- ********/EXC-RTYP Exchange rate type (System defined)
- ********/EXC-SEL Exchange rate table selection rules
- ********/EXC-TBL Exchange rate tables
- ********/EXC-TBLB Exchange rate based on table
- ********/EXC-TBLP Exchange rate table: Pegged rate
- ********/EXC-TOR Exchange rate tolerance
- ********/CONO-BAS Base Currencies by company
The following list of programs use a specific rate type; all other programs and reports use type 4 which is user defined:
View the list of programs| Program | Name | Code |
| APE010C | Invoice/Credit entry –header | 1 |
| APE010D | 1 | |
| APE020C | Already paid invoice entry – header | 1 |
| APE020D | 1 | |
| APE021C | Already paid invoice entry – header | 1 |
| APE021D | 1 | |
| APR620C | Cash requirement report – sort by cred number | 1 |
| APR620F | Cash requirement report – sort by cred name | 1 |
| APW042A | Payment Cycle Final Update for FXP-Baseval input | 1 |
| APW065B | Payment update & register print – main update | 1 |
| DSO354C | Agent commission – post transactions to A/P | 1 |
| EDO705B | Interface to AP | 1 |
| GLE030 | Bank statement entry | 1 |
| GLO030C | Bank statement upload – Update | 1 |
| PUM200B | FX Contract Maintenance | 1 |
| RBO160G | Generate payment – A/P invoice | 1 |
| RYO025C | Royalty recovery/offset post to G/L | 1 |
| RYO060E | Royalty balances update – Update C/F & Pay | 1 |
| RYO070C | Royalty interface to A/P | 1 |
| RYO185C | Accrual and Provision Update and Post | 1 |
| WSO050G | W/C EOM Interface – Accounts Payable Cheques | 1 |
| WSO060C | Extended Warranty Accrual and GL Post | 1 |
| APO200C | Currency exchange gains ad losses adjustment | 2 |
| ARO080B | Currency exchange variance adjustment | 2 |
| BPO100A | Paper Issue/Return update to WIP – Commitment | 1,2 |
| BPO100B | Paper Issue/Return update to WIP – Actual | 1,2 |
| BPR390C | BP/DS Interface reconciliation report | 1,2 |
| GLO284B | Foreign currency translation | 1,2 |
| GLO286 | Foreign currency conversion for glbud | 1,2 |
| GLO286B | Foreign currency conversion for glbud | 1,2 |
| GLR050D | G/L trial balance – print report | 1,2 |
| GLR370F | Detail trial balance – CO/PC/AM/AN | 1,2 |
| GLR370G | Detail trial balance – CO/AM/AN/PC | 1,2 |
| GLR370H | Detail trial balance – CO/AN/AM/PC | 1,2 |
| GLR370I | Detail trial balance – CO/AN/PC/AM | 1,2 |
| DSE152C | PSI simulation main program | 5 |
| DSE152E | PSI simulation so maintenance | 5 |
| DSI152C | PSI Summary by Category – Summary by Cat/Item | 5 |
| DSI154 | PSI Sales Allocation | 5 |
| DSO154C | PSI – Export PSI data to PC | 5 |
| DSO635C | PSI – P/O generation Update | 5 |
| DSR822C | PSI Purchase Budget Report – Report print (21-21) | 5 |
| DSR823C | PSI – Report Foreign exchange – Build workfile | 5 |
| DSR888C | Product sales/purchases/inventory report | 5 |
| DSR889C | Product PSI by currency report | 5 |
| DSO118C | Bonus generation by order | 6 |
| DSO118D | STD cost re-calculation process | 6 |
| DSO272G | G/L interface workfile generation – Build GIF,GIG | 7 |
| DSR240C | Duty calculation program – workfile build | 8 |
| DSO950D | Transfer PSI sales to forecast | 4,5 |
| WSI100B | Job total costs calculation inquiry | 9 |
| WSO100 | Status validation and update | 9 |
Contents
Work with exchange rate
- In the menu, expand Base Modules > Distribution > Masterfiles > Database Management > Database Management > Exchange Rate Management > Exchange Rates Mastefiles and double-click Work with Exchange Rates. XAW100 Work with Exchange Rates panel appears.
| Field | Description |
| Effective period | This is used to specify the effective period for which rates are to be maintained. In Exchange Rate Management this defaults to the current processing period. Enter another period if required for future processing. |
| Table | This displays the Table ID and Description. Example Table 001 Financial, Table 002 Distribution. |
- Select a record and click Work with. XAW100 Work with Exchange Rate panel appears in change mode.
| Field | Description |
| Base currency | The Base currency that has been established in ********/EXC-TBL will display. |
| Foreign currency | The Currency Codes along with its description as established in ********/EXC-DSC will display. |
| Average | This is the rate for each exchange rate that is being used by your Company. |
| EOM | This column will only display if defined in *******/EXC-TBL. Maintain the rate for each exchange rate that is being used by your Company for EOM. |
Additional Notes
Rates based on another table
Control file ********/EXC-TBLB can be configured to allow exchange rates to be retrieved from a different table (base table) based on the transaction period.
As per above control file setting, for the period of ‘201505’, the exchange rate for table 003 is derived from table 001 as displayed in the screen below. The transaction period has to be equal or greater than the period in the control file to use the referenced table.
Maintenance of referenced table is not allowed when accessed via another table.
Pegged exchange rate
Pegged currencies (fixed exchange rate against another currency) can be configured in control file ********/EXC-TBLP. The exchange rates for the pegged currency will be based on this configuration for the effective period as long as the base currency of the table is not the same as the pegged currency.
