This chapter contains the following topics:
Section 12.1, "Understanding Multicurrency Inquiries for General Accounting"
Section 12.2, "Reviewing Accounts in Domestic, Foreign, and As If Currencies"
Most JD Edwards EnterpriseOne inquiries include domestic and foreign currency amounts for companies that process transactions in multiple currencies. Depending on the inquiry that you select in the JD Edwards EnterpriseOne General Accounting system, the system displays detailed transactions from the F0911 table or posted balances from the F0902 table.
For transactions in a foreign currency, both the AA (domestic) and CA (foreign) amounts display on inquiry forms. If you display more than one currency, the grand totals for the CA amounts are hash totals and meaningless because of the mixed currencies.
Some inquiries allow you to display transaction amounts as if they were entered in a currency other than the original currency in which they were entered.
These general ledger inquiry programs have processing options that allow you to review general ledger accounts using as if currency processing:
You can review as if amounts associated with the domestic ledger (AA) or any other ledger. However, be aware that if you view amounts for the foreign currency ledger (CA), the amounts are meaningless unless you specify a currency. This is because the CA ledger contains more than one currency, and as if processing is designed to convert only one currency at a time.
One of the advantages of as if currency processing is that it does not impact disk space. The amounts that you review or print are not written to a table, but instead are stored in temporary memory.
Note: Reviewing transactions in an as if currency is different from reviewing transactions created by balance currency restatement. As if currency processing was not designed for purposes of balance currency restatement. |
This section provides an overview of reviewing accounts in domestic, foreign, and as if currencies and discusses how to:
Review accounts in domestic and foreign currencies.
Review accounts with domestic and as if currency amounts.
Review accounts with domestic amounts in an as if currency.
Review accounts with foreign amounts in an as if currency.
Review account balances by currency.
You can review amounts for a general ledger account in both the domestic and foreign currencies a currency other than the currency in which the amounts were actually entered. For example, you can review amounts in the Japanese yen as if they were entered in the U.S. dollar or you can review amounts in the euro as if they were entered in Canadian dollars, and so on.
You use these general ledger inquiry programs to review domestic, foreign, and as if currency amounts:
The Account Ledger Inquiry, Account Inquiry by Object Account, and Account Inquiry by Category Code programs allow you to review amounts from the F0911 table in two ledgers, such as the domestic (AA) and foreign (CA) currency ledgers, at the same time. If you use detailed currency restatement processing, you can review the alternate currency ledger (XA) used for reporting alongside the AA ledger.
Depending on how you set a processing option for these programs, you can review amounts in one of these formats:
Format | Description |
---|---|
One-Ledger Format | Displays amounts for one ledger only. Use this format to view:
|
Two-Ledger Format | Displays amounts for two ledgers. Use this format to view:
|
Form Name | FormID | Navigation | Usage |
---|---|---|---|
Work With Account Ledger | W09200A | Journal Entry, Reports, & Inquiries (G0911), Account Ledger Inquiry
From the Form menu, select As-If Currency or Currency Balances. To print as if amounts, you must be viewing the amounts on the Work With Account Ledger form. From the Report menu, select Print Ledger. |
Review accounts in domestic and foreign currencies.
Review accounts with domestic amounts and as if currency amounts or review account balances by currency. |
Trial Balance/Ledger Comparison | W09210AA | Accounting Reports & Inquiries (G0912), T/B / Ledger Comparison | If you post account balances by currency, you can review currency-specific account balances for the company associated with a business unit on the form. |
Access the Work With Account Ledger form.
Enter AA and CA, respectively, in these fields.
The LT 1 Amount column in the detail area of the form displays the domestic currency amounts. The LT 2 Amount column displays the foreign currency amounts.
To view column and ledger total amounts for a specific foreign currency, enter a currency code in this field.
If the Currency Code field is * (all currencies), the column total and ledger total amounts that appear at the end of the LT 2 Amount column are hash totals because they include multiple currencies.
Access the Work With Account Ledger form.
To review domestic and as if currency amounts simultaneously, set the processing option to display two ledgers.
Enter AA in both of these fields.
To display this field, select As-If Currency from the Form menu. The default value for this field is set in a processing option.
The as if currency amounts appear in the LT 1 Amount column and the domestic amounts appear in the LT 2 Amount column.
Access the Work With Account Ledger form.
To review domestic amounts in an as if currency, set the processing option to display one ledger.
Enter AA in this field.
Select As-If Currency from the Form menu.
This menu option acts like a toggle between the domestic currency and the as if currency amounts. If the As-If field appears in the upper-right corner of the form, you are viewing amounts in the as if currency. If the field does not appear, you are viewing amounts in the domestic currency.
Access the Work With Account Ledger form.
To review foreign amounts in an as if currency, set the processing options to display one ledger.
Enter CA in this field.
Enter a currency code.
If you do not enter a currency code, the amounts are meaningless because the CA ledger contains more than one currency. As if currency processing is designed to convert only one currency at a time.
Select As-If Currency from the Form menu.
This menu option acts like a toggle between the domestic currency and the as if currency amounts. If the As-If field appears in the upper-right corner of the form, you are viewing amounts in the as if currency. If the field does not appear, you are viewing amounts in the domestic currency.
Access the Trial Balance/Ledger Comparison form.
If you post transactions by currency to the F0902 table, you can review currency-specific account balances for the AA and CA ledgers on the Account Balance by Currency Code form. Set the processing option to display two ledgers.
Enter AA and CA, respectively, in these fields.
Enter the specific currency in which you want to review CA ledger amounts in this field.