Business Central 2022 wave 1 (BC20) new features: Fixed Quantity in production bill of materials (Production BOM)

Dynamics 365 Business Central

Hi, Readers.
The preview environment for Dynamics 365 Business Central 2022 release wave 1 (BC20) is available. Learn more: Link

I will continue to test and share some new features that I hope will be helpful.

Fixed Quantity in product bills of materials:

Business value:

You can ensure that the consumption of a component is the same, regardless of the scrap or output quantities.

Feature details:

You can select the Fixed Quantity option in the Calculation Formula field on production BOM lines, planning components, and production order components to ensure that the consumption of a component is the same.

This is a small update for manufacturing.

A production bill of material (BOM) holds master data that describes the components and subassemblies used in the production of a parent item. Once a production order is created for that parent item, its production BOM will govern the calculation of material requirements as represented on the Prod. Order Components page.

The quantity is calculated taking into consideration different dimensions which are also entered on the production BOM lines. The dimensions refer to an order unit of the respective item. The length, width, depth and weight can be entered as dimensions.

The Calculation Formula, Length, Width, Depth and Weight columns are not displayed, because they are only used by some users. If you wish to use the calculation of the quantity, you must first display these columns.

Now, you can select the Fixed Quantity option in the Calculation Formula field.

PS: in BC19.5

So you can choose from the following values in the Calculation Formula field now:

  • Blank: The quantity is not calculated.
  • Length: Quantity = Length * Quantity per
  • Length * Width: Quantity = Length * Width * Quantity per
  • Length * Width * Depth: Quantity = Length * Width * Height * Quantity per
  • Weight: Quantity = Weight * Quantity per
  • Fixed Quantity = Quantity Per

Let’s see more details.
First, I created a test Production Bom using six different Calculation Formulas. Other conditions are the same.
Quantity Per: 100
Scrap%: 10
Length: 10
Weight: 20
Width: 30
Depth: 40

TypeNo.DescriptionQuantity perUnit of Measure CodeScrap %Calculation FormulaLengthWeightWidthDepth
ItemLSU-15Base speaker unit 15″ 100W100PCS1010203040
ItemLSU-4Tweeter speaker unit 4″ 100W100PCS10Length10203040
ItemLSU-8Middletone speaker unit 8″100W100PCS10Length * Width10203040
ItemSPK-100Spike for LS-100100PCS10Length * Width * Depth10203040
ItemLS-81Loudspeaker, Walnut, 80W100PCS10Weight10203040
ItemLS-2Cables for Loudspeakers100BOX10Fixed Quantity10203040

Assign the test bom to item 2000-S.

Then create a new Production Order and change status to Released.

Open Consumption Journals page.

Choose Calc. Consumption…

Select the released production order number.

The calculation result of material requirements is as follows.

Posting DateOrder No.Order Line No.Prod. Order Comp. Line No.Document No.Item No.DescriptionQuantityUnit of Measure Code
3/24/2022RPO00000021000010000RPO0000002LSU-15Base speaker unit 15″ 100W110PCS
3/24/2022RPO00000021000020000RPO0000002LSU-4Tweeter speaker unit 4″ 100W1,100PCS
3/24/2022RPO00000021000030000RPO0000002LSU-8Middletone speaker unit 8″100W33,000PCS
3/24/2022RPO00000021000040000RPO0000002SPK-100Spike for LS-1001,320,000PCS
3/24/2022RPO00000021000050000RPO0000002LS-81Loudspeaker, Walnut, 80W2,200PCS
3/24/2022RPO00000021000060000RPO0000002LS-2Cables for Loudspeakers100BOX

In production order components, when the Calculation Formula field is set to Fixed Quantity, the Expected Quantity field value is always equal to the Quantity Per field. The scrap % that is defined on the same line is ignored. Fixed quantity is respected by the Availability by BOM report that will show the item as the bottleneck if the available quantity is less than the quantity in the Quantity Per Parent field. The Able to Make Parent and Able to Make Top Item fields always have blank values regardless of the available quantity. Fixed quantity is respected by the Standard Cost Calculation process. Lot size for the produced item impacts the cost allocated for one item.

Fixed Quantity in product bills of materials – Dynamics 365 Release Plan | Microsoft Docs


Hope this will help.

Thanks for reading.



Copied title and URL