IC130 – General Ledger Interface
- System
- Inventory Control (IC)
- Type
- Batch program
- Updates
- 16 tables
- References
- 45 tables
IC130 (General Ledger Interface) is a Lawson Inventory Control batch program. It updates ADDRDATA, CKPOINT, ICCOMPANY, ICHISTORY, ICTRANS, ITEMLOC, MMDIST, MMUAVAL and 8 more and references AMASSET, AMPOASTDTL, AMPODFLTS, AMTEMPLATE, APACCRCODE, APCOMPANY, APVENGROUP, BUYER and 37 more.
About 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 (System i) field on MMDIST (UNIX/Windows) or DBPOMMD (System i) isset 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.
Updated files (16)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| ICCOMPANY | Inventory Company Information | IC |
| ICHISTORY | Transaction History | IC |
| ICTRANS | Inventory Transaction | IC |
| ITEMLOC | Item Location | IC |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| POAUDIT | Audit Records | PO |
| REQLINE | Requisition Line | RQ |
| RQAUDIT | Requisition Audit | RQ |
| SYSTEMCODE | System Code | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (45)
| Table | Description | System |
|---|---|---|
| AMASSET | Asset | AM |
| AMPOASTDTL | PO Asset Detail | AM |
| AMPODFLTS | PO Defaults | AM |
| AMTEMPLATE | Asset Template | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APVENGROUP | Vendor Group | AP |
| BUYER | PO Buyer Master | PO |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCODES | General Ledger Codes | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLSYSTEM | General Ledger Company | IF |
| ICBIN | Bin Numbers | IC |
| ICCATEGORY | GL Account Category | IC |
| ICLOCATION | Company Location | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| ITEMMAST | Item Master | IC |
| ITEMSRC | Item Source | IC |
| MACOMPANY | Matching Company | MA |
| MAFRXREF | No description in the Lawson data dictionary | MA |
| POAOCDTL | Add On Cost Detail | PO |
| POAUDRULES | Audit Rules | PO |
| POAUDTYPE | Audit Types | PO |
| POCOMPANY | Company System Master | PO |
| POLINE | Line Items | PO |
| PORECADJLN | Receiving Adjustments Line | PO |
| PORECLINE | PO Line Item Receivings | PO |
| PORETURNHD | PO Return Header | PO |
| PORETURNLN | PO Return Line | PO |
| POREVISION | PO Revision | PO |
| PORLNUF | No description in the Lawson data dictionary | RQ |
| PORQHUF | No description in the Lawson data dictionary | RQ |
| PURCHORDER | Purchase Order Master | PO |
| REQHEADER | Requisition Header | RQ |
| RQLOC | Requesting Locations | RQ |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
| WHDEMAND | Demand | WH |
Program calls
Invoked programs (27)
ACAC, ACTA, API3, API4, GLCC, ICI1, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, POIF, POIG, POIL, POIM, SLFD, SLSB, SLSE, SLSS, SLSU