<< Click to Display Table of Contents >>

IN-D  Print Reorder Report

Purpose of Program

This report can be used as the primary worksheet for determining what inventory items need to be purchased or manufactured.  The report calculates a theoretical available quantity using the on-hand, on sales order, on back order, allocated, on purchase order, and on work order balances.

This available quantity is compared with the inventory reorder level and the amount over or under the Reorder Level is shown.  A reorder amount is displayed as a guideline for how much to order.

The report can be run in summary or in detail.  The detail version shows all sales orders, purchase orders, work orders, and allocations, including dates and quantities.

General Program Operation

Indicate the sort order of the report (Item, Class or Vendor) and indicate if you want to limit the report to all the components of a single top assembly BOM in which case you will be limited to a single item number which is the top level assembly desired.  Otherwise, select from/thru ranges by item number, product type, item class, Category, Primary Vendor, Cycle Code, Planner Code.  You may restrict the report only to items where the available quantity has fallen below the reorder level and limit by Active status.  Indicate whether to include the second description line and primary vendor and last cost to assist in preparing purchase requirements and whether to use Warehouse Location specific reorder levels and whether to rebuild stock status.

If you indicate yes, the various stock status fields (on sales order and backorder, on purchase order, on work order, allocated) will be rebuilt from scratch directly from the sales order, purchase order, and work order files.  This insures that these fields are absolutely correct.  This rebuild routine can take along time to run, depending on the size of the related data files, so you have the option of skipping it.  You may find that running it periodically as sufficient.  An alternative to running the rebuild routine within this report is to periodically run SM-J-C  Reconcile Inventory On-Hand for preventative maintenance of your inventory files.  SM-J-C contains the rebuild routine as well as many other file maintenance functions.

You can also limit the report to a from/thru range of start dates, finish dates, or work order numbers and if you have multiple warehouse locations, designate the Location(s) to be included..

If you specify including the detail, the report will list all open sales orders, purchase orders, and allocations.  This could make the report very long if many items are selected.