Fixed Quantities on BOMS

(0) Share

Report

Posted on by mescandon

473

We have a number of parts that we stock in Board Feet and Linear Feet. These items, regardless of how many we make will use the same amount of Packaging materials (plastic bags or cardboard tubes). How can I get NAV to assign a fixed quantity for those components instead of multiplying the "quantity per" by the number of pcs made?

And before anybody says I can change the quantity required on the production order line, I should point out we have way too many items to modify components on individual production orders. It needs to be setup at the BOM level.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

keoma 32,729 on at

Like (0)

Report

hi,

create a report (processingonly=yes) to change the BOM Line(s) of all items you want to change the quantity.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

You can use XML upload or Run a ProcessOnly report to modify the quantity.

If you want to update the quantity based on a equation ( QTY.Per PCS * PCS) then use a process only report.

If you have excel working, then use a XML upload.

Was this reply helpful? Yes No
Suggested answer

Ishan 1,285 on at

Like (0)

Report

Hi mescandon,

When you create a BOM the components entered in BOM lines are per piece quantity only.

I think your case is like some items are consumed in same quantities irrespective of production order quantity.

Then you can consume those quantities using consumption journal against respective production order numbers. In this case you will not enter these items in the BOM. System allows to consume items that are not in the BOM.

Feel free to ask if any more clarification required.

Regards,

Ishan

Was this reply helpful? Yes No
Sigfredo Beerman on at

Like (0)

Report

You can also customized the Calculation Formula in Production BOM Line and add a new one (ie. you can call this Calculation Formula= "Static").

This is what you later will used when calculating expected quantities in components. This is now being done in the OnValidate of Calculation Formula from Prod. Order Component table (T5407). Currently, it shows:

CASE "Calculation Formula" OF

"Calculation Formula"::" ":

Quantity := "Quantity per";

"Calculation Formula"::Length:

Quantity := ROUND(Length * "Quantity per",0.00001);

"Calculation Formula"::"Length * Width":

Quantity := ROUND(Length * Width * "Quantity per",0.00001);

"Calculation Formula"::"Length * Width * Depth":

Quantity := ROUND(Length * Width * Depth * "Quantity per",0.00001);

"Calculation Formula"::Weight:

Quantity := ROUND(Weight * "Quantity per",0.00001);

END;

"Quantity (Base)" := Quantity * "Qty. per Unit of Measure";

VALIDATE("Expected Quantity",Quantity * ProdOrderNeeds);

So, I guess the above should be easy to modify with a new Calculation Formula.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

i did it for several customers in the following way.

Add the component to the Bom with a very small quantity (0.00001 i.e.).

Set the Item Rounding Precision to 1.

Every time you create a production order, the quantity on the production bom line will be rounded to 1.

There are some limitations, because you will exceed a quantity of 1 when you have very large production orders, but this might not be the case for you.

kind regards,

Francis

Was this reply helpful? Yes No