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

Per Series BOM Quantities for packaging - Best way to handle?

(5) Share

Report

Posted on by Kai Stankey

What's the best way to handle BOM quantities for packaging the work on a per series basis? Example - In the BOM of a part I want to account for the consumption of a pallet. I would like the consumption of the pallet to work as follows. For 1 to 20 parts I want to consume 1 pallet. For 21 to 40 I want to consume 2 pallets etc. So, if I have a production order for 25 parts then I would consume 2 pallets. If I have a production order for 15 parts, then I would only consume 1 pallet.

Thanks,

Kai

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Mansi Soni 9,156 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello @Kai Stankey,

In standard Business Central, BOMs only support per-unit or fixed consumption, so they can’t directly handle tiered logic defined by you. If you want to automize this, you need a small customization that calculates pallets by rounding up the production order quantity.

Hope this answer will help you!

Regards,
Mansi Soni

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,790 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Kai,

Agreed with Mansi's approach as it's not achievable using Standard functionality.

Just suggesting one of the Custom approach:-

Customization Approach
Step 1: Define the Packaging Rule
Create a setup table or configuration where you define:

Item No. (finished good)

Packaging Item No. (e.g., pallet)

Units per Packaging (e.g., 20 units per pallet)

This allows flexibility across different items.
Step 2: Extend BOM Explosion Logic
Modify or extend the logic that explodes the BOM during production order creation:

Detect if the item has a packaging rule.

Calculate the required quantity of packaging item:

PackagingQty := RoundUp(ProductionOrder.Quantity / UnitsPerPackaging, 1);

Step 3: Inject Packaging Item into Component List
Use an event subscriber or codeunit to:

Add the packaging item as a component line in the production order.

Set the calculated quantity.

Ensure it’s marked as non-backflushed if you want manual consumption.

Step 4: Handle Posting and Consumption
Ensure that during consumption posting, the packaging item is:

Properly consumed.

Tracked in inventory.

Costed correctly (if applicable).

Note: This answer is based on my understanding, with Microsoft Copilot helping me organize and polish the wording.
Mark the Boolean true “Does this answer your Question” if this is Helpful.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Or you can create multiple Boms or Items, such as 1~20, 21~40, and then fix the quantity in each. This does not require customization, but requires users to select different Bom or item based on the actual production quantity.

Hope this helps.

Thanks.

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Kai,

To handle BOM quantities for packaging on a per series basis, like your pallet example, the best approach is to use a custom calculation logic in the production process, since standard BOM lines in Business Central don’t support conditional or tiered consumption out of the box.

Here’s a recommended strategy:

Use Routing or Production Journal Extensions: You can extend the production order posting logic to calculate packaging consumption dynamically based on the total quantity. For example, use a formula like ROUNDUP(Quantity / 20) to determine the number of pallets.

Create a Custom Component Line Type: Add a packaging item (e.g., pallet) to the BOM with a placeholder quantity, and override it during production order creation or posting using your logic.

Leverage Production Order Events: Use events like OnBeforeCalculateComponents or OnBeforePostConsumption to inject your custom quantity logic.

Alternative: Use a Planning Worksheet or Requisition Logic: If you prefer not to modify production posting, you can calculate packaging needs separately and create consumption entries manually or via a planning tool.

This method ensures flexibility and accuracy without hardcoding fixed quantities into the BOM.

Thanks and best regards,

Daniele

Note: This response was prepared with support from Copilot to ensure clarity and completeness.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,173 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Creating multiple BOM versions or separate items to represent each packaging tier (e.g. 1–20 parts = 1 pallet, 21–40 parts = 2 pallets, etc.). Each version would have the pallet quantity fixed, and the user would select the appropriate BOM or item based on the production order quantity.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No