Skip to main content

Notifications

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

How to use the Gen. Prod. Posting Group of the items on the BOM when making a sales order?

Posted on by 237

Hello everyone, 

We sell food combos and each one is made with the Assembly functionality. Each combo has a BOM made of raw materials. Each time we make a sales order the cost of the assembly goes to the Gen. Prod. Posting Group of the food combo and not to the one of each raw material. 

i.e 

We sell an item called "Tomato soup combo" composed by tomatoes, vinegar, salt an a soda. The  "Tomato soup combo" has a Gen. Prod. Posting Group called "Finished goods", the tomatos have a gorup called "Vegetables", vinegar and salt "Groceries" and the soda "Beverages" 

Each time I sell an indivual tomato the accounts affected are the ones in the "Vegetables" Gen. Prod. Posting Group, the same goes for the vinegar, salt and soda. But when I sell the  "Tomato soup combo" the accounts affected are the ones on the Tomato Food combo Gen. Prod. Posting Group.  

Is there a way to make Business Central to affect the individual accounts configured on each item of the BOM?

Thanks for the help. 

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    How to use the Gen. Prod. Posting Group of the items on the BOM when making a sales order?
    What's the point of replying to a post from 3 years ago that was already resolved? And most probably replying using AI?
  • Suggested answer
    How to use the Gen. Prod. Posting Group of the items on the BOM when making a sales order?

    In Microsoft Dynamics 365 Business Central, you can configure the system to affect individual accounts for each item in the Bill of Materials (BOM) when selling a food combo. This involves setting up the system to recognize the individual components of the combo and post the costs accordingly.
    • Ensure that each item (e.g., tomatoes, vinegar, salt, soda) has its own General Product Posting Group configured correctly. This ensures that when these items are sold individually, the system posts the costs to the appropriate accounts based on their posting groups.
    • Review the Bill of Materials for the food combo (e.g., "Tomato soup combo, Chick"). Make sure that each component item is listed accurately with the correct quantities. Also, verify that each component item has its own General Product Posting Group assigned.
    • Check the costing method used for the items and the assembly (food combo). Ensure that the costing method is set up to calculate costs accurately for both individual items and assembled products.
    • Navigate to the Posting Setup page in Business Central. Here, you can configure how costs are posted for sales orders. Check the settings related to the posting of assembled items and ensure that they align with your requirements.
  • Esteban Navarro  Profile Picture
    Esteban Navarro 237 on at
    RE: How to use the Gen. Prod. Posting Group of the items on the BOM when making a sales order?

    Thanks Josh.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: How to use the Gen. Prod. Posting Group of the items on the BOM when making a sales order?

    Seems like the assembly BOM acts as a combo maker for sales. Maybe just explode the BOM so you get the sales recorded at each level.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans