IC228 - Potential Overstock
Run this program to print the Potential Overstock report. This report lists
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.
The overstock percentage = Stock on Hand - (Reorder Quantity + Safety Stock)
divided by (Reorder Quantity + Safety Stock)
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
CKPOINT -
Referenced Files
GLADDRESS - Used in a General Ledger common routine.
GLCHART - This file contains chart and system account information in the
General Ledger system.
GLCODES - Used in a General Ledger common routine.
GLSYSTEM - Used in a General Ledger common routine.
ICBIN - Used to obtain bin number information.
ICCOMPANY - Used to validate the existence of the company number.
ICLOCATION - Used to validate the location if selected.
ICRECEIPTS - Used to obtain item location costing information.
ICRPTGRP - Used to validate the report group.
ITEMLOC - Used to print the unit cost, last issue date, leadtime,
stock-on-hand quantity, and sum of reorder point and safety
stock.
ITEMMAST - Used to print the item description.
MAJORCL - Used to validate the major class.
MINORCL - Used to validate the major-minor class.
INVOKED Programs
IFSG
|
