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)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
ICCOMPANYInventory Company InformationIC
ICHISTORYTransaction HistoryIC
ICTRANSInventory TransactionIC
ITEMLOCItem LocationIC
MMDISTAccount DistributionsPO
MMUAVALNo description in the Lawson data dictionaryPO
POAUDITAudit RecordsPO
REQLINERequisition LineRQ
RQAUDITRequisition AuditRQ
SYSTEMCODESystem CodeIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (45)

TableDescriptionSystem
AMASSETAssetAM
AMPOASTDTLPO Asset DetailAM
AMPODFLTSPO DefaultsAM
AMTEMPLATEAsset TemplateAM
APACCRCODEInvoice Accrual CodeAP
APCOMPANYAccounts Payable CompanyAP
APVENGROUPVendor GroupAP
BUYERPO Buyer MasterPO
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
GLADDRESSGeneral Ledger Company AddressIF
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCODESGeneral Ledger CodesIF
GLCPYGRPGeneral Ledger Company GroupIF
GLINTCOGeneral Ledger IntercompanyIF
GLMASTERGeneral Ledger Account MasterIF
GLSYSTEMGeneral Ledger CompanyIF
ICBINBin NumbersIC
ICCATEGORYGL Account CategoryIC
ICLOCATIONCompany LocationIC
INSTCTRYCDIntrastat Country CodesTX
ITEMMASTItem MasterIC
ITEMSRCItem SourceIC
MACOMPANYMatching CompanyMA
MAFRXREFNo description in the Lawson data dictionaryMA
POAOCDTLAdd On Cost DetailPO
POAUDRULESAudit RulesPO
POAUDTYPEAudit TypesPO
POCOMPANYCompany System MasterPO
POLINELine ItemsPO
PORECADJLNReceiving Adjustments LinePO
PORECLINEPO Line Item ReceivingsPO
PORETURNHDPO Return HeaderPO
PORETURNLNPO Return LinePO
POREVISIONPO RevisionPO
PORLNUFNo description in the Lawson data dictionaryRQ
PORQHUFNo description in the Lawson data dictionaryRQ
PURCHORDERPurchase Order MasterPO
REQHEADERRequisition HeaderRQ
RQLOCRequesting LocationsRQ
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF
WHDEMANDDemandWH

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