Difference between revisions of "How is the recommended order quantity calculated?"

From Catalyst
Jump to: navigation, search
Line 1: Line 1:
{{Update}}
 
 
== Summary ==
 
== Summary ==
This article explains how the recommended order quantities on the {{ST}} reorder report are calculated.
+
This article explains how the recommended order quantity in the {{ST}} reordering calculated results screen are calculated.
  
 
== More Information ==
 
== More Information ==
=== Recommended Order Quantity ===
+
Please see [[How do I Run a Reorder Report?|this]] article to explain how to use the Reordering option.
When you use the "Reorder Report" from the "Reordering" option in the stock control no user configurable quantities are used. Platinum uses a simple reorder formula which is :-
+
 
* If the maximum quantity is zero the recommended reorder quantity will be the quantity required to bring the stock level to the reorder level.
+
== Recommended Order Quantity ==
* If the maximum quantity is not zero the recommended reorder quantity will be the quantity required to bring the stock level to the maximum stocking level.
+
Having run the Reordering report you will be shown a list of items to order on the {{Tab|Confirm Calculated Results}} screen.
 +
 
 +
The {{DataPrompt|Order}} column displays the quantity to order per item.
 +
* This value is calculated using the following method:
 +
 
 +
If the Maximum Level is set:
 +
; Maximum Level - Projected Quantity.
 +
 
 +
If the Maximum Level is set to Zero:
 +
; Reorder Level - Projected Quantity.
 +
 
 +
The {{DataValue|Projected Qty}} column shows you the Quantity in Stock - Quantity on Sales Order + Quantity on Purchase Order.
 +
 
 +
If you are unsure how the Projected Quantity has been calculated click on the {{Button|Orders}} button for the selected item. This will show all outstanding ''S''ales and ''P''urchase Orders for that item.  
 +
** If you feel the value is incorrect you should check these orders and make the necessary corrections e.g. remove a duplicated Purchase Order, check with colleagues if an item has been ordered under the wrong part number, check if a customer has been sold a different item to that ordered for them etc.
  
 
=== Packing Quantities ===
 
=== Packing Quantities ===
That recommended order will then be subjected to any packing quantities for that stock from the supplier you specified on the range screen.
+
When you click {{Button|Process}} to either create the orders or move to the {{Tab|Order Review}} screen, the system will apply pack quantity settings for the item where relevant i.e. if the pack quantity is 10 and the recommended order quantity is 7, the system will increase the order quantity to 10.  
{{example|If the recommended reorder quantity was 26 and the supplier only supplies this stock line in packs of 10 the final recommended reorder quantity would be 30.}}
 
  
 
== See also ==
 
== See also ==
* [[Creating a Purchase Order]]
+
* [[How do I Run a Reorder Report?]]
 +
* [[How do I Amend a Purchase Order?]]
 
* [[How do I View Outstanding Sales Orders?]]
 
* [[How do I View Outstanding Sales Orders?]]
* [[Processing a Purchase Order]]
 
  
{{KB_Tags|reorder, recommended stock levels}}
+
{{KB_Tags|reorder, recommended stock levels, order, recommended order quantity, order quantity, order qty, projected qty, projected}}
 
{{FAQ}} {{KB_ST}} {{KB_OP}}
 
{{FAQ}} {{KB_ST}} {{KB_OP}}

Revision as of 11:19, 17 October 2017

Summary

This article explains how the recommended order quantity in the Stock Control reordering calculated results screen are calculated.

More Information

Please see this article to explain how to use the Reordering option.

Recommended Order Quantity

Having run the Reordering report you will be shown a list of items to order on the [Confirm Calculated Results] screen.

The "Order" column displays the quantity to order per item.

  • This value is calculated using the following method:

If the Maximum Level is set:

Maximum Level - Projected Quantity.

If the Maximum Level is set to Zero:

Reorder Level - Projected Quantity.

The 'Projected Qty' column shows you the Quantity in Stock - Quantity on Sales Order + Quantity on Purchase Order.

If you are unsure how the Projected Quantity has been calculated click on the [Orders] button for the selected item. This will show all outstanding Sales and Purchase Orders for that item.

    • If you feel the value is incorrect you should check these orders and make the necessary corrections e.g. remove a duplicated Purchase Order, check with colleagues if an item has been ordered under the wrong part number, check if a customer has been sold a different item to that ordered for them etc.

Packing Quantities

When you click [Process] to either create the orders or move to the [Order Review] screen, the system will apply pack quantity settings for the item where relevant i.e. if the pack quantity is 10 and the recommended order quantity is 7, the system will increase the order quantity to 10.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
reorder, recommended stock levels, order, recommended order quantity, order quantity, order qty, projected qty, projected