Understanding Integration with PeopleSoft General Ledger

PeopleSoft Project Costing has a built-in integration with PeopleSoft General Ledger by way of the Journal Generator Application Engine process (FS_JGEN). The Journal Generator process transforms accounting entries into journal entries that you can post to PeopleSoft General Ledger.

To move project transactions from PeopleSoft Project Costing to PeopleSoft General Ledger, you:

  1. Distribute the transactions within PeopleSoft Project Costing based on defined accounting rules.

  2. Send the transactions to PeopleSoft General Ledger.

In PeopleSoft General Ledger:

  • The accounting entry definition identifies where the accounting entries that are generated by the Process Project Accounting Application Engine process (PSA_ACCTGGL) are stored, and maps fields on the accounting entry table to fields in the general ledger.

  • The journal generator template defines the data on the journal header and journal lines for each transaction type that the Journal Generator process creates for posting to PeopleSoft General Ledger.

  • The Journal Generator process transforms accounting entries into PeopleSoft General Ledger journals, and optionally can edit and post journals and perform Commitment Control budget checks.

Accounting Entry Definitions

The accounting entry definitions used with the integration between PeopleSoft Project Costing and PeopleSoft General Ledger are Projects Definition (PCDEFN) and Contracts-Projects Definition (CAPCDEFN). These accounting entry definitions map the name of accounting entry fields for project business unit, project ID, and activity ID to specific general ledger (GL) ChartFields.

Based on your ChartField configuration options, and the options that you select in the Input Control group box on the Project Costing Options page, you may be required to also map the source type, category, and subcategory accounting entry field names in the accounting entry definition. For example, if transactions require a category and subcategory, the accounting entry definition should contain a mapping for category and subcategory.