Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

For Specific Customer if we add Part A to SO then BC always add Part B and C

(0) ShareShare
ReportReport
Posted on by 15,428

Hi

We have one specific customer than when we sell them Part A they want us to send them Part B and C as well. This is only for this customer. Is it any out of the box function in BC that we can define this logic? Like when we create SO for this customer and add part A then BC add part b and c with the same QTY? 

I know we can create an assembly item and explode that in SO but we are trying to avoid creating new item. 

Thanks  

  • MahGah Profile Picture
    MahGah 15,428 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Thanks Alfredo

    That is all I needed. Just the best design. I appreciate your help

  • Verified answer
    Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    I would create another page.

    Something similar to the item cross-reference table.

    A new table  'Customer/ complimentary Items.'

    The fields of this new table could be: Customer No., Item No. , if the item is a 'Parent' or 'Child', Quantity(Base) and, maybe, valid-from and valid-to date.

    You will define a combination of customer/ parent items and minimum quantities that trigger the addition of the child items and their quantity when the parent item is added to the order.

    I cannot help you with the code. But from a solution point of view, that could be a starting point.

  • MahGah Profile Picture
    MahGah 15,428 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Thanks NorthW yzhums Alfredo Iorio

    For development what is your suggestion here? What is the best and most flexible method? Create a new page to define a relationship such as customer/item/addintion item or add anything to customer card or item card?

    Thanks

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Well if you don't want to use the standard lines, the BOM or the blanket order. Then you walk into customization land where you of course can do all kind of fun stuff.

  • Verified answer
    Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Hi.

    Have you considered Blanket Sales orders?

    The requirement to include certain items by default in a sales order looks like a sort of commercial agreement with your customer.

    If yes, you can create a blanket sales order with the three items in the lines and call out from the blanket order when creating new sales orders that include item A.

    As Zhu suggests, there is no standard functionality to add items by default to a sales order unless you create a new SKU and use the 'Explode BoM' in the sales lines.

  • MahGah Profile Picture
    MahGah 15,428 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Thanks Zhu 

    My hesitation was that assembly item or development are the only way to go. Thanks again  

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Hi, I still recommend the Assembly Bom.
    You can also add some convenient customizations, such as letting users select Assembly Bom on SO, and automatically adding lines to Sales Lines after selection.

    Or, is it possible to use the Item Substitution feature as well. Probably this also requires some customization, but this feature can associate items without creating new one.

    More details: https://yzhums.com/9342/

    Hope this will help.

    Thanks.

    ZHU

  • MahGah Profile Picture
    MahGah 15,428 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    Hi Inge

    Thank you for the link. My challenge is recurring is useful for limited items. In our case we have more than 100 items and each has a different item related to them. Also, customer can order combination of those 100 items.

    I mainly thinking that if I can define relationship between items and customer and say when A order add B,C and etc.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: For Specific Customer if we add Part A to SO then BC always add Part B and C

    You should check out if the recurring sales lines could help you with this:

    docs.microsoft.com/.../sales-how-work-standard-lines

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans