IC140 - Vendor Reorder Advice
Run this program to print the Vendor Reorder Advice report. This program
calculates replenishment quantities for items with an available quantity that
is less than the reorder point.
Available quantities are shown on this report as supply minus demand.
Available quantity is based on current stock-on-hand quantities minus
allocated, picked, and backordered quantities plus on-order and intransit
quantities. The item's stock unit of measure is used. If the buy unit of
measure is different, this program converts the quantity based on the
conversion data defined in the IC11.1 (Item Master) UOM form.
This form applies to items which were
- defined in the IC12.1 (Item Location) Reorder form with the fixed reorder
policy (FOP), Reorder Point and
- assigned the reorder document code for Purchase Order.
If reorder points are not set up, use IC120 (EOQ and Reorder Calculation) to
calculate reorder points based on annual usage.
You can use an IC140 option to update the PO Interface file. You can update
the file with reorder quantity records for items set up for automatic
purchasing in IC12.1. If updated, you can use the PO Interface file to create
purchase orders in PO100 (PO Interface).
The Vendor Reorder Advice prints items in primary vendor sequence and lists
the following: stock unit of measure, reorder point, reorder quantity, buyer
code, stock-on-hand, supply minus demand (available quantity), leadtime,
reorder percentage, and the automatic purchase order flag.
You can select this report to print for the following: a specific location,
report group, inventory class, purchasing class, and primary vendor.
You also have the option to process items that are set up as inactive in
IC11.1 (Item Master). With the reorder cutoff percentage, if a vendor has an
item to be reordered, this option will include any other items that are within
this percentage of reorder point.
To print the same information by buyer code, run IC225 (Inventory Reorder
Advice). The Inventory Reorder Advice program is similar to the Vendor Reorder
Advice. However, IC225 does not provide the option to update the PO Interface
file.
Note: The available quantity is based on the item's stock unit of measure. If
the buy unit of measure is different, this form converts the reorder quantity
based on the conversion data defined in the IC11.1 (Item Master) UOM form tab.
If the item's buy unit of measure does not evenly divide into the calculated
reorder quantity, the order quantity is rounded to the next buy unit of
measure. For example, if the reorder quantity is 100, the buy unit of measure
is cases and there are 24 items per case, 5 cases are ordered. If the order
multiple is greater than one, the next order multiple is ordered.
Updated Files
CKPOINT - This file is used in the event of a program or system failure
to enable a batch update program to continue from where it left
off.
ICCOMPANY - Used to validate the company number.
ITEMLOC - The Item Location file contains the dynamic information for an
inventoried item at a stock location.
POINTAOC -
POINTERFAC - This file is used to interface input from the Inventory
Control and Order Entry systems and outside systems into the
Purchase Order system.
Referenced Files
APCOMPANY - Used to get the vendor group for vendor number validation.
APVENGROUP - A vendor group represents a group of vendors that can be
shared by one or more accounts payable companies.
GLCODES - This file holds information relating to systems, source codes,
folders and process groups.
ICBIN - The Bin Numbers file is a master list of valid bin numbers in
a location used for tracking items by bin.
ICCATEGORY -
ICLOCATION - Used to validate the inventory location.
ICRPTGRP - The Report Group file stores the valid report groups used to
define groups of locations for reporting purposes.
ITEMMAST - The Item Master file stores static information about each item
such as description, classes, units of measure, and weight.
ITEMSRC -
MAJORCL - This file contains the major class codes which are entered on
Item Master records.
MINORCL - This file is a detail file for the Major Class file.
POCOMPANY - Used to validate the Purchase Order system company.
POVENDOR -
PROCUREGRP -
RQLOC -
INVOKED Programs
API4
ACAC
ACCL
IFCU
IFSG
IFAC
IFAU
SLSE
SLSU
ICI1
POIH
|
