Hello,
We have the following problem in NAV 2018:
After Inventory Adjustment, the actual cost of the output of a finished production order does not correspond to the direct cost of materials and capacity consumed.
Any suggestion would be of great help.
Thank you.
Hi,
We solved the problem by modifying Codeunit 5896:
LOCAL CalcShareOfCapCost(InvtAdjmtEntryOrder : Record "Inventory Adjmt. Entry (Order)") ShareOfCapCost : Decimal
IF InvtAdjmtEntryOrder."Order Type" = InvtAdjmtEntryOrder."Order Type"::Assembly THEN
EXIT(1);
WITH CapLedgEntry DO BEGIN
SETCURRENTKEY("Order Type","Order No.");
SETRANGE("Order Type",InvtAdjmtEntryOrder."Order Type");
SETRANGE("Order No.",InvtAdjmtEntryOrder."Order No.");
SETRANGE("Order Line No.",InvtAdjmtEntryOrder."Order Line No.");
SETRANGE("Routing No.",InvtAdjmtEntryOrder."Routing No.");
SETRANGE("Routing Reference No.",InvtAdjmtEntryOrder."Routing Reference No.");
SETRANGE("Item No.",InvtAdjmtEntryOrder."Item No.");
CALCSUMS("Output Quantity");
ShareOfCapCost := "Output Quantity";
IF InvtAdjmtEntryOrder."Order Type" = InvtAdjmtEntryOrder."Order Type"::Production THEN
-------->OLD: SETRANGE("Order Line No);
-------> NEW: SETRANGE("Order Line No.",InvtAdjmtEntryOrder."Order Line No.");
CALCSUMS("Output Quantity");
IF "Output Quantity" <> 0 THEN
ShareOfCapCost := ShareOfCapCost / "Output Quantity"
ELSE
ShareOfCapCost := 1;
Hi,
i hope that you must have run the "Adjust cost batch job" and after finishing the production order did you check the "update unit cost" boolean.
Hi,
The costing method is "Average" for all the items.
Hi,
Is the "costing method" for the items in the production order set as "STANDARD", if not these type of issues may occur.
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,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156