Prod. BOM calculation

(1) Share

Report

Posted on by MB-05081440-0

I want to create a Prod. BOM list where the user can decide, which materials were actually used for that process.

I have an item which has a "Prod. BOM List" assigned in which a lot of items (components) are listed, but without quantity.

When i create a new prod. Order and use "Update Lines" only the lines which have a quantity are actually imported into the Prod. Order.

I would expect all component lines to be imported, no matter if there is quantity or not.

In case of manual posting i definitely would have to control the quantity i used for that production order.

Can anyone help me if this behavior is an error or by design?

Categories:

Business Central

All responses (12)

Answers (1)

MarceloBorges 112 on at

Like (2)

Report

Prod. BOM calculation

Thanks for sharing your findings. I see this piece of code on the W1 source code as well, so, the conditions you mention, they apply in the base product.

https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/ef1744cbfbcabdcde6e0d76d25c08a62d6e8d2a3/BaseApp/Source/Base%20Application/Manufacturing/Document/CalculateProdOrder.Codeunit.al#L320

This is good to know since some of us got different testing results.
Verified answer

MB-05081440-0 23 on at

Like (2)

Report

Prod. BOM calculation

Thanks to everyone for the input, i think i've found the issue, although i don't fully understand why this is programmed that way.
I'm using the german localization of BC.

In case the component quantity is Zero, the exit is triggered before the INSERT for the actual component is performed.
It's only working as expected in case the "manufacturing policy" is set to Warehouse.
Which kind of defeats the idea of getting a full list of components without getting issues with the requisition worksheet.

As long as i set the "Replenishment Method" to "Make-to-Order" it should work without suggesting unwanted replenishments.
Suggested answer

Valentin Castravet 24,785 Super User 2024 Season 2 on at

Like (1)

Report

Prod. BOM calculation

I was going off by what some users posted, but now that I've tested it personally yes I can also confirm components with a quantity of 0 do get copied over. This is regardless of variants, flushing methods, or routing link codes used.

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

Like (1)

Report

Prod. BOM calculation

I tried reading the code to see if there was any condition potentially holding back the BOM Lines with Qty zero from being added to the Prod. Order Component Lines but I didn't find anything specific.

I don't know if there might be any planning setting influencing this, or maybe Routing Link Codes or Flushing Methods....

Jun, did you also tested with Variant Codes like the original posted did? My test was without variant codes.
Jun Wang 7,443 Super User 2024 Season 2 on at

Like (0)

Report

Prod. BOM calculation

That is interesting. In my test, the zero qty item doesn't got copied over. I'm running the same localization and version
MarceloBorges 112 on at

Like (2)

Report

Prod. BOM calculation

I'm not sure how you guys are testing this, but I'm in a Cronus company.

I take Prod. BOM SP-BOM2000, and I add an item with Quantity 0 in it, and I certify it again:

Then I create a new Prod. Order (either Released or Firm Planned) for the item that has Prod. BOM SP-BOM2000 and I refresh the Prod. Order Status... If I check the Prod. Order Line Components, my quantity 0 is still showing there:

Prod. Order Components:

I've tested this on BC SaaS Version: US Business Central 24.3 (Platform 24.0.22422.0 + Application 24.3.21374.21517)
Suggested answer

Valentin Castravet 24,785 Super User 2024 Season 2 on at

Like (0)

Report

Prod. BOM calculation

I would simply customize the Refresh Production Order function to copy over bom lines with a quantity of 0. Its a pretty simple customization, and it should fix your problems.

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

Like (1)

Report

Prod. BOM calculation

Hi,

Thank you very much for your suggestions.

Using a "Prod. Bom Line" with a quantity = 1 as a dummy is fine with one line, but there will be several (more than100) lines, which makes this suggestion unfeasable.

On top of that with a quantity = 1 as a Dummy the user would get too many wrong results when doing any replenishment planning as soon as there is a "Firm Planned Prod. Order".

The idea is to have one Prod. BOM which has all the variants (colors) for this specific item, and in the "Firm Prod. Order" the user can then select which color they actually want to produce, and plan accordingly time, material, replenishment...

I'm using a item with variants, so i cannot activate "Calculate Lines", but i tested the same process also without variants with "Calculate Line activated, with the same outcome. It actually shouldn't influence the results, as the "Calculate Component Need" is activated.

The "Production BOM", two lines have a quantity only for testing purposes, goal is to show all lines in a Prod. Order as components.

"Firm Planned Prod. Order" with item and Variant Code and quantity as a line.

Result after "Refresh Prod. Order" batch was finished.

I would expect all component lines to be shown. After changing the Status = Released Prod. Order and then the user trying to post via the Production Journal, especially the settings for "manual" posting of components doesn't make any sense, when the user simply doesn't have the option to select the items he actually used. But even for other posting setting like "Backward/Forward" the component should show. The Production Journal doesn't create Ledger Entries for lines with zero quantity or time.
Suggested answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (2)

Report

Prod. BOM calculation

I think it can only be customized except for the method Wang mentioned. This cannot be done in the standard.

For Sales and Purchase, there are the following settings.
Maybe you can also submit this idea to Microsoft.

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (2)

Report

Prod. BOM calculation

you could create a production bom with an item of zero quantity and certify it. But when you refresh the production order, BC won't include that item with zero qty. This is normal behavior. To get around this you could put something in the description field and use a default qty with 1. Then user manually update the qty as proper.