Codeunit 99000757 Update Prod. Order Cost

Base Application, Microsoft.Manufacturing.Document

src/Layers/W1/BaseApp/Manufacturing/Document/UpdateProdOrderCost.Codeunit.al178 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Manufacturing.Document;using Microsoft.Inventory.Item;using Microsoft.Inventory.Tracking;codeunit 99000757 "Update Prod. Order Cost"{    trigger OnRun()    begin    end;    var        ProdOrderComp: Record "Prod. Order Component";    procedure ModifySourceLineCost(ReservEntry: Record "Reservation Entry"; UnitCost: Decimal)    begin        if UnitCost = 0 then            exit;        if not ReservEntry.Get(ReservEntry."Entry No.", not ReservEntry.Positive) then            exit;        ReservEntry.UpdateSourceCost(UnitCost);    end;    local procedure SumTrackingCosts(var ReservEntry: Record "Reservation Entry"; var TotalUnitCost: Decimal; var TotalCostQty: Decimal; Item: Record Item)    begin        TotalUnitCost := 0;        TotalCostQty := 0;        repeat            ProdOrderComp.Get(              ReservEntry."Source Subtype", ReservEntry."Source ID", ReservEntry."Source Prod. Order Line", ReservEntry."Source Ref. No.");            if ProdOrderComp."Qty. per Unit of Measure" <> 0 then                TotalUnitCost += Item."Unit Cost" * ReservEntry.Quantity;            TotalCostQty += ReservEntry.Quantity;        until ReservEntry.Next() = 0;    end;    procedure UpdateUnitCostOnProdOrder(var ProdOrderLine: Record "Prod. Order Line"; MultipleLevels: Boolean; UpdateReservation: Boolean)    var        Item: Record Item;        ProdOrderComp: Record "Prod. Order Component";        ReservEntry: Record "Reservation Entry";        TotalCostQty: Decimal;        TotalUnitCost: Decimal;        TotalFinishedQty: Decimal;        UnitCost: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdateUnitCostOnProdOrder(ProdOrderLine, MultipleLevels, UpdateReservation, IsHandled);        if IsHandled then            exit;        if not Item.Get(ProdOrderLine."Item No.") then            exit;        if Item."Costing Method".AsInteger() > Item."Costing Method"::Average.AsInteger() then            exit;        ProdOrderComp.SetRange(Status, ProdOrderLine.Status);        ProdOrderComp.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No.");        ProdOrderComp.SetRange("Prod. Order Line No.", ProdOrderLine."Line No.");        if ProdOrderComp.Find('-') then            repeat                TotalCostQty := 0;                TotalUnitCost := 0;                Item.Get(ProdOrderComp."Item No.");                OnUpdateUnitCostOnProdOrderOnAfterGetProdOrderCompItem(ProdOrderLine, ProdOrderComp, Item);                if Item."Costing Method".AsInteger() <= Item."Costing Method"::Average.AsInteger() then begin                    ReservEntry."Source Type" := Database::"Prod. Order Component";                    ReservEntry.InitSortingAndFilters(true);                    ProdOrderComp.SetReservationFilters(ReservEntry);                    if ReservEntry.Find('-') then                        SumTrackingCosts(ReservEntry, TotalUnitCost, TotalCostQty, Item);                    ProdOrderComp.CalcFields("Reserved Qty. (Base)");                    UpdateTotalUnitCostOnProdOrder(ProdOrderComp, Item, TotalUnitCost);                    TotalCostQty :=                      TotalCostQty +                      (ProdOrderComp."Expected Qty. (Base)" - ProdOrderComp."Reserved Qty. (Base)");                    if TotalCostQty <> 0 then begin                        UnitCost := TotalUnitCost / TotalCostQty * ProdOrderComp."Qty. per Unit of Measure";                        if ProdOrderComp."Unit Cost" <> UnitCost then begin                            ProdOrderComp.Validate("Unit Cost", UnitCost);                            ProdOrderComp.Modify();                        end;                    end;                end;            until ProdOrderComp.Next() = 0;        ProdOrderLine.CalcFields(          "Expected Operation Cost Amt.",          "Total Exp. Oper. Output (Qty.)",          "Expected Component Cost Amt.");        if ProdOrderLine."Total Exp. Oper. Output (Qty.)" <> 0 then            ProdOrderLine."Expected Operation Cost Amt." :=              Round(                ProdOrderLine."Expected Operation Cost Amt." /                ProdOrderLine."Total Exp. Oper. Output (Qty.)" *                ProdOrderLine.Quantity);        OnUpdateUnitCostOnProdOrderOnBeforeValidateUnitCost(ProdOrderLine);        TotalFinishedQty := ProdOrderLine.Quantity;        if ProdOrderLine."Finished Quantity" <> 0 then            TotalFinishedQty := ProdOrderLine."Finished Quantity";        ProdOrderLine.Validate(          "Unit Cost",          (ProdOrderLine."Expected Operation Cost Amt." + ProdOrderLine."Expected Component Cost Amt.") / TotalFinishedQty);        OnUpdateUnitCostOnProdOrderOnAfterValidateUnitCost(ProdOrderLine);        ProdOrderLine.Modify();        if UpdateReservation then begin            ReservEntry.Reset();            ReservEntry."Source Type" := Database::"Prod. Order Line";            ReservEntry.InitSortingAndFilters(false);            ProdOrderLine.SetReservationFilters(ReservEntry);            if ProdOrderLine."Qty. per Unit of Measure" <> 0 then                UnitCost := Round(ProdOrderLine."Unit Cost" / ProdOrderLine."Qty. per Unit of Measure", 0.00001)            else                UnitCost := ProdOrderLine."Unit Cost";            if ReservEntry.Find('-') then                repeat                    ModifySourceLineCost(ReservEntry, UnitCost);                until ReservEntry.Next() = 0;        end;    end;    local procedure UpdateTotalUnitCostOnProdOrder(var ProdOrderComp: Record "Prod. Order Component"; Item: Record Item; var TotalUnitCost: Decimal)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdateTotalUnitCostOnProdOrder(ProdOrderComp, TotalUnitCost, IsHandled);        if IsHandled then            exit;        TotalUnitCost :=            TotalUnitCost +            (Item."Unit Cost" *            (ProdOrderComp."Expected Qty. (Base)" - ProdOrderComp."Reserved Qty. (Base)"));    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateUnitCostOnProdOrder(var ProdOrderLine: Record "Prod. Order Line"; MultipleLevels: Boolean; UpdateReservation: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateTotalUnitCostOnProdOrder(var ProdOrderComp: Record "Prod. Order Component"; var TotalUnitCost: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateUnitCostOnProdOrderOnAfterValidateUnitCost(var ProdOrderLine: Record "Prod. Order Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateUnitCostOnProdOrderOnAfterGetProdOrderCompItem(ProdOrderLine: Record "Prod. Order Line"; ProdOrderComp: Record "Prod. Order Component"; var Item: Record Item)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateUnitCostOnProdOrderOnBeforeValidateUnitCost(var ProdOrderLine: Record "Prod. Order Line")    begin    end;}