Understanding How to Integrate with General Ledger

Regardless of the general ledger system that you use, you must transfer journals from Asset Management to General Ledger. As part of the setup for your asset system, establish a general ledger business unit and ledger, general ledger calendar, journal sources, and accounting entry templates. When you define operators, set up journal distribution privileges for them. This setup enables you to distribute accounting entries for asset transactions and depreciation and to generate journals to General Ledger.

If the General Ledger and Asset Management databases aren't integrated, or if you use a different general ledger system, you need to complete some prerequisite tasks before integrating the two systems.

Two processes are required to complete the bridge between Asset Management and another general ledger system:

• At installation, rename JRNL_HEADER to JRNL_HEADER_FS, and rename JRNL_LN to JRNL_LN_FS.

  Using Application Designer, change these records from views to SQL tables, and create the tables.

• On a regular basis, unload the journal headers and lines from one database to the other.

  To send journals to an outside general ledger system, design a conversion program that converts Asset Management journal headers and lines to the format required by your general ledger system.

PeopleSoft Asset Management also uses the book code and document sequencing functionality available through PeopleSoft General Ledger.