Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Picklist Additions
Microsoft Dynamics GP (Archived)

Picklist Additions

(0) ShareShare
ReportReport
Posted on by Community Member

Hello GP Community.  I'm running GP2010 with manufacturing.  I'm building a report based on the MO Picklist (PK010033) and one of the items I need to identify is items that were manually added to the picklist.  So, when the picklist is created in the beginning as a snapshot of the BOM, I need to be able to find which items were manually added after that.  It's a way for us to validate the BOM accuracy and also catch mistakes.  Our BOM's generally have 700 to 900 items and it's tedious to find the differences.  If you know of a way to help, please let me know.  Thanks.  -Trevor

*This post is locked for comments

  • Bron Profile Picture
    Bron 4 on at
    RE: Picklist Additions

    One of my clients created a separate Work Center for the new items - the Work Center was only used to 'issue' added materials to........

    Another client actually created a separate SQL table that 'recorded' what the 'BOM' was at time of MO creation - it was a bit of work - but the concept was important to them. They could then compare - actual MO final pick list consumption to the BOM at time of MO Entry. It was done with a SQL trigger of the PK010033 table.

    Of course if you are standard cost shop - you might be able to analyze material variances (at least in dollars) using manufacturing tables - there are some tables that store 'projected' costs, etc.

    Dan's idea has merit as well.

    Solution will be business process related since the table doesn't easily differentiate  between 'original' and 'added' items.

    Good Luck let us know what you come up with.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    RE: Picklist Additions

    I don't know of a way in the tables, but if you add items to the picklist, maybe start them with a positon or sequence number of 2000 or 1500 or some number much higher than any position or sequence number and then flag them that way.  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans