IC151 – Movement Analysis - Sales

System
Inventory Control (IC)
Type
Batch program
Updates
4 tables
References
14 tables

IC151 (Movement Analysis - Sales) is a Lawson Inventory Control batch program. It updates ADDRDATA, CKPOINT, ICAUDIT and ITEMLOC and references GLADDRESS, GLCHART, GLCODES, GLSYSTEM, ICBIN, ICCOMPANY, ICHISTORY, ICLOCATION and 6 more.

About IC151

Run Movement Analysis - Sales (IC151) to print a report of the total sales cost and suggests movement classes based on total sales costpercentages. **Processing Effect You define what percentage of the total cost of sales must be met by movement class 1, 2, and 3. For example, if you assign 70, 20, and 10 to movement class 1, 2, and 3 this program assigns class 1 to items that make up 70 percent of the total sales, class 2 to items that make up the next 20 percent of total sales, and class 3 to items that make up the last 10 percent of total sales. You do not have to assign a percentage to each movement class. However, the totalpercentage assigned must equal 100 percent. Examples include 50/50, 80/15/5, and 60/40. This program requires you to enter the period and year range for which to analyze inventory movement. For example, enter 1 1993 - 4 1993 to analyze inventory movement for the first four periods in 1993. This program also provides an update option that lets you update suggested movement classes to the Item Location records in IC12.1 (Item Location). You select the items affected by this program by location, report group, and/or sales class. You can also specify a sales cutoff amount and/or include items set up as inactive in the Item Master file (IC11.1) or Item Location file (IC12.1). If you specify a sales cutoff amount, this program excludes items that fall below the sales amount specified. NOTE Summarized inventory history does not include sales prices for make-to-order kit components. This report is invalid for these items.

Updated files (4)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
ICAUDITItem/Item Location AuditIC
ITEMLOCItem LocationIC

Referenced files (14)

TableDescriptionSystem
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLSYSTEMGeneral Ledger CompanyIF
ICBINBin NumbersIC
ICCOMPANYInventory Company InformationIC
ICHISTORYTransaction HistoryIC
ICLOCATIONCompany LocationIC
ICRPTGRPReport GroupIC
INSTCTRYCDIntrastat Country CodesTX
ITEMMASTItem MasterIC
MAJORCLMajor ClassIC
MINORCLMinor ClassIC
MXLISTMBRAttribute ListIF

Program calls

Invoked programs (5)

ICBL, IFLU, IFOB, IFSG, IFUP