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

Negative Qty on a Production BOM

(3) Share

Report

Posted on by Jenn Claridge

Hi Everyone!

Common in mfg is clients who want to have a negative qty on a BOM to recover some material in production.

This works great when you manually create Production Orders but when carrying out the item from Planning Worksheet, the Prod Order Component lines are only creating for the items with a positive value. So the negative Production BOM Line is dropping.

Any ideas?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

I was just going through the documentation and I don't think we have way to have negative BOM in planning worksheet.

https://learn.microsoft.com/en-us/dynamics365/business-central/production-how-to-create-production-boms

If my answer was helpful, please mark it as verified and give it a like.

Was this reply helpful? Yes No
Suggested answer

Shauna Langley 899 Moderator on at

Like (3)

Report
Copy link

Link copied!

Hi,

This is possible within Business Central so can you confirm which version you are currently running and has there been any bespoke code added around this area? See example below.

Production BOM has the following lines.

I created demand using a demand forecast for the item and was able to create a planned production order from the planning worksheet. When I look at the components I can see the following.

We have used this on a number of sites ourselves so it does work as I believe you require.

Hope that helps,

Shauna

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,206 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hope this helps: https://community.dynamics.com/blogs/post/?postid=114b5da8-2401-42a7-b6de-0f67be0b71ad

https://www.dynamicsuser.net/t/negative-quantity-in-bom/22457

https://community.dynamics.com/forums/thread/details/?threadid=4818af9b-6064-4b21-85a8-15529d485b46

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,210 Moderator on at

Like (2)

Report
Copy link

Link copied!

This should be normal behavior. Here is a similar post. https://community.dynamics.com/blogs/post/?postid=114b5da8-2401-42a7-b6de-0f67be0b71ad

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,319 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

I can also confirm that BOM lines with a negative quantity are transferred over to the prod. order components. It works when the prod. order is created manually or from the planning worksheet.

Also, the post below is regarding AX not Business Central.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
TC-27100821-0 8 on at

Like (1)

Report
Copy link

Link copied!

การใส่จำนวนติดลบที่ consumption มีข้อเสียไหม ฉันต้องการที่จะใช้งานกับการที่มี co-product

Was this reply helpful? Yes No
TC-27100821-0 8 on at

Like (1)

Report
Copy link

Link copied!

Is there any disadvantage to adding a negative number to consumption? I want to use it with co-product.

Was this reply helpful? Yes No
Suggested answer

Gregory Mavrogeorgis 992 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

This is standard behavior. The Planning Worksheet/MRP explodes BOMs only for positive consumption (dependent demand). Negative BOM lines are treated as by-products/returns, so they’re ignored when Carrying Out action messages → the created Prod. Order will only get the positive component lines.
Ways to handle it:

Refresh after Carry Out (no code):
After the Prod. Orders are created from the Planning Worksheet, open them and run Actions → Replan/Refresh Production Order. That re-explodes the BOM like the manual-create flow and will bring in the negative lines. If you don’t want to do this manually every time, see #2.

Tiny automation :
Add a small subscriber that, after Carry Out creates the Prod. Order, calls the same Refresh/Calc Prod. Order routine. That keeps your planning flow but guarantees the negative lines are inserted automatically.

Model as additional output (process workaround):
Many manufacturers treat the recovered material as extra output rather than a “negative component.”

Keep the BOM with only positive components.

When reporting production, add a line in the Output/Production Journal for the recovered item (positive qty).

This preserves planning logic (no dependent demand for a “negative component”) and still returns stock properly.

ISV / custom logic:
If you truly need negative BOM lines to be created at Carry Out time, extend the Carry Out logic to copy negative lines from the Production BOM into Prod. Order Component with negative quantities. Be sure to handle: item tracking, flushing method, costing effects, and reservations/picks.

Why MRP ignores them:
Planning engines calculate supply for demand; negative quantities don’t create demand for supply, so they’re excluded by design. That’s why manual “Create Prod. Order” (which simply copies the BOM) shows them, but “Carry Out” (which is planning-driven) does not.

If you have found this helpful please mark it as verified

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,319 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Is there any disadvantage to adding a negative number to consumption? I want to use it with co-product.

This is an old thread, I would suggest creating a new post with this question on the forum

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

1 people found this reply helpful.

Was this reply helpful? Yes No