Printing Custom Inventory Reports

Printing Low-Stock Reports (Custom)

Low-stock reports list suggested order quantities. You can use them to purchase items for stock. There are three standard low-stock reports, each with different information: the Low-Stock Wholesaler Report ( Min/Max), the Low-Stock Wholesaler Report-Cycle, and the 13-Month Low-Stock Report.

Any of these reports can generate a file to automatically create purchase orders through the Short-Buy process. For information, see Placing Short-Buy Purchase Orders.

The Low-Stock Wholesaler Report ( Min/Max)

You can set Minimums ( Mins) and Maximums ( Maxes) for each item in the Item History Inventory tab. Min is the least to have on the shelves. Max is the most to ever have on the shelf.

If you are using Mins and Maxes to help you stock your warehouse, you can print the Low-Stock Wholesaler-Min/Max Report to show you what items are at or below your minimum, and what you need to order to bring the stock levels up to the maximum. On-hand, on-order, and backordered quantities are analyzed to project if you will equal or go below your minimum.

Note: Only items that have been given maxes in the Max box and are at or below the minimum in the Min Box in the specified location are included in the report.

The suggested order amount is calculated for each item that is at or below the minimum according to the following formula:

Max - O/H = Need

Need - O/O + B/O = Order Quantity

The Low-Stock Wholesaler-Cycle Report

The Low-Stock Wholesaler-Cycle Report suggests an order amount for each inventory item based on sales history and cycle weeks (the length of time between purchase orders). This report bases

suggested order quantities on the sales history of an item and the projected number of weeks between orders (cycle).

Note: This report uses extended item history information. Therefore, it is only accurate for items in the stock classes for which you keep extended history. For details on extended item history, see In the Item History History Tab.

The past three months’ sales data is used to calculate a suggested order quantity to meet future sales. Month-to-date sales are not used. The formula weights the most recent month and takes into account quantities currently on-order, on-hand, and backordered. The number of weeks in your order cycle must be specified. The default number of cycle weeks is 10.

Note:  The order amount is rounded up one decimal point. Because of this, you may have extra quantities on the report.

The order amount is calculated for each item according to the following formula:

( [ (M1 x 2) + M2 + M3] x CW ) = Need

                17

Need - (O/O + O/H) + B/O = Order Quantity

This formula produces two projections. The Need column shows the projected total sales for an item over the time period specified by the cycle weeks. The Order column shows the suggested order amount, based on the projected total sales and the current on-hand, on-order, and backordered quantities.

13-Month Low-Stock Report

The 13-Month Low-Stock Report suggests order amounts for each inventory item based on sales history for the past 13 months. This report also displays 24 months of usage. You must create an I-DB-INDEX file for the suggested order amounts to be accurate. To learn more, see Building Item Indexes.

Before you can print the 13-Month Low-Stock Report, you must catalog the selector name through the ( LR) Inventory Standard Reports screen. The selector name for this report is REKIND.

The suggested order amount is calculated for each item according to the following formula:

( [ TS - HM - LM ] x 2 ) = Need

            11

Need - (O/H + O/O) + B/O = Order Quantity

1. In the (R) Inventory Selectors screen, enter the number in the Selector field that corresponds to the report to print. To print the Low-Stock Wholesaler Report-Min/Max, type 12. To print the Low-Stock Wholesaler Report-Cycle, type 13. To print the 13-Month Low-Stock Report, type its corresponding number.

2. At the Do You Wish To Change All prompt, type E to print the report as is.
   
   Type P to make changes to the print line. See Changing the Inventory Print Line.
   
   Type A to make changes to the body of the report. See Changing the Body of an Inventory Report.

See also:

Saving Inventory Report Changes

About Inventory Reports

Printing Low-Stock and Overstock Reports (Standard)