This option generates a report showing what should be reordered so that the inventory does not stay under its pre-set minimum. It will suggest the quantity to order in the buying format so that the inventory gets back to its pre-set maximum. The following information will be printed on this report:
Supplier Code
Select a supplier code from the list
Inventory Category
If you select all the items, you can specify the inventory category you want to report.
Inventory Group
If select all the categories, you can specify an inventory group.
Location
With the multi-locations option the system gives you the possibility to select a specific location in a drop-down list. If you want this report for all the locations just check the "All" option. In this case you will have to specify if you want a specific department by selecting its name or by checking "All' option if you want all of them.
Department
Departments can be selected only if the All checkbox is un-checked for the Location filter.
Sort Order
Select the field you want the information to be sorted on. There are four different sorts available: The Description The Category The Group The Supplier
The following information will be printed in this order:
Code
The product code of the inventory item.
Product
The product description of the inventory item.
Supplier
The description of the last supplier.
Inventory Category
The inventory category this item belongs to.
Qty Stock
The actual quantity in stock using the inventory formats.
Inventory Unit
The inventory format of this item.
Min.Qty
The minimum quantity using the inventory format entered for that item.
Max.Qty
The maximum quantity required using the inventory format.
Qty.Purchase
The quantity suggested to buy (using the buying format) in order to reach the maximum quantity.
Buying Unit
This is the purchase format.
Cost
This is the last unit price you paid for this item.
Total
The total dollar amount to purchase. The last line of this column will show you the complete total.