General Ledger Interface (IC130)
Run General Ledger Interface (IC130) to update the General Ledger file with inventory transactions processed in the Inventory Control (IC), Purchase Order (PO), Requisitions (RQ), and Warehouse (WH) applications. This form produces three reports, the General Ledger Transaction Register, General Ledger Posting Report, and the General Ledger Summary Posting Report.
Processing effect
The General Ledger Transaction Register provides an audit trail of all inventory transactions, such as issues, receipts, and transfers created in Inventory Control, as well as the inventory transactions created by purchase order receipts and adjustments and inspection rejections.
The General Ledger Posting Report lists the general ledger transactions created as a result of these transactions and prints in company, posting date, document type, accounting unit, and account number sequence.
The General Ledger Summary Posting Report summarizes totals for the company, accounting unit(s) and general ledger account(s) and lists general ledger transaction in company, intercompany, accounting unit, and posting date sequence.
This form requires you to print reports in report or update mode and specify a post through date. If you print in report mode you can review general ledger transactions before they are updated to the general ledger interface file. Otherwise, you can update the general ledger file immediately.
This form only posts transactions with a general ledger posting date less than or equal to the specified post through date. The general ledger posting date indicates which general ledger period to post transactions. If the posting date is earlier than the current general ledger period, transactions backpost if the appropriate general ledger period is open. Otherwise, transactions post to the current general ledger period. If the posting date is later than the current general ledger period, transactions remain on the general ledger file until the appropriate general ledger period becomes current.
For Retail Financial Reporting
As records are processed in IC130, they are checked against the MAFRXEXP table to determine if that record needs to be processed for Retail Financial Reporting. If it does, the PULL-FOR-FR-FL (UNIX/Windows) or PLFRFL (IBM i) field on MMDIST (UNIX/Windows) or DBPOMMD (IBM i) is set to Y. Only type PO and PT records are processed for Retail Financial Reporting. Then run Build IC Financial Reporting File (IC131) to extract these records for use in your non-Lawson retail system.