We have only one warehouse, and one bin for this item, but the PartWhse_QtyOnHand does not match PartBin_QtyOnHand. Would anybody know why?
Try this program when no users are making changes:
[cid:image001.png@01D2A8B5.915E29A0]
1 Like
don’t know the why but it gets out of whack occasionally, you can usually fix it, you may already know about this… filter on the part in question (don’t run this against every part in your db) in your test environment do report only first to verify it will make the change to expect then run it under report and update
I agree with Bernie, we run that refresh allocations program once a week.
Nice they automated 6340