Understanding Exchange Rate Table Setup
In Poland, invoices that include a foreign currency must include:
The exchange rate.
You set up exchange rates in the Currency Exchange Rate Entry program (P0015A) in the base software.
The exchange rate table number that includes the exchange rate used, as published by the National Bank of Poland (NBP).
The NBP publishes a new, numbered exchange rate table when the official exchange rate changes.
The date of the exchange rate table number.
You use the Exchange Table Number program (P74P0001) to enter the exchange rate table number and the date of the exchange rate table. You can enter one exchange rate table number per date. The system stores the data that you enter in the Exchange Table Number table (F74P0001).
When you print invoices from the JD Edwards EnterpriseOne Accounts Receivable or the JD Edwards EnterpriseOne Sales Order Management system, the system prints the exchange rate table number and corresponding date for the table using this hierarchy:
If an exchange rate table number exists in the F74P0001 table for the date on which the invoice is entered, the system prints that exchange rate table number and its corresponding date for the table.
For example, if you enter an invoice on October 20 and the F74P0001 table includes an exchange rate table number for October 20, the system prints the table number entered for October 20, and prints October 20 as the date of the exchange rate table number.
If no exchange rate table number exists in the F74P0001 table for the date on which the invoice is entered, the system searches for the most recent prior date for which an exchange rate table number exists and prints that date and corresponding exchange rate table number.
For example, if you enter an invoice on October 20 and the F74P0001 table does not include an exchange rate table number for October 20, the system searches for the most recent prior date to October 20 for which an exchange rate table number exists. If no exchange rate table number exists for October 19, the system searches for an exchange rate table number for October 18. If no exchange rate table number exists for October 18, the system searches for an exchange rate table number for October 17. The system continues searching prior dates until it finds an exchange rate table number in the F74P0001 table. When the system finds an exchange rate table number (for example October 14), it prints that exchange rate table number and prints the date of the exchange rate table number on the invoice.