How to update quantity in SAP B1 using Bill of Materials management

[Eira84]

Here's the scenario, I want to update the consumption count from 227 to 245, but when I do the update the quantity doesn't change but the cost changes. Can someone help me solve this problem?

[Maya_Shiff]

Dear @Eira84 , 

There is a separate field in the Bill of Materials screen (and also the Production Order) called “Additional Quantity”.  If there is a non-zero “Additional Quantity” this acts as a non-variable consumption quantity that is expected to be consumed irrespective of the parent production quantity. E.g., it may be that when starting up the production process a specific quantity of the component is always consumed.

In your change instruction, you have set 18 (i.e., 245 – 227) into the “Additional Quantity” field.  You can’t see the impact of the update because the field wasn’t visible in the Bill of Materials screen.

However, this most likely is not what you intended to do. You just want to change the “Quantity” field, not the “Additional Quantity” field.  You can change the Quantity in 2 ways:

• The first is to uncheck the “Change Additional Quantity” field and then put the proportional change value into the “No. of Replacement Components per Existing Components”.  This is a batch update routine and therefore can be simultaneously updating many component lines. Therefore only a proportional value can be input in this field as the absolute value of the target quantity can be different for each component line. However, this will only work if the rounding will be clean. In your example, you have 5 decimal places, so the multiple will be 1.07930 * 227 = 245.0011 which will not be acceptable.
• The second option will however work for you. At the top of the BoM Management screen don’t set the Management Task to “Change BOM Lines”. Instead you need to perform 2 tasks “Add BOM Lines” and “Delete BOM Lines”. First run the “Delete BOM Lines” task and set the settings to delete the line containing “4.5X25FB”.  Then run the “Add BOM Lines” task and set the quantity to 245 (also set the warehouse and issue method).  This will provide the intended result.

It should be pointed out that the purpose of the BOM Management screen is for batch updating Bill of Material. If you only want to update one single Bill of Material component line from 227 to 245, then it is much simpler to do this directly in the Bill of Materials screen itself.

I hope you'll find it helpful, 

Regards,

Maya