IC175 – Update Variances

System
Inventory Control (IC)
Type
Batch program
Updates
15 tables
References
32 tables

IC175 (Update Variances) is a Lawson Inventory Control batch program. It updates ADDRDATA, CKPOINT, ICACCURACY, ICCOMPANY, ICFREEZE, ICICRAUDIT, ICLOT, ICRECEIPTS and 7 more and references APCOMPANY, APVENGROUP, BINGROUP, COMPONENT, CUCODES, CUCONV, GLADDRESS, GLCHART and 24 more.

About IC175

Run Update Variances (IC175) to update physical inventory counts to the Inventory Control application and print the count variance report. **Processing Effect This program compares freeze quantities created in IC170 (Freeze Selected Items), with item counts entered in IC72.1 (Counts by Page), IC73.1 (Count Detail), and/or IC74.1 (Random Counts) and creates variance transactions for any variances found. Variance transactions are updated to the General Ledger application when you run IC130 (General Ledger Interface).

More information: To run this program you must enter the company, select ID, and update option. Item counts are updated to inventory and variance transactions are created for general ledger when you run this program in update mode. Before update, you can run this program in nonupdate mode to print the variancereport, then explain variances by reason code in any count entry form (IC72, IC73, or IC74). After update you can only explain variances in IC76.1 (Variance Reasons). This program also lets you delete freeze records. You must delete freeze records for a select ID before you can use the select ID again for another physical inventory count. When you delete records depends on when you explain variances. If you explain variances prior to update, you can delete records when you run this program in update mode. If you want to explain variances after update, you must select not to delete records in this form and run IC179 (Delete Freeze Records) to delete freeze records after variances areexplained. NOTE This program creates negative stock-on-hand quantities only if your company is set up to allow negative stock-on-hand. If your company does not allow negative stock-on-hand, this program prints a list of all items that would have been adjusted negatively. It does not update the variance.

Updated files (15)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
ICACCURACYInventory Accuracy StatisticsIC
ICCOMPANYInventory Company InformationIC
ICFREEZEPhysical Inven Freeze RecordIC
ICICRAUDITNo description in the Lawson data dictionaryIC
ICLOTLots with Expire Date/On HoldIC
ICRECEIPTSCosting RecordIC
ICSELECTSelect IDIC
ICTRANSInventory TransactionIC
ICTRANSDTLInventory Transaction DetailIC
ITEMLOCItem LocationIC
ITSERIALSerial NumbersIC
POITEMVENPO Vendor Item InformationPO
SOHDETAILStock-on-Hand DetailIC

Referenced files (32)

TableDescriptionSystem
APCOMPANYAccounts Payable CompanyAP
APVENGROUPVendor GroupAP
BINGROUPBin GroupIC
COMPONENTUser FieldIC
CUCODESCurrency CodesIF
CUCONVCurrency Exhange RateIF
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLNLOCNo description in the Lawson data dictionaryIC
GLNLOCDTLNo description in the Lawson data dictionaryIC
GLSYSTEMGeneral Ledger CompanyIF
ICACTIVITYPre-Released Document HeaderIC
ICBINBin NumbersIC
ICCATEGORYGL Account CategoryIC
ICLBODNo description in the Lawson data dictionaryIC
ICLOCATIONCompany LocationIC
ICTBODNo description in the Lawson data dictionaryIC
INSTCTRYCDIntrastat Country CodesTX
ITEBODNo description in the Lawson data dictionaryIC
ITEMGROUPItem GroupIC
ITEMMASTItem MasterIC
ITEMSRCItem SourceIC
ITLBODNo description in the Lawson data dictionaryIC
KITBODNo description in the Lawson data dictionaryIC
KITITEMKit ItemIC
POCOMPANYCompany System MasterPO
POITEMVENPO Vendor Item InformationPO
PROCUREGRPProcurement GroupPO
RQLOCRequesting LocationsRQ
TXCOMPANYTax CompanyTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (12)

ACAC, ACTA, API4, ICI1, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU