This chapter contains these topics:
Section 45.2, "Exchange Rate Diff - A/R Gain/Loss/Proof (P098651),"
Section 45.3, "Exchange Rate Difference - A/P Gain/Loss (P098652),"
Section 45.7, "Detailed Currency Restatement XA YA ZA (P11411),"
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| LEVEL OF DETAIL: | |
| 1. Specify the lowest level account to be printed (e.g., 7). | |
| PERIOD INFORMATION: | |
| 2. Enter the fiscal year and period for the financial statement.
Leave blank for current year and period. Year: Period: |
|
| PRINT OPTIONS: | |
| 3. To select which account number to print on the Trial Balance, enter a:
'1' - account number (default) '2' - short account i.d. '3' - unstructured account If left blank, default will be account number. |
|
| 4. Enter a '1' to omit printing accounts with zero balances. | |
| SUBLEDGER INFORMATION: | |
| 5. Enter specific subledger or '*' for all subledgers. | |
| 6. Enter a subledger type if you have entered a specific subledger in processing option 5 above. | |
| "AS OF" DATE: | |
| 7. Enter "As Of" date for processing the current exchange rate.
Default of blank will process rate using the current processing period. -OR- Enter a '1' to use the first rate from the next period. Note: If a '1' is entered the 'As Of' processing will be ignored. |
|
| JOURNAL ENTRIES: | |
| 8. Enter a '1' to create journal entries for both gains and losses. Enter a
'2' to create journal entries only for accounts with a calculated loss. Enter a '3' to create journal entries only for calculated gains. Default of blank will not create journal entries. |
|
| 9. Enter a '1' to prevent the creation of a reversing gain/loss journal entry.
Default of blank will create a reversing journal entry. |
|
| JOURNAL ENTRIES CONT: | |
| 10. Enter the G/L date.
Default of blank will use last day of current period. |
|
| 11. Enter a '1' to create the journal entry batches in an Approved status regardless of the value in the Management Approval of Input general accounting constant.
Default of blank will not override the settings. |
|
| ENHANCED SUBLEDGER SELECTIONS: | |
| 12. Enter the Enhanced Subledgers and Types you would like to select.
Enter '*' for all subledgers. If Enhanced Subledger = '*', Subledger Type will be ignored. Enhanced Subledger 1 . . . . . . . Enhanced Subledger Type 1. . . . . Enhanced Subledger 2 . . . . . . . Enhanced Subledger Type 2. . . . . Enhanced Subledger 3 . . . . . . . Enhanced Subledger Type 3. . . . . Enhanced Subledger 4 . . . . . . . Enhanced Subledger Type 4. . . . . |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROOF/FINAL MODE: | |
| 1. Enter a '1' to process in Final mode.
If left blank, processing will be in Proof mode and no updates will occur. |
|
| INVOICE INFORMATION: | |
| 2. Enter a '1' to create the invoice using the gain/loss amount as the Taxable Amount.
If left blank, the gain/loss amount will be the Gross Amount. |
|
| INVOICE INFORMATION (continued): | |
| 3. Enter a '1' to default tax code, tax area, payment instrument, payment terms and remark through the A/R Functional Server.
If left blank, these fields will be populated from the originating invoice if not blank. |
|
| GAIN/LOSS SUMMARIZATION: | |
| 4. Enter one of the following values to summarize gain/loss records into one new invoice by Customer, Company, Business Unit, Tax Area, Tax Code.
'1' = within Receipt and Invoice '2' = within Receipt If left blank, no summarization will occur. |
|
| REPORT PRINT: | |
| 5. Enter a '1' to bypass print of the Update report in Proof mode.
If left blank, Update report will always print. |
|
| AUTOMATIC POST SUBMITTAL: | |
| 6. Enter a '1' to bypass the auto-submittal of the posts.
If left blank, posts will be symbiotic automatically. ** We caution you against bypassing posts. |
|
| PROGRAM VERSIONS: | |
| 7. Enter the versions of the following programs.
If left blank, version ZJDE0001 will be used. A/R Functional Server (XT0311Z1). G/L Functional Server (XT0911Z1). G/L Post - Invoice . . . . . . . . (If blank, ZJDE0002 will be used) G/L Post - Receipts. . . . . . . . (If blank, ZJDE0005 will be used) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROOF/FINAL MODE: | |
| 1. Enter a '1' to process in Final mode.
If left blank, processing will be in Proof mode and no updates will occur. |
|
| VOUCHER INFORMATION: | |
| 2. Enter a '1' to create the voucher using the gain/loss amount as the Taxable Amount.
If left blank, the gain/loss amount will be the Gross Amount. |
|
| VOUCHER INFORMATION (continued): | |
| 3. Enter a '1' to default tax code, tax area, payment instrument, payment terms and remark through the A/P Functional Server.
If left blank, these fields will be populated from the originating voucher if not blank. |
|
| GAIN/LOSS SUMMARIZATION: | |
| 4. Enter one of the following values to summarize gain/loss records into one new voucher by Supplier, Company, Business Unit, Tax Area, Tax Code.
'1' = within Payment and Voucher '2' = within Payment If left blank, no summarization will occur. |
|
| REPORT PRINT: | |
| 5. Enter a '1' to bypass print of the Update report in Proof mode.
If left blank, Update report will always print. |
|
| AUTOMATIC POST SUBMITTAL: | |
| 6. Enter a '1' to bypass the auto-submittal of the posts.
If left blank, posts will be submitted automatically. ** We caution you against bypassing posts. |
|
| PROGRAM VERSIONS: | |
| 7. Enter the versions of the following programs.
If left blank, version ZJDE0001 will be used. A/P Functional Server (XT0411Z1). G/L Functional Server (XT0911Z1). A/P Payment Server (XT0413). . . . G/L Post - Voucher (P09800). . . . (If blank, ZJDE0003 will be used) G/L Post - Payments (P09800) . . . (If blank, ZJDE0004 will be used) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| TOLERANCE LIMIT: | |
| You may specify a tolerance limit to warn you of radical rate changes.
For example: 15.0 indicates 15% +/-. This will also alert you to data entry errors. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DREAM WRITER VERSION: | |
| Enter the version for each program.
If left blank, version ZJDE0001 will be used. 1. Set Daily Transaction Rates (P00151) 2. Company Names and Numbers (P00105) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| ADDITIONAL LEDGERS: | |
| 1. Enter a '1' to create records in the Additional Ledgers (ZA and YA).
Default of Blank will create records only in the XA Ledger. |
|
| AUTOMATIC POSTING: | |
| 2. Enter the version of the Post Program if you wish to automatically post the entries created by the currency restatement program.
Use a version of the Post which is for batch type 'XX' (i.e. ZJDE0041). Default of blank will leave the entries unposted. |
|
| DIFFERENCE AMOUNTS: | |
| 3. Enter a '1' to automatically create journal entries required to balance the Currency Restatement Ledgers.
Default of blank with not create these entries. |
|
| DAILY TRANSACTION RATES: | |
| 4. Enter a '1' to use the Daily Transaction Rate corresponding to the Service/Tax Date (DSV).
The default of blank will use the General Ledger Date (DG). |
|
| UNITS LEDGER: | |
| 5. The default value of blank will leave the corresponding unit amount in the XA, YA, ZA records.
A value of 1 will not carry the units over to the XU, YU, or ZU ledger. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| MODE: | |
| 1. Enter the mode the calculations and update will be processed in:
0 = Proof mode with Report (Default) 1 = Final mode with Report 2 = Final mode without Report |
|
| RESTATEMENT PERIOD: | |
| 2. Enter the 'As Of' date or period number through which to perform the restatement calculations.
A default of blank will select the current period. |
|
| 3. Enter a '1' to restate Year-To-Date, (all periods).
A default of blank will restate only the selected period. |
|
| RESTATEMENT RATE: | |
| 4. If you are performing a Year-To-Date restatement, enter a '1' to restate all periods using the rate for the 'As Of' period selected.
A default of blank will cause the restatements to occur using the rate active for each specific period being restated. |
|
| SUPPRESS PRINT: | |
| 5. Enter a '1' to suppress the print of balances with a restated amount of zero.
If left blank, all restated balances will print. |
|
| OVERRIDE COMPUTATION ID: | |
| 6. Enter the Computation ID specifying which Computation should be performed on the companies selected in the Dream Writer.
The default of blank will use the Computation ID specified in the Company Constants. |
|
| OVERRIDE DESTINATION LEDGER: | |
| 7. Enter the 'To' Ledger for the Restatement Computation Records you wish to process.
The default of blank will process all records without regard to the 'To' Ledger. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| CONVERSION DATE: | |
| 1. Enter the 'As If' exchange rate date to be used to convert the original transactions.
Effective rates for this date must exist in the Currency Conversion Rates File (F0015). |
|
| MODE: | |
| 2. Enter the mode the calculations and update will be processed in:
0 = Proof mode with Report (Default) 1 = Final mode with Report 2 = Final mode without Report |
|
| CONVERSION LEDGER TYPE: | |
| 3. Enter the ledger type to receive the recomputed transaction amounts. This option has no defaults and must be entered for the program to function.
The ledger type must be defined in User Defined Codes System Code '11' Record Type 'TL'. |