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.

    POINTERFAC - This file is used to interface input from the Inventory
                 Control and Order Entry systems and outside systems into the
                 Purchase Order system.


    POLINE     - This file contains purchase order line item information.

    PURCHORDER - This file contains header information for each purchase order.


Referenced Files

    APCOMPANY  - Used to get the vendor group for vendor number validation.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.


    APHLDINV   - The Hold file contains records of vendors, invoices, and
                 payments that are on hold.


    APVENCLASS - A vendor class is a subgroup of vendors that share common
                 payment or processing characteristics, such as office supply
                 vendors or employees.


    APVENGROUP - A vendor group represents a group of vendors that can be
                 shared by one or more accounts payable companies.


    APVENMAST  - Used to validate the vendor numbers.

    CUCONV     - This file maintains rate tables for each defined currency
                 relationship.


    CURELAT    - Used to validate currency relationships.

    GLCODES    - This file holds information relating to systems, source codes,
                 folders and process groups.


    GLSYSTEM   - This file contains company information used primarily by the
                 General Ledger system, but is also referenced by Lawson
                 subsystems.


    ICBIN      - The Bin Numbers file is a master list of valid bin numbers in
                 a location used for tracking items by bin.


    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.


    ITEMLOC    - The Item Location file contains the dynamic information for an
                 inventoried item at a stock location.


    ITEMMAST   - The Item Master file stores static information about each item
                 such as description, classes, units of measure, and weight.


    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.

    POITEMVEN  - This file contains the vendor's item identifier.

    POLOCCON   - List of valid override contracts for a location.

    POQUOTES   - This file contains purchasing information for an item at a
                 specific inventory location for a vendor and/or for a vendor
                 and purchase from location.


    STPOLINE   - This file contains purchase order line item information.

    STPURCHORD - This file contains standard purchase order header information.


INVOKED Programs

    IFCC
    IFCR
    IFSG