Auto-Reorder Products

From MyMoney Online Help

The basics of auto-reorder

The basic idea of auto-reorder is pretty simple: you are telling the system that you would like to have a minimal inventory count (per item), so reorder that item when the inventory value goes below an assigned order point. 

The order point is the value for "X", and when inventory goes below "X", please reorder this many packages "Y" at this many units "Z" to get the inventory back to (at least) "X". The system will add items to the Pending Purchasing section based on a few factors, the two biggest ones being an item's Inventory count and the Auto-reorder order point value, or X below. 

_{Here are some general formulas that can be applied to scale. Keep in mind that nearly a million combinations can exist using just the values 0-99 for the four necessary values of auto-reorder.}

_{When inventory Qty goes below X}

_{Reorder Y Pkgs, at Z Units per Pkg}

_{Use x-y-z}

If an item is set to 0-0-1 and has an inventory:

Qty of 1; if you sell that item, Suite will not create a Purchase Order

Qty of 0; if you sell that item, Suite will create a Purchase Order ~3

Qty of 1; if you Bp that item, Suite will not create a Purchase Order (the inventory will also stay at 1)

Qty of 0; if you Bp that item, Suite will not create a Purchase Order (the inventory value will not go into Back Order either)

If an item is set to 0-1-1 and has an inventory:

Qty of 1; if you sell that item, Suite will not create a Purchase Order

Qty of 0; if you sell that item, Suite will create a Purchase Order ~3

Qty of 1; if you Bp that item, Suite will not create a Purchase Order

Qty of 0; if you Bp that item, Suite will not create a Purchase Order

If an item is set to 1-1-1 and has an inventory:

Qty of 1; if you sell that item, Suite will create a Purchase Order

Qty of 0; if you sell that item, Suite will create a Purchase Order  (No. of Pkgs = BO value + 1) ~1 ~3

Qty of 1; if you Bp that item, Suite will not create a Purchase Order

Qty of 0; if you Bp that item, Suite will create a Purchase Order ~2

~1 The No. of Pkgs will be the Backorder value + 1. So in a situation where the Backorders=2 the No. Pkgs would be 3, etc.

~2 If you sell the item (see ~1), the No. of Pkgs will increase to 2 as will all future Bp's until the Backorder value is removed.

~3 Inventory will be Total Qty: -1 & Backorders: 1

Additional formulas here.

• Understand there are Inventory Backorders (found in Product Maintenance) and Customer Backorders (found in Invoicing>Backorders). The value for an item's Inventory Backorder does not equal the number of Customer Backorders that are in the system and vice versa. These are two different measurements.
• Understand the difference between a Sale (no invoice line code) and a Bp/Bu.
• If you do not want auto-reorder on a particular item, set it to 0-0-1 and use Bp or Bu in the Line Code when the inventory hits 0. Keep in mind once you Bd that item to the customer, it will treat that as a sale and create an Inventory Backorder with a Purchase Order (if you haven't increased the inventory yet). 
• Selling an item when it's inventory is at 0 or lower, increases the Inventory B.O. and the Total Qty decreases (see ~3). If an item has a BO2/TQ -2, you can Edit Quantity: Entering 2 will make the inventory 0 or Entering 4 would make the inventory 2.

Advanced auto-reorder

Click here for more information. Additional information is available to understand the nuances of the auto-reorder system.