This appendix contains the following topics:
To upload foreign invoices 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 Receivable 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 Invoices (F03B11Z1) and the Journal Entry Transactions - Batch File (F0911Z1) tables.
Review the non-currency mapping requirements for processing batch invoices.
Observe these guidelines to determine how to enter amounts, exchange rates, and currency modes for domestic and foreign transactions when processing foreign batch invoices:
| 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, VJCRCD) is equal to the currency code of the company, the transaction is a domestic transaction.
Enter the transaction amount in the Gross Amount field (VJAG) and enter D in the Currency Code field (VJCRRM). Do not enter an exchange rate. If you are entering discount information, complete the Discount Available field (VJADSC). If you leave the Discount Available field blank, and you entered a payment term (VJPTC), the system calculates the discount based on the payment term. If you leave both the Discount Available and the Payment Term fields blank, the system calculates the discount based on the payment term in the Customer Master by Line of Business table (F03012). If you are entering tax information, complete the Taxable Amount (VLATXA), Non-Taxable Amount (VLATXN), and Tax Amount (VLSTAM) fields. If you leave these fields blank, the system calculates the amounts based on the tax rate area (VJTXA) and tax explanation code (VJEXR1) that you entered for the record. If you also leave the Tax Rate/Area and Tax Explanation Code fields blank, the system calculates the tax amounts based on the Tax Rate/Area and Tax Explanation Code fields in F03012 table. |
| Foreign | If the currency code of the transaction (identified by the value in the Currency Code field, VJCRCD) is different from the currency code of the company, the transaction is a foreign transaction.
Enter the transaction amount in the Currency Amount field (VJACR) and enter F in the Currency Mode field (VJCRRM). The system calculates the domestic amount based on the Exchange Rate field (VJCRR). If you are entering discount information, complete the Foreign Discount Available field (VJCDS). If you are entering tax information, complete the Foreign Taxable Amount (VJCTXA), Foreign Non-Taxable Amount (BJCTXN), and Foreign Tax Amount (VJCTAM) fields. |
| Domestic side of a foreign transaction | If the currency code of the transaction (identified by the value in the Currency Code field, VJCRCD) is different from the currency code of the company, enter the domestic amount in the Gross Amount field (VJAG).
Unlike a foreign transaction, you do not enter an amount in the Currency Amount field. Enter D in the Currency Mode field (VJCRRM). The system calculates the foreign amount based on the exchange rate (VJCRR). If you are entering discount information, complete the Foreign Discount Available field (VJCDS). If you are entering tax information, complete the Foreign Taxable Amount (VJCTXA), Foreign Non-Taxable Amount (BJCTXN), and Foreign Tax Amount (VJCTAM) fields. |
Before you process batch invoices, review these tables for a list of the multicurrency fields required in the Batch Invoices (F03B11Z1) and the Journal Entry Transactions - Batch File (F0911Z1) tables. For some fields, blank is a value.
This table provides information about the required multicurrency fields in the F03B11Z1:
| Field Name | Alias | Type | Length | Description |
|---|---|---|---|---|
| Currency Mode | VJCRRM | Alpha | 1 | A code that indicates whether the invoice is domestic or foreign. This field is used in conjunction with the Currency Code (VJCRCD), Gross Amount (VJAG), Currency Amount (VJACR), and Exchange Rate (VJCRR) fields to calculate required amounts for the transaction.
Enter D or F, depending on other information provided in the transaction. If you leave this field blank, the system determines this value based on other information provided in the transaction. The system updates this field when the invoice is processed. |
| Currency Code | VJCRCD | Alpha | 3 | A code that identifies the currency of the invoice. The value that you enter in this field must exist in the F0013 table. |
| Currency Amount | VJACR | Number | 15 | A foreign currency amount. Enter the transaction amount only if the value in the Currency Code field (VJCRCD) is different from the currency code of the company, as defined in the F0010 table. |
| Exchange Rate | VJCRR | Number | 15 | An amount that specifies the exchange rate for calculating the domestic or foreign amount of the invoice.
If you leave this field blank, the system retrieves the exchange rate from the F0015 table. 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 Invoice Entry MBF Processing Options (P03B0011) 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. |
| Foreign Discount Available | VJCDS | 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 (VJPTC). If the VJPTC field is blank, the system calculates the discount based on the payment term in the F03012 table. |
| Foreign Taxable Amount | VJCTXA | Number | 15 | The system updates this field based on information in the Tax Rate/Area (VJTXA1), Tax Explanation Code (VJEXR1), and Currency Amount (VJACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter an amount in the Foreign Taxable Amount field (VJCTXA) and you leave the Currency Amount field (VJACR) blank, the system calculates the currency amount.
Do not enter complete both the Currency Amount (VJACR) and Foreign Taxable Amount (VJCTXA) fields. If the Currency Mode field (VJCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VJATXA), Non-Taxable Amount (VJATXN), and Tax Amount (VJSTAM) fields. |
| Foreign Non-Taxable Amount | VJCTXN | Number | 15 | The system updates this field based on information in the Tax Rate/Area (VJTXA1), Tax Explanation Code (VJEXR1), and Currency Amount (VJACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter the amount in the Foreign Taxable Amount field (VJCTXA) and you leave the Currency Amount field (VJACR) blank, the system calculates the currency amount.
Do not complete both the Currency Amount (VJACR) and Foreign Taxable Amount (VJCTXA) fields. If the Currency Mode field (VJCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VJATXA), Non-Taxable Amount (VJATXN), and Tax Amount (VJSTAM) fields. |
| Foreign Tax Amount | VJCTAM | Number | 15 | The system updates this field based on information in the Tax Rate/Area (VJTXA1), Tax Explanation Code (VJEXR1), and Currency Amount (VJACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter the amount in the Foreign Taxable Amount field (VJCTXA) and you leave the Currency Amount field (VJACR) blank, the system calculates the currency amount.
Do not complete both the Currency Amount (VJACR) and Foreign Taxable Amount (VJCTXA) fields. If the Currency Mode field (VJCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VJATXA), Non-Taxable Amount (VJATXN), and Tax Amount (VJSTAM) fields. |
| Domestic Entry w/Mult Currency Distr | VJDMCD | Alpha | 1 | If the distribution accounts in the F0911Z1 table are for a company that has a different currency than the company in the F03B11Z1 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 | VJACR | Number | 15 | Leave this field blank. The system updates this field when the transaction is processed. |
| Foreign Discount Taken | VJDSA | Number | 15 | Leave this field blank. The system updates this field when a receipt is applied against an invoice that contains an amount in the Foreign Discount Available field (VJCDS). |
This table shows the corresponding multicurrency fields in the F0911Z1 table that are required to process batch invoices and includes a description of how to complete the field.
| Field Name | Alias | Type | Length | Description |
|---|---|---|---|---|
| Amount | VNAA | Number | 15 | For domestic only transactions. If you are entering a domestic currency transaction, enter the amount in this field. |
| Currency Amount | VNACR | Number | 15 | For foreign currency transactions. If you are entering a foreign currency transaction, 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 F03B11Z1 table. |
| Currency Mode | VNCRRM | Alpha | 1 | The system updates this field based on the value in the corresponding field in the F03B11Z1 table. |
| Exchange Rate | VNCRR | Number | 15 | The system updates this field based on the value in the corresponding field in the F03B11Z1 table. |
| Amount - Foreign Gross | VNAGF | Number | 15 | For foreign entries, enter the foreign gross amount for journal entries with VAT. This amount is passed to the tax calculator for validation and calculation. If the Rate/Rate Area and Tax Explanation Code fields are not passed, this field is ignored. |
| Amount - Foreign Tax | VNCTAM | Number | 15 | For foreign entries, enter the foreign tax amount for journal entries with VAT. This amount is passed to the tax calculator for validation and calculation. If the Rate/Rate Area and Tax Explanation Code fields are not passed, this field is ignored. |