IC233 – Inventory Valuation

System
Inventory Control (IC)
Type
Batch program
Updates
3 tables
References
16 tables

IC233 (Inventory Valuation) is a Lawson Inventory Control batch program. It updates ADDRDATA, CKPOINT and PORECON and references CUCONV, CURELAT, GLADDRESS, GLCHART, GLSYSTEM, ICCATEGORY, ICCOMPANY, ICLOCATION and 8 more.

About IC233

Run Inventory Valuation (IC233) to print a report of inventory valuation. Thereport also values stock-on-hand quantities based on a specified costing method (Standard, Average, LIFO, or FIFO). By default, inventory valuation is based on the costing method defined for the company. Refer to the Inventory Control User Guide for costing method calculation formulas. You can select the inventory valued on this report by location, report group,and general ledger category. Otherwise, inventory valuation is based on all locations and general ledger categories. This report lists general ledger category, location, and company summarized totals. The default parameters include item detail and exclude items with zero stock-on-hand quantities. The detail report prints by location and general ledger category. Details include the item number, description, unit of measure, unit cost, Intransit quantity, On Hold quantity, Stock On Hand quantity, Stock On Hand Value, Preferred Bin (if it exists), and Total Value. NOTE The report prints the run date and time and lists a composite total ofItem Location records as of that run date and time. The report multiplies the current stock-on-hand times the unit cost. It does not take into considerationwhen the transaction that updated the inventory took place. If all inventory transactions (including Order Entry, Purchase Order, and Requisitions) have been processed to the General Ledger application, the report should balance togeneral ledger account totals. The preferred bin is for reference only. Stock On Hand may be located in additional bins. Use the Drill feature on the item to view the actual quantities and locations.

Updated files (3)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
PORECONNo description in the Lawson data dictionaryPO

Referenced files (16)

TableDescriptionSystem
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLSYSTEMGeneral Ledger CompanyIF
ICCATEGORYGL Account CategoryIC
ICCOMPANYInventory Company InformationIC
ICLOCATIONCompany LocationIC
ICRECEIPTSCosting RecordIC
ICRPTGRPReport GroupIC
INSTCTRYCDIntrastat Country CodesTX
ITEMLOCItem LocationIC
ITEMMASTItem MasterIC
MAJORCLMajor ClassIC
MINORCLMinor ClassIC
MXLISTMBRAttribute ListIF

Program calls

Invoked programs (12)

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