Journal Generator and Update Processes

After running the Amount-based Revenue and Rate-based Revenue (Accounting Rules Engine) processes, you must run the Journal Generator and Update Journal Generator processes.

Journal Generator Process

The Journal Generator process picks up all account transactions in the CA_ACCTG_LINE and CA_ACCTG_LN_PC tables with a General Ledger distribution status of N (newly inserted) and creates journals for them. The Journal Generator process marks all CA_ACCTG_LINE and CA_ACCTG_LN_PC lines for which it has successfully created a journal line with a General Ledger status of D (distributed).

To run the Journal Generator process, you must have the PeopleSoft General Ledger accounting entry definitions and journal entry templates set up. The PeopleSoft system delivers the accounting entry definitions. There are two accounting entry definitions—one for each CA_ACCTG table, which you do not update. The PeopleSoft system also delivers these sample journal entry templates:

• CA_DFR for contract liability.

• CA_REV for Contracts fixed-amount revenue.

• CA_PC for Contracts rate-based revenue based on transactions accumulated in PeopleSoft Project Costing.

Define custom journal entry templates that are specific to your business requirements. On the Journal Generator Request page, specify the template that you want to run. Additionally, you can specify special journal entry templates for a specific accounting rule.

Note:

Set up journal entry templates for each GL business unit before you process any PeopleSoft Contracts revenue transactions, including contract liability.

Note:

When running the General Ledger Journal Generator process, you may run into performance degradation over time. Depending on the database platform, volume, and distribution of data, the correct index can speed processing greatly. You may want to create new indexes within the PeopleSoft General Ledger or PeopleSoft Contracts products to increase performance. In regards to the PeopleSoft Contracts product, the PS_CA_ACCTG_LN_PC table should be looked at for additional indexes.

See PeopleSoft General Ledger: Understanding Optimal General Ledger Performance.

Contracts Journal Generator Update Process

The Contracts Journal Generator Update process makes the following updates for applicable revenue plans and events:

• Changes applicable revenue recognition events from In Progress to Completed.

  If all events for a revenue plan are booked, the system updates the revenue plan status to Completed.

• Changes applicable Reversal In Progress events to Reversed.

  If all events for a revenue plan are set to Reversed and the revenue plan status is Reversal In Progress, the process changes the revenue plan status to Reversed.

• Changes applicable Reversal In Progress revenue plans to Reversed if all events are New, Ready, or Reversed.

Note:

The CA_LOAD_UPD process updates the GL distribution status to D (distributed) for the PROJ_RESOURCE rows associated with PeopleSoft Contracts revenue (CA_ACCTG_LN_PC table).