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
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
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.
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
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.
hi,
create a report (processingonly=yes) to change the BOM Line(s) of all items you want to change the quantity.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156