Name of Feature/Request:
Have the option to restore past Reorder calculation on Stock Status Report to be: Qty on PO + Qty Available - Reorder Point when Reorder Amount = 0
What financial, time savings, or quality of life improvements will occur with this:
Be able to report on the accurate actual amount that needs to be reordered based on quantities to then quickly create a PO for that same amount.
Attempted solutions so far:
Match the Reorder Amount to be the same as the Reorder Point set at the Item level.
Digging deep - Any additional Why behind this request / How was this accomplished before Striven:
Although we haven’t really used it but we are starting to but it doesn’t appear to be working on the stock status report. For example I have an item that has a reorder point of 1,000 pieces, the report shows that I have 682 on hand, 468 on incomplete build and, 214 available but the reorder column says to order 0 when it should say 786. Reorder value used to be calculated as desired prior to the Q1 2025 update to allow customers to be able to maintain value at 0.
Current calculation details:
If (Available + Qty on PO) > Reorder Point (set at item level), then Reorder = 0
If (Available + Qty on PO) <= Reorder Point (set at item level) and Reorder Amount (set at item level) > (Available + Qty on PO), then Reorder = Reorder Amount (set at item level) - (Available + Qty on PO)
Note: This would require that the users fill out the reorder amount at the item level for this to make sense.
Otherwise Reorder will be 0.