IC228 – Potential Overstock
- System
- Inventory Control (IC)
- Type
- Batch program
- Updates
- 2 tables
- References
- 15 tables
IC228 (Potential Overstock) is a Lawson Inventory Control batch program. It updates ADDRDATA and CKPOINT and references GLADDRESS, GLCHART, GLCODES, GLSYSTEM, ICBIN, ICCOMPANY, ICLOCATION, ICRECEIPTS and 7 more.
About IC228
Run Potential Overstock (IC228) to print a report of overstock percentages for items with stock-on-hand quantities that are greater than reorder plus safety stock quantities. This report lists by location unit cost, last issue date, movement class, leadtime, stock-on-hand, reorder plus safety stock quantity, and percent over. Most of these values, such as reorder and safety stock quantities, are derived from Item Location records defined in the IC12.1 (Item Location) Reorder form. **Processing Effect The overstock percentage = Stock on Hand - (Reorder Quantity + Safety Stock) divided by (Reorder Quantity + Safety Stock)
More information: You can select the item listed on this report by location, report group, and/or inventory class. You can print this report in item number sequence. Otherwise, items are listed by extended costs from highest to lowest. This program also provides the option for you to enter a cutoff percentage. If specified, only items with an overstock percentage equal to or greater than the percentage specified are printed.
Updated files (2)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
Referenced files (15)
| Table | Description | System |
|---|---|---|
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLSYSTEM | General Ledger Company | IF |
| ICBIN | Bin Numbers | IC |
| ICCOMPANY | Inventory Company Information | IC |
| ICLOCATION | Company Location | IC |
| ICRECEIPTS | Costing Record | IC |
| ICRPTGRP | Report Group | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| ITEMLOC | Item Location | IC |
| ITEMMAST | Item Master | IC |
| MAJORCL | Major Class | IC |
| MINORCL | Minor Class | IC |
| MXLISTMBR | Attribute List | IF |
Program calls
Invoked programs (5)
ICBL, IFLU, IFOB, IFSG, IFUP