Mapping Requirements for Processing Multicurrency Batch Invoices

Appendix: Mapping Requirements for Processing Multicurrency Batch Invoices

This appendix provides information about the mapping requirements for processing batch invoices in multiple currencies.

Mapping Requirements for Processing Foreign Batch Invoices

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, as well as the currency-specific mapping requirements for the Batch Invoices (F03B11Z1) and the Journal Entry Transactions - Batch File (F0911Z1) tables.

Prerequisite

Review the non-currency mapping requirements for processing batch invoices.

See Mapping Fields for Batch Invoice Processing.

Guidelines for Amount, Exchange Rate, and Currency Mode Fields for 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.

Multicurrency Fields Required in the F03B11Z1 and F0911Z1 Tables

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.

Multicurrency Fields Required in the F03B11Z1 Table

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).
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).

Multicurrency Fields Required in the F0911Z1 Table

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.