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. Keep in mind that it does not take dates into consideration so if an order for a needed item is coming in later than the demand for it this program will not show it as a shortage.
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. You can also exclude future supply if you want a report of immediate shortages. 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 a long 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 IN-L-S or SM-J-C 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. You can also exclude future supply to see what you are currently short of.
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.