Amount To ReOrder qty query
We have painstakingly gone through each of our products setting Low Level Stock figures for the replenishment system, but the Amount To ReOrder qty is not really any good to us as a fixed qty, we need this to be a calculated figure where Amount To ReOrder=Low Level Qty MINUS Stock Level on Hand, otherwise we end up with massive overstock.
Short of me exporting to Excel and making my own formula which as a print-out for our warehouse isn't very user-friendly, is there any way I can get into the parameters of the report and change the information we see to exclude current fields, add new fields and add this formula?
Thank you in advance.