Troubleshooting: Item balance quantity fell below reorder level but is not shown in Reorder Advice

From AutoCount Resource Center

Question: The item 00004 balance quantity is 4 which is below reorder level 200, but this item is not shown in Reorder Advice. Why?

Version: 1.8 / 1.9 / 2.0

Reorder item not shown1.png


Reorder item not shown2.png


Reorder item not shown3.png


Possible Reason:

This item may have outstanding P/O, outstanding S/O etc. and you have enabled the option of ‘Include Outstanding P/O & Outstanding S/O & Outstanding Consignment & Outstanding A/O’ in Reorder Advice Report.
When this option is checked, calculation of balance quantity will include all related outstanding documents.
So, when the item’s forecast quantity is higher than reorder level quantity, it will not appear in reorder advice.

Note: The option (when enable/disable) of By Location, Calculate All UOMs will also affect the result.


Solution:

You may inquiry this item in Stock > Available Stock Status report to notice there is a P/O quantity. After added P/O qty, the forecast quantity = 210, which is higher than reorder level qty 200.

Reorder item not shown4.png


You may also try uncheck the option of ‘Include Outstanding P/O & Outstanding S/O & Outstanding Consignment & Outstanding A/O’, to see the effect (item 00004 is shown in Reorder Advice). Because when excluded outstanding P/O, the forecast qty becomes 10, which is lower than reorder level quantity, so the item will appear in this report.

Reorder item not shown5.png


By: Jodie 220525, Lay Swan 220628, P220629


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations