web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Does anyone have any d...
Microsoft Dynamics GP (Archived)
Suggested Answer

Does anyone have any documentation about mfgfix Stored procedures for Manufacturing?

(0) ShareShare
ReportReport
Posted on by Tim Foster 8,515

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

I have the same question (0)
  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Does anyone have any documentation about mfgfix Stored procedures for Manufacturing?

    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

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Does anyone have any documentation about mfgfix Stored procedures for Manufacturing?

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans