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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / what table do i use fo...
Microsoft Dynamics GP (Archived)

what table do i use for a serial number report that would show both finished good and component serial numbers?

(0) ShareShare
ReportReport
Posted on by Sharon Burley 1,970

i'm trying to create a smartlist that would show finished good serial number and component serial numbers that are linked when doing the receipt in the manufacturing order. i can see this information in GP (specifically in the BOM View Trace window), but i'm having difficulty finding a table that shows the information so i can put it on a smartlist that would show the cross reference. any suggestions?

*This post is locked for comments

I have the same question (0)
  • Bron Profile Picture
    Bron 4 on at

    Sharon -

    You will definitely need multiple tables. I don't think there a single table in GP Mfg that stores what you see in the BOM View Trace - I think that window is storing everything in a temp table.

    I know the MOP1120 holds the 'serial or lot numbers' consumed by a FG receipt.......The MOP1050 will show what 'serial/lot' were picked...........The MOP1040 will show what 'serial/lot' was assigned to a FG receipt.......

    Good Luck - hope this helps

  • Sharon Burley Profile Picture
    Sharon Burley 1,970 on at

    thanks for the table names. i need to know which tables in SmartList builder though. do you know which SmartList tables MOP1120 and MOP1040 go to?

  • L Vail Profile Picture
    L Vail 65,271 on at

    I think what you want is the 'friendly name' of the table?

    MOP1040 is MOP Serial Lot Assign

    MOP1120 is MOP Receipt Detail Serial Lot

    If you have the physical name you can get the display name using several tools. The resource descriptions are built in Tools>Resource Descriptions>Tables

    Kind regards,

    Leslie

  • Sharon Burley Profile Picture
    Sharon Burley 1,970 on at

    thanks! this was a big help. i'm still having a hard time linking though. i can link the tables without problem but it just shows duplicates...i'm having a hard time linking to show which finished good goes to the corresponding component. there doesn't seem to be field to link that would distinguish this. i found the window Manufacturing Component Consumption Inquiry which shows exactly the information I want on a SmartList. I looked in the Resource Descriptions for Manufacturing windows and i don't see this window. Do either of you know what it would be under? it seems that there must be a way to show the cross reference between the serial numbers on a smartlist if i can see it in the system.

  • Verified answer
    Sharon Burley Profile Picture
    Sharon Burley 1,970 on at

    In case either of you ever need to supply the tables that will provide the information I was looking for in this situation (finished good serial number and linked component serial number), the tables needed are MOP1043 MOP_Serial_Lot_Links and MOP1040 MOP_Serial_Lot_Assign. Linking the tables by Parent Component ID, MO Receipt Number, and MO eliminates duplicates and restricts the SmartList to only show those items that have a link in place. Thanks again for the help. It definitely pointed me in the right direction.  

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans