Hello Community, hope you can help
I have a Saved Item Search that includes quantity sold for a specific time period but it is not returning the correct numbers
The standard Sales By Item report advises the quantity sold during the same period = 1405 yet the formulas are showing 1430 for location PW and 0 in both Scrap locations (there are 3 credit memos issued during that time period so there should be numbers returned in both Scrap locations - screenshots included below)
We do NOT restock in our scrap locations so I tried removing the {inventorylocation} from the formula for both scrap locations but that makes things worse
PLEASE HELP - what am I doing wrong?
Thank you so much in advance!
CRITERIA/RESULTS:
RETURNS/CREDIT MEMOS:
CM2745: Qty of -12 for location Scrap-PW
CM2874: Qty of -13 for location Scrap - LA
CM2919: Qty of -3 for location PW
RESULTS FROM ITEM SAVED SEARCH: