Reasons the Values in Your Graph Could Be Negative
Issue 1: Open Purchase Orders or Missing Invoices
Solution: Close out all delivered POs and enter all missing invoices. Watch videos below for instruction.
Issue 2: Incorrect Sales Matching
Solution: Sales matching discrepancies may be depleting an incorrect item.
1. Review your Variance Report to identify mismatched vintages or items.
2. Review your perpetual inventory to also find negative quantity items.
Then use the Rematch Guide below to adjust the error.
Note: You will need to rematch sales back to the first time that item was sold within this inventory period. Then use the item stats page – sales history to identify each sale since then that will need to be re-matched. A rematch needs to be done for each sale.
By addressing these two issues in BinWise, it will not only clean your data, but also remove the negative values in your Perpetual Inventory Pie Chart.