Microsoft® Excel® 2007+
Platform: Sage 100
The Inventory Reorder Manufacturing solution is used to list current On Hand Quantity, Purchase Order Quantity, Work Order Quantity, Sales Order Quantity, Back Order Quantity, Quantity Required for Work Orders, and Available quantity information for each item and warehouse. In addition, the report prints a Recommended Reorder Quantity, which is based on the reorder information entered in Item Maintenance and a Recommended Purchase Quantity is displayed using the items Purchase Unit of Measure. This solution has four separate reports in the Inventory Reorder Quantities per Warehouse: First: All Items. Second: Exclude items with a Recommended Order Quantity equal zero.
Third: Exclude items with both a Recommended Order Quantity and On-Hand Quantity equal to zero. Fourth: Exclude items with these quantities equal to zero: On Hand Quantity, On Purchase Order Quantity, On Work Order Quantity, On Sales Order Quantity, On Back Order Quantity, Qty Required for Work Orders, Available Inventory, Reorder Point, Minimum Order Quantity, Economic Order Quantity, Maximum On Hand Quantity. All of these reports contain common dynamic features for filtering by Warehouse Code, Product Type and Procurement Type, providing rapid access to the inventory information.Prevent over-capitalisation in inventory and abandon those 'out-of-stock' labels by using the Inventory Reorder Manufacturing solution for Sage 100.