Multicurrency Reports
This appendix provides an overview of multicurrency reports and enables you to:
View a summary table of multicurrency reports.
View report details for selected multicurrency reports.
Multicurrency Reports
The Financial Management systems provide both standard and analytical reports for multicurrency processing. Depending on the report that you select, you can review detailed information in both domestic and foreign currency amounts as well as as if currency amounts, aging amounts in the transaction currency or in a currency that you specify, and so on.
Be aware that the grand totals on these reports are hash totals and are meaningless when you print more than one currency at a time. To avoid this, set up different versions of the report and use the processing options and data selection to limit the information on the report to one currency.
JD Edwards EnterpriseOne Multicurrency Reports: A to Z
This table lists multicurrency reports for the JD Edwards EnterpriseOne Accounts Receivable, JD Edwards EnterpriseOne Accounts Payable, and JD Edwards EnterpriseOne General Accounting systems, sorted alphanumerically by report ID. This list does not include standard and analytical reports that print in more than one currency.
|
Report ID and Report Name |
Description |
Navigation |
|
R03B413B Open A/R Detail - Summarized with Currency Report |
Print this report to review current summary information about your customer accounts and the associated currency information. |
Accounts Receivable Reports (G03B14), Open A/R Detail - Summarized w/ Currency |
|
R03B4201A Open A/R Detail with Remarks Report |
Print this report to review open items such as invoices credit memos, and unapplied receipts for every customer. |
Accounts Receivable Reports (G03B14), Open A/R Detail with Remarks |
|
R03B4201B Open A/R Detail with Aging Report |
Print this report to review open accounts receivable items for specific aging categories. This report displays totals for each company and a grand total for all companies. |
Accounts Receivable Reports (G03B14), Open A/R Detail with Aging |
|
R03B429A Currency Detail - Foreign and Domestic |
Print this report to review a list of open accounts receivable items with both foreign and domestic currency amounts. |
Accounts Receivable Reports (G03B14), Open A/R Foreign Amounts |
|
R03B429B Currency Detail - Aging |
Print this report to review a list of open account receivable items in the currency in which the system ages the transactions. |
Accounts Receivable Reports (G03B14), Open A/R Foreign Amounts |
|
R03B429C Currency Foreign/Domestic with Aging |
Print this report to review a list of open accounts receivable items with foreign and domestic currency amounts for specific aging categories. |
Accounts Receivable Reports (G03B14), Open A/R Foreign Amounts |
|
R04413A, R04413C, R04413D Open A/P Summary Reports for Multiple Currencies |
Print these reports to review a list of open accounts payable items with foreign and domestic currency amounts for specific aging categories. |
Accounts Payable Reports (G0414), Open A/P with Foreign Amounts |
|
R04427A, R04427B, R04427C, R04427D, R04427E, R04427F Open A/P with Foreign Amounts |
Print these reports to review a detailed list of open accounts payable items with foreign currency amounts, based on the F0411 table. For some reports, you specify aging dates and methods. |
Accounts Payable Reports (G0414), Open A/P with Foreign Amounts |
|
R04428C A/P Detail by Approver with Foreign Currency Aging |
Print this report to review open foreign currency aging amounts by approver number and lists due dates and expense suspense accounts along with the open amount. |
Other Voucher Entry Methods (G04111), Voucher Detail Report |
|
R04431 Cash Requirements Report |
Print this report to list vouchers by supplier and the total amount needed to pay open vouchers. |
Automatic Payment Processing (G0413), Cash Requirements Report |
|
R09470 G/L by Category Code |
To print amounts in an as if currency, set the As-If Currency Code and Exchange Rate Date processing options for this report. |
Account Reports & Inquiries (G0912), General Ledger by Category Code |
|
R09707 Foreign Account Balances |
Print this integrity report to review foreign account balances in the F0902 table. |
Integrity Reports and Updates (G0922), Foreign Account Balances |
|
R097011 Intercompany Accounts in Balance |
Print this integrity report to compare the balances among intercompany settlement accounts within a company. |
Integrity Reports and Updates (G0922), Intercompany Accounts in Balance |
JD Edwards EnterpriseOne Selected Multicurrency Reports
This section provides detailed information, including processing options, for individual reports. The reports are sorted alphanumerically by report ID.
R03B413B - Open A/R Detail - Summarized with Currency
Print the Open A/R Summary report to review current summary information about your customer accounts and the associated currency information. This aging report lists all open accounts in alphabetical order and displays a summarized total for each customer's open items. It also lists totals by company and a grand total of all open accounts receivable items.
The totals and aging amounts reflect those transactions that you specify in the data selection for the report.
Processing Options for Open A/R Detail - Summarized with Currency Report (R03B413B)
Processing options enable you to specify the default processing for reports.
Aging
|
1. Age From Constants |
Specify whether to retrieve the aging specifications from the Accounts Receivable constants. If you leave this field blank, the system uses the processing option values for aging and aging categories. Values are: Blank: Use the processing options to retrieve the aging specifications. 1: Use the Accounts Receivable constants to retrieve the aging specifications. |
|
2. Aging Date |
Specify the date for the system to use to determine the aging category to which the system assigns open invoices. The system compares the date that you enter with the date on the invoice, as specified by the Date Type processing option, to determine the number of days that the invoice is past due. Note. If you use the aging information in the Accounts Receivable constants and you enter a date in this processing option, the system uses the date entered in the Date Aging Based On field in the constants. If that field is blank, the system uses the date entered in this processing option. If both the fields are blank, the system uses the system date to age open invoices. |
|
3. Date Type |
Specify the date on the invoice that you want the system to use to determine the aging category. The system compares the date that you specify to the value in the Aging Date processing option to determine the number of days that the invoice is past due. Values are: D: Due date. I: Invoice date. G: General ledger date. S: Statement date. |
|
4. Aging Method |
Specify which aging method the system uses to assign invoices. The system uses the date specified in the Aging Date processing option and the value specified in the Date Type processing option to calculate the aging for each invoice, and then assigns them to the aging category specified by this method. Values are: 1: Aging Days. The system assigns invoices to the aging categories specified in the Aging Category 1 through Aging Category 3 processing options. The aging categories are user-defined. 2: Fiscal Periods. The system uses the fiscal periods defined by the date pattern that is assigned to the company record as the aging categories. 3: Calendar. The system uses each calendar month as an aging category. |
Aging Categories
|
1. Aging Category 1 |
Use this processing option in conjunction with the value specified in the Aging Category 2 processing option to specify the interval that the system uses for future and current aging categories. |
|
2. Aging Category 2 |
Use this processing option in conjunction with the values specified in the Aging Category 1 and Aging Category 3 processing options to determine the interval that the system uses for the current and first aging categories. |
|
3. Aging Category 3 |
Use this processing option in conjunction with the value specified in the Aging Category 2 processing option to determine the interval that the system uses for the first and second aging categories. |
Age Credits
|
1. Age Credits |
Use this processing option to specify whether to age credit memos and unapplied receipts according to the aging specifications, or to apply credits to the Current Aging column that appears on the report. |
Print Options
|
1. Parent Number |
Specify whether to print the parent number on the report. Values are: Blank: Do not print the parent number. 1: Print the parent number. |
|
2. Category Code Number, 3. Source of Category Codes, and 4. Print Credit Limit |
Reserved for future use. |
R03B4201A - Open A/R Detail with Remarks Report
The multicurrency considerations for the Open A/R Detail with Remarks Report are:
Specify the currency in a processing option to recalculate the amounts listed on the A/R Invoice Details report (R03B4201A) in another currency.
Use the Currency Restatement version XJDE0005 of the A/R Invoice Details report (R03B4201A) and, in a processing option, specify the currency code in which to restate amounts.
R03B4201B - Open A/R Detail with Aging Report
The multicurrency considerations for the Open A/R Detail with Aging Report are:
Specify the currency in a processing option to recalculate the amounts that appear on the A/R Details with Aging report (R03B4201B) in another currency.
Specify whether the A/R Details with Aging report (R03B4201B) prints customers who have exceeded their standard credit limit or customers who have exceeded their insured credit limit, and specify the customer currency for the open amount.
R03B429A - Currency Detail - Foreign and Domestic
Run the Currency Detail - Foreign and Domestic report to review a list of open accounts receivable items in domestic as well as foreign currency amounts.
Processing Options for Currency Detail - Foreign and Domestic (R03B429A)
Processing options enable you to specify the default processing for reports.
|
1. Print Receipts History |
Specify whether the report includes receipt information. Values are: Blank: The report does not include receipt information, except for unapplied receipts. 1: The report includes receipt information. |
|
2. Include Receipts in Totals |
Specify whether to include receipt amounts in the total that prints on the report. Values are: Blank: Include invoice amounts only. 1: Include receipt amounts. If you enter 1, you must also set the Print Receipts History processing option to 1; otherwise, the system does not include receipts in the total. |
|
3. Date - As Of |
Specify the date to use to recalculate and print open invoice amounts. The system compares the date that you enter with the general ledger date of the receipt to determine whether the invoice was open or paid as of the date specified. If the invoice was open, the system includes it on the report. If you leave this processing option blank, the system does not perform as of processing. Note. Using the as of feature increases the report processing time. |
R03B429B - Currency Detail - Aging
Run this report to review a list of open account receivable items in the currency in which the system ages the transactions.
Processing Options for Currency Detail - Aging (R03B429B)
Set a processing option to age the open accounts receivable amounts from a specific date.
Aging
|
1. Retrieve Aging Information |
Specify whether to retrieve the aging specifications and aging date from the Accounts Receivable constants. If you leave this processing option blank, the system uses the processing options for aging specifications (Aging Date, Date Types, and Aging Categories). Values are: Blank: Use processing options 2–10. 1: Use the accounts receivable constants. |
|
2. Aging Date |
Specify the date that you want to the system to use to determine the aging category to which to assign open invoices. The system compares the date that you enter to the date on the invoice, as specified by the Date Types processing option, to determine the number of days the invoice is past due. If you leave this processing option blank, the system uses today's date to age open invoices. |
|
3. Date Type |
Specify the date on the invoice that you want the system to use to determine the aging category. The system compares the date that you specify with the value in the Aging Date processing option to determine the number of days that the invoice is past due. Values are: D: Due date. I: Invoice date. G: General ledger date. S: Statement date. If you leave this processing option blank, the system uses D. |
|
4. Aging Method |
Specify which aging categories the system uses to assign invoices. The system uses the date specified in the Aging Date processing option and the value specified in the Date Type processing option to calculate the aging for each invoice, and then assigns them to the aging category specified by this code. Values are: 1: Aging days. The system assigns invoices to the aging categories specified in the Aging Category 1 – Aging Category 6 processing options. The aging categories are user defined. 2: Fiscal periods. The system uses the fiscal periods defined by the date pattern assigned to the company record as the aging categories. 3: Calendar. The system uses each calendar month as an aging category. If you leave this processing option blank, the system uses 1. |
|
5. Aging Days (For Method 1 only) |
There are four processing options associated with the Aging Days processing option. |
|
Thru |
Use this processing option in conjunction with the value specified in the Aging Category 2 processing option to specify the interval that the system uses for the current and first aging categories that print on the report. |
|
Thru |
Use this processing option in conjunction with the values specified in the Aging Category 1 and Aging Category 3 processing options to determine the interval that the system uses for the first and second aging categories that print on the report. |
|
Thru |
Use this processing option in conjunction with the values specified in the Aging Category 2 and Aging Category 4 processing options to determine the interval that the system uses for the second and third aging categories that print on the report. |
|
Thru |
Use this processing option in conjunction with the value specified in the Aging Category 3 processing option to determine the interval that the system uses for the third aging category that prints on the report. |
|
6. Age Credit Amounts |
Specify whether to age credit memos according to the aging specifications or to apply credits to the Current aging column that prints on the report. |
|
1. Amount Open to be Exceeded |
Specify an amount against which the customer balance will be compared to determine whether to print the customer on the report. The system uses the currency code from the Currency Code of Open Amount processing option for the amount specified in this processing option. The system retrieves the exchange rate to use to restate customer balances from the F0015 table, and then compares the restated balance with the amount specified to determine whether to include the customer on the report. The system includes only customer balances with amounts greater than or equal to the amount specified in this processing option. Note. The system prints the customer balances in the currency specified in the A/B Amount Codes field of the customer master record (CRCA in the F03B12 table), not in the currency specified in the Currency Code of Open Amount processing option. |
|
2. Currency Code of Amount Open to be Exceeded |
Specify the currency of the amount entered in the Open Amount to be Exceeded processing option. The system calculates open amounts based on the currency specified, and then compares the customer's balance with the amount entered in the Open Amount to be Exceeded processing option to determine whether to print the customer on the report. If you leave this processing option blank, the system uses the currency code USD. Note. The system does not print amounts in the currency specified; it uses the currency code only for data selection. |
|
3. Standard or Insured Credit Limit |
Specify which customer records to include on the report. Values are: Blank: Include all records. 1: Include records with the open amount greater than or equal to the credit limit that is set up on the customer master record. 2: Include records with the open amount greater than or equal to the insured credit limit. If the Open Amount to be Exceeded processing option contains a value, that value overrides this processing option. |
|
4. Date - As Of |
Specify the date to use to recalculate and print open invoice amounts. The system compares the date that you enter with the general ledger date of the receipt to determine whether the invoice was open or paid as of the date specified. If the invoice was open, the system includes it on the report. If you leave this processing option blank, the system does not perform as of processing. Note. Using as of processing increases the report processing time. |
|
5. Currency Code - Restated for Foreign and Aging Columns |
Specify the currency to use to restate amounts that appear on the report. The system retrieves the exchange rate from the F0015 table. If an exchange rate is not set up, the system prints a blank report. If you leave this processing option blank, the report prints amounts in the domestic currency. |
R03B429C - Currency - Foreign/Domestic with Aging
Run this report to review a list of open accounts receivable items with foreign and domestic currency amounts for specific aging categories.
You can review the standard and insured credit limits at the company level to see whether the customer has exceeded expected open amounts and credit limits. The report prints this information in the currency of the customer.
Processing Options for Currency - Foreign/Domestic with Aging (R03B429C)
The processing options for this report are the same as the processing options for the Currency Detail - Aging report.
See Processing Options for Currency Detail - Aging (R03B429B).
R04413A, R04413C, and R04413D - Open Accounts Payable Summary Reports for Multicurrency
The Open A/P Summary Reports consists of four different reports, three of which are used for multicurrency processing:
These reports print information about open voucher balances and aging. You control the date from which you want to age the vouchers and the aging categories that you want to appear on these summary reports. Depending on the results you want, set up aging specifications using one of these settings:
Accounts payable constants.
The system calculates aging based on the settings in the account payable constants. You specify the number of days in each time interval for the columns on aging reports. For example, you can specify 30, 60, 90, and 120 days and more.
Processing options.
The system calculates aging based on processing options for the report. The processing options override the intervals that you specify in the accounts payable constants. You can specify aging by due date, invoice date, or general ledger date, and by one of these aging methods:
Aging days
Fiscal periods
Calendar
Processing Options for Open Accounts Payable Summary Reports (R04413A, R04413C, and R04413D)
The processing options for the A/P Summary with Currency, “As-Of” Open A/P Summary, and “As of - A/P” Summary with Currency reports are the same.
Aging
|
1. Aging Specifications |
Specify whether to retrieve aging specifications from the Accounts Payable Constants program or the aging processing options. Values are: Blank: Age transactions based on the processing options. 1: Age on the due date using the aging days in the constants. |
|
2. Date Type |
Specify which voucher date the system uses to age open balances if the Aging Specifications processing option is set to use the aging processing options. The system compares the date specified to the aging date to determine the aging period in which to place each transaction. Values are: Blank or D: Due date. G: General ledger date. I: Invoice date. If the Aging Specifications processing option is set to retrieve aging specifications from the accounts payable constants, this processing is ignored and the system uses the due date on the voucher. |
|
3. Aging Method |
Specify which aging periods the system uses if the Aging Specifications processing option is set to use the aging processing options. Values are: Blank or 1: Aging days. 2: Fiscal periods. 3: Calendar months. If the Aging Specifications processing option is set to retrieve aging specifications from the accounts payable constants, the system ignores this processing option. |
|
4. Aging Days - Aging Category 1–5 |
These processing option apply only if you left the Aging Specifications and Aging Method processing options blank. Use the four aging category processing options in conjunction with one another to specify the aging intervals. For example, you specify 30–, 0, 30, 60, and 90 in these processing options, the five aging columns of the report will be Current, 1–30, 31–60, 61–90, and Over 90. |
|
5. Age Credits |
Specify how the system ages credits. Values are: Blank: Apply credits to the current aging column. 1: Apply credits to the appropriate aging column. |
|
Hold Payment |
Specify whether to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field of the supplier master record in the F0401 table. Values are: Blank: Print all suppliers. 1: Exclude suppliers that are on payment hold. |
Data Sequence for Open Accounts Payable Summary Reports
The report totals are dependent on this sequence, which should not be changed:
Company
Address Number
Currency Code
R04427A, R04427B, R04427C, R04427D, R04427E, and R04427F - Open Accounts Payable with Foreign Amounts Reports
The Open Accounts Payable with Foreign Amounts reports consists of six different reports for multicurrency processing:
Currency Detail - Foreign and Domestic (R04427A)
Print this report to review a detailed list of open accounts payable items with both foreign and domestic currency amounts, based on the F0411 table.
Currency Detail - Aging (R04427B)
Print this report to review a detailed list of open accounts payable items with foreign currency amounts, based on the F0411 table. If no foreign currency transactions exist, the system prints domestic amounts.
Open A/P Detail w/Foreign Currency Aging (R04427C)
Print this report to review a detailed list of open accounts payable items with foreign amounts, based on the F0411 table, for specific aging dates and methods. If no foreign currency transactions exist, the system prints domestic amounts.
“As Of" Currency Detail - Foreign and Domestic (R04427D)
This report is identical to the Currency Detail - Foreign and Domestic report, except that it is based on the F0411A workfile. The as of date that is used for aging is the as of date associated with the F0411A record in the F0490 workfile.
"As Of" Currency Detail - Aging (R04427E)
This report is identical to the Currency Detail - Aging report, except that it is based on the F0411A table. The as of date that is used for aging is the as of date associated with the F0411A record in the F0490 workfile.
"As Of" Open A/P Detail w/ Foreign Currency (R04427F)
This report is identical to the Open A/P Detail w/Foreign Currency Aging report, except that it is based on the F0411A table. The as of date that is used for aging is the as of date associated with the F0411A record in the F0490 workfile.
Data Sequence for Open A/P with Foreign Amounts Reports
The report totals are dependent on this sequence, which should not be changed:
Company
Alpha Name
Address Number
Currency Code
Processing Options for Open Accounts Payable with Foreign Amounts Reports (R04427A and R04427D)
The processing options for the Currency Detail - Foreign and Domestic and “As Of" Currency Detail - Foreign and Domestic reports are the same.
|
Hold Payment |
Specify whether to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field of the supplier master record in the F0401 table. Values are: Blank: Print all suppliers. 1: Exclude suppliers that are on payment hold. |
Processing Options for Open Accounts Payable with Foreign Amounts Reports (R04427B, R04427C, R04427E, and R04427F)
The processing options for the Currency Detail - Aging, Open A/P Detail w/Foreign Currency Aging, "As Of" Currency Detail - Aging, and "As Of" Open A/P Detail w/ Foreign Currency reports are the same as those for the Open Accounts Payable Summary reports.
See Processing Options for Open Accounts Payable Summary Reports (R04413A, R04413C, and R04413D).
R04428C - A/P Detail by Approver with Foreign Currency Aging
The A/P Detail by Approver with Foreign Currency Aging report (R04428C) prints open foreign currency aging amounts by approver number and displays due dates and expense suspense accounts along with the open amount. This report is similar to the Open A/P Detail w/Foreign Currency Aging Report (R04427C).
Processing Options for A/P Detail By Approver with Foreign Currency Aging (R04428C)
The processing options for this report are the same as those for the Open Account Payable Summary reports, with the exception of an additional processing option on the Aging tab described in this section.
See Processing Options for Open Accounts Payable Summary Reports (R04413A, R04413C, and R04413D).
Aging
|
2. Aging Date |
Specify the date that the system uses to age open balances. The system compares the date in the processing option to the date on the voucher to determine the aging category in which to place each transaction. If you leave this processing option blank, the system compares the current date to the date on the voucher to determine the aging category. |
R04431 - Cash Requirements Report
The Cash Requirements Report (R04431) lists vouchers by supplier in three aging columns, provides a total for each supplier and each bank account, and displays the total amount needed to pay open vouchers. Depending on the type of bank account, the report includes this currency code and amount information:
If the bank account is a monetary account, the currency code printed on the header of the report is the bank account currency. The currency code printed in the currency code column is the domestic currency of the voucher. The amounts to the right of the currency code column are in the domestic currency and the amounts to the left of the currency code column are in the bank account currency.
If the bank account is a non-monetary account, the currency code printed on the header of the report is the domestic currency. The currency code printed in the currency code column is the foreign currency of the voucher. The amounts to the right of the currency code column are in the foreign currency and the amount to the left of the currency code column are in the domestic currency.
Intercompany Accounts in Balance (R097011)
The Intercompany Accounts in Balance integrity report (R097011) uses information from the Account Balances table (F0902) to compare the balances among various intercompany settlement accounts within a single company. These accounts should be in balance. If they are not, the report lists the accounts, their balances, and the amount required to balance each account.
If you have multiple companies with different base currencies, do not use this integrity report to verify that intercompany accounts are in balance. This integrity report does not accommodate different base currencies.
For example, Company 70 has a balance of 50,000.00 euro (EUR) in its intercompany settlement account. Company 71 has a balance of 69,624.00 Canadian dollars (CAD) in its intercompany settlement account. The 50,000.00 EUR balance is equal to the 69,624.00 CAD balance because of the EUR to CAD exchange rate (1.39248). This integrity report establishes that the two companies are out-of-balance because it does not allow for the different base currencies.
Note. To determine whether batches within the company are out of balance, run the Company by Batch Out of Balance integrity report (R09706).
See Understanding the Company by Batch Out of Balance Report.
Processing Options for Intercompany Accounts in Balance (R097011)
Processing options enable you to specify the default processing for reports.
Ledger Type
|
Ledger Type |
Specify the ledger type to use to select the records to process. If you leave this processing option blank, the system selects all ledger types. |
R09707 - Foreign Account Balances
The Foreign Account Balances report (R09707) reviews account information in the F0902 table and prints an integrity report that displays account setup issues caused by:
Changes to an account.
If you change an account from a non-monetary account to a monetary account after you post a foreign transaction, the report prints the error message Monetary account with incorrect transaction (CRCD) or company currency code (CRCX).
If you change an account from a monetary account to a non-monetary account after you post a foreign transaction, the report prints the error message Transaction currency (CRCD) populated but not in PBC AAI range or a monetary account.
Changes to AAI items.
AAI item PBCxx is used for posting account balances by currency. If you add a range of accounts to AAI item PBCxx after you post a foreign transaction, the report prints the error message Account within PBC AAI range with no currency in the transaction currency field (CRCD).
If you remove a range of accounts from AAI item PBC xx after you post a foreign transaction, the report prints the error message Transaction currency (CRCD) populated but not in PBC AAI range or a monetary account.
In proof mode, the Foreign Account Balances report lists any accounts with issues. Make sure that the accounts that appear on the report are set up accurately and were not inadvertently changed. If necessary, correct any errors and rerun the report in proof mode.
In final mode, the Foreign Account Balances report deletes CA records. If you run this report in final mode, you must also:
Run the Repost Account Ledger program (R099102) to create the correct CA and AA records.
Delete the “bad” AA records in the F0902 table.
The Foreign Account Balances report does not automatically do this when it deletes the CA records. This should be done by the database administrator.
Run the Foreign Account Balances report again in proof mode to verify that no accounts have error messages.
Processing Options for Foreign Account Balances (R09707)
Processing options enable you to specify the default processing for reports.
Mode
|
Process |
Specify whether to remove CA ledger type records with no matching AA ledger type records. Blank: Do not remove records. 1: Remove records |