I have searched, cannot find the answer, and need help.
We use backflushing for packaging materials using a routing link code. The BOM is set up to consume 1 box for every 1,500 pounds output of item A. So the components are 1 Qty per item A and 0.00067 boxes per. The problem we are having is that the majority of the time, they post over 1,500 pounds of item A. NAV then backflushes 2 boxes for every lot number output of item A. How do I force NAV to round to the nearest instead of always rounding up?? I have tried changing the code on table 5407 so that the GetNeededQty section no longer defines the direction to round, but that didn’t change the problem:
IF IncludePreviousPosting THEN BEGIN
IF Status IN [Status::Released,Status::Finished] THEN
CALCFIELDS(“Act. Consumption (Qty)”);
((CompQtyBase - “Act. Consumption (Qty)”) / “Qty. per Unit of Measure”),
Item.“Rounding Precision”)) // removed the sign
EXIT(ROUND(CompQtyBase / “Qty. per Unit of Measure”,Item.“Rounding Precision”)); // removed the sign
EXIT(ROUND(“Remaining Quantity”,Item.“Rounding Precision”));
What else can I do?? I am not a develpoer, but do have some idea how to navigate through the code.
The rounding precision on the box item card is set to 1.
We are using NAV 6.0 SP1
Any help would be greatly appreciated! Thanks.