This appendix contains the following topics:
To upload foreign vouchers from an external source, you must write a custom program that maps the fields in the source system to the fields in the JD Edwards EnterpriseOne Accounts Payable system. The tables in this appendix discuss the relationship between specific fields, such as the base currency code, transaction currency code, and currency mode fields, the currency-specific mapping requirements for the Batch Vouchers (F0411Z1) and the Journal Entry Transactions - Batch File (F0911Z1) tables.
Review the non-currency mapping requirements for processing batch vouchers.
Observe these guidelines to determine how to enter amounts, exchange rates, and currency modes for domestic and foreign transactions when processing batch vouchers in a multicurrency environment:
| Type of Transaction | Description of Values for Multicurrency Fields |
|---|---|
| Domestic | If the currency code of the transaction (identified by the value in the Currency Code field, VLCRCD) is equal to the currency code of the company, the transaction is a domestic transaction.
Enter the transaction amount in the Gross Amount field (VLAG) and enter D in the Currency Mode field (VLCRRM). Do not enter an exchange rate. If you are entering discount information, complete the Discount Available field (VLADSC). If you are entering tax information, complete the Taxable Amount (VLATXA), Non-Taxable Amount (VLATXN), and Tax Amount (VLSTAM) fields. |
| Foreign | If the currency code of the transaction (identified by the value in the Currency Code field, VLCRCD) is different from the currency code of the company, the transaction is a foreign transaction.
Enter the transaction amount in the Currency Amount field (VLACR) and enter F in the Currency Mode field (VLCRRM). The system calculates the domestic amount based on the Exchange Rate field (VLCRR). If you are entering discount information, complete the Foreign Discount Available field (VLCDS). If you are entering tax information, complete the Foreign Taxable Amount (VLCTXA), Foreign Non-Taxable Amount (VLCTXN), and Foreign Tax Amount (VLCTAM) fields. |
| Domestic side of a foreign transaction | If the currency code of the transaction (as identified by the value in the Currency Code field, VLCRCD) is different from the currency code of the company, enter the domestic amount in the Gross Amount field (VLAG).
Unlike a foreign transaction, you do not enter an amount in the Currency Amount field. Enter F in the Currency Mode field (VLCRRM). The system calculates the foreign amount based on the exchange rate (VLCRR). If you are entering discount information, complete the Foreign Discount Available field (VLCDS). If you are entering tax information, complete the Foreign Taxable Amount (VLCTXA), Foreign Non-Taxable Amount (VLCTXN), and Foreign Tax Amount (VLCTAM) fields. |
| Foreign and domestic transactions using currency mode 3 | If you know both the foreign and domestic amounts, you can bypass system calculations. Enter the foreign currency amount in the Currency Amount field (VLACR) and enter the domestic currency amount in the Gross Amount field (VLAG). Enter 3 in the Currency Mode field (VLCRRM). You must complete the Exchange Rate field (VLCRR); however, the system does not validate the exchange rate against the amounts entered or against the F0015 table.
Mode 3 does not calculate discounts and taxes. If the Currency Mode field (VLCRRM) is 3 and you want to process discounts, you must complete the discount information in the Discount Available field (VLADSC) and Foreign Discount Available field (VLCDS). The system does not calculate discounts based on the payment term. If the Currency Mode field (VLCRRM) is 3 and you want to process taxes, you must complete all tax fields. The system does not calculate tax amounts based on the Tax Rate/Area (VLTXA1) and Tax Explanation Code (VLEXR1) fields. |
Before you process batch vouchers, review these tables for a list of the multicurrency fields that are required in the F0411Z1 and F0911Z1 tables. For some fields, blank is a value.
This table provides information about the multicurrency fields that are required in the F0411Z1 table:
| Field Name | Alias | Type | Length | Definition |
|---|---|---|---|---|
| Currency Mode | VLCRRM | Alpha or Number | 1 | A code that indicates whether the voucher is domestic or foreign. This field is used in conjunction with the Currency Code (VLCRCD), Gross Amount (VLAG), Currency Amount (VLACR), and Exchange Rate (VLCRR) fields to calculate required amounts for the transaction.
Enter D, F, or 3, depending on other information provided in the transaction. If you leave this field blank, the system determines the currency mode value based on other information provided in the transaction. The system updates this field when the voucher is processed. |
| Currency Code | VLCRCD | Alpha | 3 | A code that identifies the currency of the voucher. The value that you enter in this field must exist in the F0013 table. |
| Currency Amount | VLACR | Number | 15 | Enter the transaction amount only if the value of the Currency Code field (VLCRCD) is different from the currency code of the company, as defined in the F0010 table.
If you process transactions using currency mode 3, you must enter a value in both the Currency Amount and Gross Amount fields. |
| Exchange Rate | VLCRR | Number | 15 | An amount that specifies the exchange rate for calculating the domestic or foreign amount of the voucher.
If you leave this field blank and the currency mode (VLCRRM) is not 3, the system retrieves the exchange rate from the Currency Exchange Rates table (F0015). Enter an exchange rate if you want to override the exchange rate in the F0015 table or if an exchange rate does not exist. If you set the processing option in the Voucher Entry MBF Processing Options (P0400047) to activate tolerance checking, the system validates the exchange rate that you enter. If you do not have tolerance checking activated, no validation is performed. If the Currency Mode field (VLCRRM) is 3, you must enter an exchange rate in this field. However, the exchange rate is not validated against the F0015 table or the amounts on the transaction. |
| Foreign Discount Available | VLCDS | Number | 15 | Enter an amount, or leave this field blank if you want the system to calculate the discount based on the Payment Terms Code field (VLPTC). If the Payment Terms Code field is blank, but a payment term exists in the F0401 table, the system calculates the discount based on the payment term in the F0401 table.
If the currency mode (VLCRRM) is 3 and a discount is available, you must enter amounts in the Foreign Discount Available (VLCDS) and Discount Available (VLADSC) fields. The system does not perform any calculations. |
| Foreign Taxable Amount | VLCTXA | Number | 15 | The system updates this field based on information in the Tax Rate/Area (VLTXA1), Tax Explanation Code (VLEXR1), and Currency Amount (VLACR) fields.
Do not complete both the Currency Amount (VLACR) and the Foreign Taxable Amount (VLCTXA) fields. If you enter a value in the Currency Amount field, the system calculates the Foreign Taxable Amount field, and vice versa. If the currency mode (VLCRRM) is D, do not complete the currency amount (VLACR) or foreign taxable amount (VLCTXA) field. Instead, complete the Taxable Amount (VLATXA), Non-Taxable Amount (VLATXN), and Tax Amount (VLSTAM) fields. If the Currency Mode field (VLCRRM) is 3 and the transaction has taxes, the system does not perform any calculations. You must complete all tax fields, both foreign and domestic. |
| Foreign Non-Taxable Amount | VLCTXN | Number | 15 | The system updates this field based on information in the Tax Rate/Area (VLTXA1), Tax Explanation Code (VLEXR1), and Currency Amount (VLACR) fields.
Do not complete both the Currency Amount (VLACR) and the Foreign Taxable Amount (VLCTXA) fields. If you enter a value in the Currency Amount field, the system calculates the Foreign Taxable Amount field, and vice versa. If the Currency Mode field (VLCRRM) is D, do not complete the Currency Amount (VLACR) and Foreign Taxable Amount (VLCTXA) fields. Instead, use the Taxable Amount (VLATXA), Non-Taxable Amount (VLATXN), and Tax Amount (VLSTAM) fields. If the Currency Mode field (VLCRRM) is 3 and the transaction has taxes, you must complete all tax fields, both foreign and domestic. If the currency mode is 3, the system does not perform any calculations. |
| Foreign Tax Amount | VLCTAM | Number | 15 | The system updates this field based on information in the Tax Rate/Area (VLTXA1), Tax Explanation Code (VLEXR1), and Currency Amount (VLACR) fields.
Do not complete both the Currency Amount (VLACR) and the Foreign Taxable Amount (VLCTXA) fields. If you enter a value in the Currency Amount field, the system calculates the Foreign Taxable Amount field, and vice versa. If the Currency Mode field (VLCRRM) is D, do not complete the Currency Amount (VLACR) or Foreign Taxable Amount (VLCTXA) field. Instead, complete the Taxable Amount (VLATXA), Non-Taxable Amount (VLATXN), and Tax Amount (VLSTAM) fields. If the Currency Mode field (VLCRRM) is 3 and the transaction has taxes, you must complete all tax fields, both foreign and domestic. If the currency mode is 3, the system does not perform any calculations. |
| Domestic Entry w/Mult Currency Distr | VLDMCD | Alpha | 1 | If the distribution accounts in the F0911Z1 table are for a company that has a different currency than the company in the F0411Z1 table, enter 1 in this field and activate the Allow Multi-Currency Intercompany Transaction option in the General Accounting Constants program (P0000).
If you do not allow multicurrency intercompany transactions, leave this field blank. |
| Foreign Open Amount | VLACR | Number | 15 | Leave this field blank. The system updates this field when the transaction is processed. |
| Foreign Discount Taken | VLDSA | Number | 15 | Leave this field blank. The system updates this field when a payment containing an amount in the Foreign Discount Available field (VLCDS) is issued for a voucher. |
This table provides information about the multicurrency fields that are required in the F0911Z1 table:
| Field Name | Alias | Type | Length | Definition |
|---|---|---|---|---|
| Amount | VNAA | Number | 15 | For domestic only transactions. If the transaction is in the domestic currency, enter the amount in this field. |
| Currency Amount | VNACR | Number | 15 | For foreign currency transactions. If the transaction is in a foreign currency, enter the amount in this field. |
| Ledger Type | VNLT | Alpha | 2 | Enter AA in this field or leave it blank. Do not enter CA as a ledger type. |
| Currency Code | VNCRCD | Alpha | 3 | The system updates this field based on the value in the corresponding field in the F0411Z1 table. |
| Currency Mode | VNCRRM | Alpha or Number | 1 | The system updates this field based on the value in the corresponding field in the F0411Z1 table. |
| Exchange Rate | VNCRR | Number | 15 | The system updates this field based on the value in the corresponding field in the F0411Z1 table. |