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

From Catalyst
Jump to: navigation, search
(Bulk update)
 
(One intermediate revision by the same user not shown)
Line 8: Line 8:
 
Having run the Reordering report you will be shown a list of items to order on the {{Tab|Confirm Calculated Results}} screen.
 
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.  
+
The {{DataPrompt|Order}} column displays the quantity to order per item.
 
* This value is calculated using the following method:
 
* This value is calculated using the following method:
  
 
If the Maximum Level is set:
 
If the Maximum Level is set:
; Maximum Level - Projected Quantity.  
+
; Maximum Level - Projected Quantity.
  
 
If the Maximum Level is set to Zero:
 
If the Maximum Level is set to Zero:
; Reorder Level - Projected Quantity.  
+
; Reorder Level - Projected Quantity.
  
The {{DataValue|Projected Qty}} column shows you the Quantity in Stock - Quantity on Sales Order + Quantity on Purchase Order.  
+
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 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.
 
** 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 ===
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.  
+
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.
  
 
== See also ==
 
== See also ==
Line 31: Line 31:
  
 
{{KB_Tags|reorder, recommended stock levels, order, recommended order quantity, order quantity, order qty, projected qty, projected}}
 
{{KB_Tags|reorder, recommended stock levels, order, recommended order quantity, order quantity, order qty, projected qty, projected}}
{{FAQ}} {{KB_ST}} {{KB_OP}}
+
{{FAQ}}{{How}}{{KB_OP}}{{KB_ST}}

Latest revision as of 05:35, 19 June 2019

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