We would really like to use the Total Demand Qty column in Part Tracker.
Recently we have changed all primary warehouses on parts to reflect which location we want them to go to.
I tested this once. Changed the primary warehouses on the part, ran MRP and verified it reflected how I needed it to on material list in job tracker. I then checked Part Tracker and it DID show that the demand was in the warehouse I wanted it to be. Success right?
Unfortunately, no!
Ever since my first test, we cannot get this situation to duplicate again. I have tried on purchased/manufactured parts. Every time part tracker just shows the demand in the OLD primary warehouse.
Whats the fix here? We have already tried the step below. Are we missing something? Theres no way that first test was just a coincidence right?
Wanted to take the opportunity to enjoy field help being HELPFUL again! So is the demand coming from sales orders or jobs? Are the orders/jobs still pointing to the old warehouse?
Was the test you ran on a new part without demand? My guess would be that you would have to clear out all the old demand records before they would show correctly. Not sure where all the demand records are coming from, but I would start checking the job tables to see if you could manually change a record
Are you sure? i.e. you verified with baqs on all open orderrel and all open job prod including unfirm? If you are sure its wrong and the refresh utilities don’t fix it then it sounds like you need a data fix.
