Transactions Processed by Detailed Currency Restatement

Based on data selection, the Detailed Currency Restatement program selects only those companies that are set up for detailed currency restatement in the F0010 table for processing and ignores all other companies. This has a positive impact on performance and helps improve processing time.

The Detailed Currency Restatement program processes all posted transactions in the actual amount (AA) ledger of the F0911 table that meet this criteria:

  • The company on the transaction is set up for detailed currency restatement. The Detailed Currency Restatement field is set to 1 for the company in the Company Names & Numbers program (P0010).

  • Ledger type XA (alternate currency) and, optionally, YA (domestic origin) and ZA (foreign origin), are set up in user-defined code (UDC) table 09/LT and on the Ledger Type Rules Setup form.

  • The account on the transaction is within the account ranges set up for AAI item CRxx.

  • The transaction contains a blank (not processed) in the ALT9 (Currency Update) field in the F0911 table.

For each transaction in the AA ledger that meets this criteria, the Detailed Currency Restatement program creates a new transaction in the XA ledger of the F0911 table with the same batch number as the original transaction and a batch type XX. For example, for each journal entry (batch type G), the program creates an alternate currency journal entry (batch type XX). You can review the XX batch type records on the Work with Batches form. If amounts in the foreign currency ledger (CA) are in the same currency as the XA ledger, the Detailed Currency Restatement program copies the CA ledger amounts to the XA ledger; it does not restate the AA amounts.

For each transaction, the program updates the ALT9 (Currency Update) field from blank (not processed) to one of these values:

  • P (processed): The transaction was processed by the Detailed Currency Restatement program.

    The program creates a corresponding record in the XA ledger (and optionally, the YA and ZA ledgers) and updates the original AA ledger record with P (processed). The program prints a report with the message No errors - batch will post.

  • N (not applicable): The transaction was processed by the Detailed Currency Restatement program, but ignored because the account is not within the account ranges for AAI item CRxx.

    The program does not create a corresponding record in the XA ledger, but instead updates the AA ledger with N (not applicable).

  • X: The original journal entry was flagged to not create a corresponding record in the XA ledger when processed by the Detailed Currency Restatement program and was subsequently voided.

  • Y: The original journal entry was flagged to not create a corresponding record in the XA ledger when processed by the Detailed Currency Restatement program.

Important: The first time that you run the Detailed Currency Restatement program, processing might require a significant amount of time because the program updates the ALT9 field for all qualified records in the F0911 table. Thereafter, the program updates only new qualified transactions.