Skip to main content

Notifications

Microsoft Dynamics GP (Archived)
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 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

  • 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

  • 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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans