Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Manufacturing Tables

(0) ShareShare
ReportReport
Posted on by 40

Hi There;

I am hoping that you could help me understand how data moves from one table to another in Manufacturing–> 3rd Party –> MRP tables. ie what is the difference between dbo_MRP4020 and dbo_MRP0300.
I am trying to query all my planned demands and supplies for all my products in order to develop a comprehensive report fo rboth planning and purchasing purposes.
Many thanks in advance.

*This post is locked for comments

  • Suggested answer
    Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Manufacturing Tables

    There is a view that contains this info.   It is the MRP view called MRPV2130 that has all the qty buckets plus order point quantity and on hand.   I generally use Smartlist Builder and make it very useful.  

    Dan Liebl, CMA CPIM

    OTT,Inc

    dliebl@OTT-inc.com

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Manufacturing Tables

    The only thing I have ever found was this diagram by Waqas Butt. He has a lot of manufacturing related items on his blog http://waqasb.blogspot.com/

    Kind regards,

     

    Leslie

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans