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) / Lot Number Per Quantit...
Microsoft Dynamics GP (Archived)

Lot Number Per Quantity in Assembly Serial/Lot Entry

(1) ShareShare
ReportReport
Posted on by haroonattari 2,325

My customer is using Bill of Materials and Assembly Transaction in Microsoft Dynamics GP. There are some assemblies with very large quantity which takes very long to process these. The reason is that because GP populates a line item of the Component Lot Number for each Qty on the Assembly Serial/Lot Entry automatically.

Whereas it should be like this:

Will be grateful if anyone of you could let me know a way to configure GP so that it populates Assembly Serial/Lot Entry window shown in second screen shot.

In case you want to know, they are using Microsoft Dynamics GP 2013 Service Pack 2.

Thanks

Haroon

*This post is locked for comments

  • soma Profile Picture
    soma 24,410 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    Before posted my first suggestion, I have just tried to check whether this option is block or unblock the auto populate lot numbers in assembly entry transactions. Not checked how this option allocate the lot numbers. After seeing your answer only I have checked the allocation process.

    Haroon, thanks for the update.

    This option is help us to speed up the assembly entry transactions.

    All the best....

  • haroonattari Profile Picture
    haroonattari 2,325 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    I have already read this. In fact, the paragraph I pasted in my earlier post was from this help file :)

  • soma Profile Picture
    soma 24,410 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    Please have a look on below information from GP helps file about the option "Allow Linking of Component and Finished Good Serial and Lot Numbers".

    If the option to allow lot and serial numbers of components to be linked to the lot or serial numbers of the finished goods is marked, Bill of Materials allocates a block of lot-numbered components for each finished item. (Later, you can link each block to the lot or serial number of each finished item.) If you don’t mark this option, Bill of Materials allocates the entire component requirement in one block.

    For example, suppose you assemble four phone systems. Each system requires 15 feet of telephone cable, for a total of 60 feet for all four systems.

    If the cable is taken from a single lot, lot allocation information could be saved this way:

    Lot

    Allocation if option is marked

    Allocation if option isn’t marked

    LOT A

       (75 feet available)

    15 feet

    15 feet

    15 feet

    15 feet

    60 feet

    If the allocations are taken from multiple lots, lot allocation information could be saved this way:

    Lot

    Allocation if option is marked

    Allocation if option isn’t marked

    LOT B

       (20 feet available)

    15 feet for the first item

    20 feet

    5 feet for the second item

    LOT C

       (25 feet available)

    10 feet for the second item

    25 feet

    15 feet for the third item

    LOT D

       (80 feet available)

    15 feet for the fourth item

    15 feet

    If my understand is correct, the option "Allow Linking of Component and Finished Good Serial and Lot Numbers" is used for how (block of lot-numbered components for each finished item or entire component requirement in one block) the lot number allocate for bill of material finished goods. Not blocking the auto assign lot number in assembly entry transactions.

    Hope this helps!!!

  • haroonattari Profile Picture
    haroonattari 2,325 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    You are welcome, Mahmoud. Thanks for sharing your thoughts too.

  • haroonattari Profile Picture
    haroonattari 2,325 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    Whether the option is marked or unmarked the system will auto populate the Assembly Serial/Lot Entry window but to understand the difference read following from GP Help:

    If the option to allow lot and serial numbers of components to be linked to the lot or serial numbers of the finished goods is marked, Bill of Materials allocates a block of lot-numbered components for each finished item. (Later, you can link each block to the lot or serial number of each finished item.) If you don’t mark this option, Bill of Materials allocates the entire component requirement in one block.

  • soma Profile Picture
    soma 24,410 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    Hi Haroon,

    Already I have tried to unmark this option earlier to my first suggested answer. But, this wasn't block the auto populate of serial/lot numbers in assembly entry transactions.

    Can you please check again and let us know?

    Your reply is much appreciated.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    Mr Haroon

    I have been following your post from the early beginning. Although I didn't have a proper answer for your inquiry, I was quite interested for any relevant and applicable solution.

    I am impressed with this option, absolutely thankful for your feedback as well.

  • Verified answer
    haroonattari Profile Picture
    haroonattari 2,325 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    I got the option within Microsoft Dynamics GP to aggregate Lot Number.

    There is a check box (Allow Linking of Component and Finished Good Serial and Lot Numbers) on Bill of Material Setup window (Inventory >> Setup >> Bill of Materials). Unmarking this checkbox did the magic.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    You can create a customization to block the auto populate process for serial/lot numbers to GP assembly serial lot tables(BM10400). But, it will not reduce the time for assembly enter release process. It will clear all the auto assigned serial/lot numbers from assembly serial/lot entry window(helps you to reduce a one step Remove All).

    Note: I would not recommend for breaking GP standard logic.

    Hope this helps!!!

  • haroonattari Profile Picture
    haroonattari 2,325 on at
    RE: Lot Number Per Quantity in Assembly Serial/Lot Entry

    As I said in my first post, that there are some assemblies with very large quantity hence 'Posting' these Assembly transaction is taking very long. Also when 'Remove All' button is clicked it also takes penalty of time, hence I was looking for any solution through which I can speed this up.

    Anyway, thanks for your help.

    Regards

    Haroon

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans