Creating Journal Entries from Accounting Entries Using Journal Generator

Although you can load data directly into the General Ledger tables, a more common practice is to post journals to the General Ledger that are generated from a PeopleSoft application accounting entry table and from a generic accounting entry table, PS_JGEN_ACCT_ENTRY, which is reserved for third-party applications.

This section discusses how to:

  • Use Journal Generator with PeopleSoft applications.

  • Use Journal Generator with third-party applications.

PeopleSoft feeder applications typically generate accounting or voucher lines from transaction data that you enter in the particular application. PeopleSoft posts these accounting lines to an accounting entry table. Journal Generator processes data in the accounting entry table to create journals in General Ledger and optionally edit and post them to the ledgers.

You can create journal entries and optionally post them from any of these PeopleSoft applications:

PeopleSoft Application Name

PeopleSoft Application Name (continued)

Asset Management

Promotion Management

Accounts Payable

Purchasing

Accounts Receivable

Order Management

Billing

Treasury

Contracts

Enterprise Learning Management (ELM)

Expenses

Learning Solutions − Contributor Relations

Grants

Learning Solutions − Student Financials

Inventory

HCM — Global Payroll

Project Costing

HCM — North America Payroll

Note: PeopleSoft ELM, HCM, and Learning Solutions are run in different databases from General Ledger. Their accounting entries are transferred using IPs and then processed by Journal Generator.

When you create accounting entries in non-PeopleSoft third-party applications, you can use the Journal Generator to generate journal entries. This enables non-PeopleSoft applications to create journals from the business unit of each application to different General Ledger business units, as well as to different ledger groups and ledgers for a General Ledger business unit.

You can use the Journal Generator to create journal entries from any table in a database as long as the table contains the required fields. If the field names are different but the attributes are the same, you can create a view and point the Journal Generator to it.

You load your third-party transactions to a generic PeopleSoft accounting entry table PS_JGEN_ACCT_ENTRY for further processing by the Journal Generator. This table works the same as the PeopleSoft accounting entry table that is used by PeopleSoft applications. You can use this table for your third-party applications, or you can clone it and make changes to the original table and the cloned table.

PeopleSoft software delivers the Accounting Entry IP to populate your accounting entry table. The IP provides sample publish and subscribe code for you to clone and modify to meet your third-party journal generation requirements. It uses PeopleCode subscribe on the subscription side. Because PeopleSoft software does not determine a publisher, the publisher is normally third-party software that generates XML messages directly to the PeopleSoft system. Therefore, the publish code that is presented in the IP serves as an example to illustrate the publishing logic.

General Ledger subscribes to the published service and populates the generic accounting entry table PS_JGEN_ACCT_ENTRY with the third-party transaction data. After this table is populated, you use the Journal Generator to create journal entries for the General Ledger.

The service and queue name is JOURNAL_LOAD_TEMPLATE, which uses the PeopleCode Subscribe design pattern and the Subscription Name JournalLoadTemplate. Please see the service subscription for sample publish and subscribe logic.

Note: PeopleSoft software does not provide direct support to third-party products, although PeopleSoft customers and third parties may use the IPs as delivered or customize them based on their needs.