We are on 10.1.400.11 and have had continual problems with our material (part) quantities and allocations becoming out of sync on the Part Tracker Warehouses display. We have to run the “Refresh Part Quantities and Allocations” repair process to fix the problems. The challenge is you can not run this during working hours due to possible data corruption and it is not a process which can be scheduled.
Does anyone know if the problem causing the variances has been fixed? Does anyone know a way around it so we can run the repair process at night unattended?
We are on 10.1.400 as well and while we don’t use part allocations or the Part Tracker Warehouse display - we have beacoup problems with part discrepancies on the Production Planner Workbench. An open ticket is still unresolved.
I was able to trace down one cause of the Part quantities going out of sync. Here is that scenario
The receiving clerk receives an item into location
Receiving clerk decides it should be in a different location.
Receiving clerk deletes transaction and receives into correct location.
Part Quantities go out of sync.
Along the same lines ,
the part is received at 0 cost or incorrect cost and transaction is deleted ,
on the Purchase Order correct price is entered
Part is re-received ( possibly to different location than before ,I have not recreated this one.)
Part Quantities go out of sync.
I realize a procedural fix would be to not allow receipts to be deleted, but…not my call on that.
I wound up writing a SQL query to catch mismatched quantities, IT runs it every night (an automated process)
and emails me the results. Now if I can only get the email if there are actually rows returned from the query.
…