Setting Up Minimum and Maximum Re-Order Quantities

Setting up Minimum, Maximum, and Re-Order point values for your SKUs will allow you the option of automatically adding SKUs from the same vendor as designated in the purchase order when their quantities are low.

1. Log in to AmberPOS and access the Inventory Menu.

2. Overview of Inventory List:

inventory_snapshot.JPG

      Step 1: Select the Inventory tab

      Step 2: Click Refresh to display your list of SKU's

      Step 3: Select the SKU you desire to setup minimum and maximum Re-Order Quantities for.

      Step 4: Click Edit Selected Item

 

3. Overview of editing the selected item:

edit_selected_sku_for_min_max.JPG

      Step 1: Specify the Stocking quantities of your desire. Under the purchase order screen in an existing purchase order, AmberPOS will give you the option to automatically order a quantity equal to the difference between the suggested maximum and the suggested minimum at the moment when the total QOH of the SKU goes below the Reorder Point number. In this case, as soon as the QOH of the front display which is currently 70 goes below the Reorder Point which is 50, through a feature in the purchase order menu, AmberPOS will automatically order the Suggested Maximum (100) minus the Minimum.

      Step 2: The default location is where the re-order quantity in Step 1 will be based on. Also, the quantities from the purchase order will be applied to specified location. In this case the location will be the Front Display of the store.

     Step 3: Select Save Quantity Changes to finalize the changes you have made to the Stocking Quantities.

 

*Optional* When using package SKUs during automatic re-ordering, AmberPOS will order only the minimum amount of packages before your quantity goes above the maximum, and allows only whatever amount is in the package(s) ordered to go over your maximum. For example, if your current QOH is 0, the package contains 12 items, but your max value is 10, AmberPOS will order only 1 package and only allow whatever extra quantity is ordered in the package to go over the maximum which is 2 in this example.

 

Preview:

PO_AUTO1.gif

 

 

4. Overview of Purchase Order:

min_max_purchase_order.JPG

      Step 1: Select the Purchase Orders tab.

      Step 2: Ensure the PO Details tab is open.

      Step 3: Select Auto Add Items.

 

5. A prompt will appear warning you that the system will automatically calculate the items below the re-order quantity.

Select OK.

 

6. Should you desire, you can specify which SKU's to automatically order the quantities for through the query builder that automatically appears.

If you want ALL the SKU's below the re-order quantity threshold to be ordered, then simply select Cancel in the query builder.

query_builder_for_min_max.JPG

 

7. If you selected Cancel in the query builder, you will receive a window as shown below.

auto_distribution.JPG

** THIS SECTION REQUIRES A SCRIPT TO WORK, WHICH WOULD NEED TO BE CUSTOM DESIGNED FOR YOUR BUSINESS (CUSTOM WORK).  Choose option 1 which is the default and prompt continue if you aren't pursuing this customer work.**      

Step 1: The items below the re-order point will be automatically ordered.

      Step 2: Figures out how much you are probably going to sell that month, and then it re-orders an amount based on the predicted value.

      Step 3: Select the date to which the expected sales will reach for calculation.

      Step 4: Select Continue/Calculate to complete your selection.

 

8. A window will appear designating the number of items that have been automatically added successfully.

1_items_have_been_added_successfully.JPG

 

9. There are three possible scenarios that can occur during an automatic order for the purchase order.

 (Example numbers are used, QOH = Quantity on Hand)

Scenario 1:

positive_QOH_auto_reorder.jpg

If QOH ≤ 6, then 15 - 1 = 14

If the Quantity On Hand is Below the Re-order point (6), the order quantity will equal to the Max minus the Min, which equals to 14 in this example shown, your final order amount for the purchase order therefore is 14.

 

Scenario 2:

re_order_23.jpg

 

If QOH ≤ 6, then 14 + 9 = 23

If the Quantity On Hand is below the Minimum point, the order quantity will equal to Max minus the QOH. So the final calculation is 15 - (-8) = 23, your final order amount for the purchase order therefore is 23.

 

Scenario 3:

positive_QOH_auto_reorder_3.jpg

 

If the Quantity On Hand is positive and above the Re-order point, nothing will be ordered and your quantity of the Item will remain the same after the purchase order.

 If QOH ≥ 6, then QOH stays the same

Preview:

PO_AUTO2.gif

 

 

Related:

Purchase Order Guide

 

Article written with AmberPOS version 4.14.05.05

0 Comments

Please sign in to leave a comment.
Powered by Zendesk