I have found a white paper for mfgfix90CHECKDATA that explains many things. There are more mfgfix stored procedures in the Company database. Does anyone have any guidance about when or how they are used? The reason I am asking is I have pending Bin Allocations in Manfacturing that are not related to any Pending Allocation/Issue transaction on the MO. I see entries in MOP1900 and MOP1025 that have no "parent" Allocation/Issue. This is causing allocations in IV00112 (Bin table), but nowhere else (not in IV00102). I need to free up the allocated material for other transactions. Any help would be appreciated.
Tim
*This post is locked for comments
Richard,
Thanks for the script. I deleted the offending entries and they reappeared after Inventory reconcile. There must be other tables in Manufacturing that are analyzed during reconcile.
My original question still remains. Bump!
Tim
Email me at rwhaley@accoladepublications.com I have a script (from MS) that identifies ALL tables that have records pertaining to the allocations. Usage is as follows:
1. Reconcile the item first and make sure the problem still persists.
2. Run this script and identify all records that affect the allocation.
3. Delete the records identified.
BTW..What version of GP are you running? The paper you read was released with GP9
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156