Codeunit 6212 Sustainability Post Mgt

Sustainability, Microsoft.Sustainability.Posting

src/Apps/W1/Sustainability/app/src/Posting/SustainabilityPostMgt.Codeunit.al628 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Posting;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.FixedAssets.Ledger;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Manufacturing.Capacity;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Resources.Ledger;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Emission;using Microsoft.Sustainability.Journal;using Microsoft.Sustainability.Ledger;using System.Telemetry;codeunit 6212 "Sustainability Post Mgt"{    Permissions =        tabledata "Sustainability Ledger Entry" = i,        tabledata "Sustainability Value Entry" = i,        tabledata "Sust. G/L - Sust. Ledger Rel." = ri,        tabledata "Sust. Jnl. Line G/L Entry" = r;    procedure InsertLedgerEntry(SustainabilityJnlLine: Record "Sustainability Jnl. Line")    var        SustainabilityLedgerEntry: Record "Sustainability Ledger Entry";        FeatureTelemetry: Codeunit "Feature Telemetry";        IsHandled: Boolean;        SustainabilityLedgerEntryAddedLbl: Label 'Sustainability Ledger Entry Added', Locked = true;    begin        SustainabilityLedgerEntry.Init();        FeatureTelemetry.LogUsage('0000PH5', SustainabilityLbl, SustainabilityLedgerEntryAddedLbl);        FeatureTelemetry.LogUptake('0000PH3', SustainabilityLbl, Enum::"Feature Uptake Status"::"Used");        // AutoIncrement requires the PK to be empty        SustainabilityLedgerEntry."Entry No." := 0;        SustainabilityLedgerEntry."Account Name" := SustainabilityJnlLine."Account Name";        SustainabilityLedgerEntry.TransferFields(SustainabilityJnlLine);        CopyDataFromAccountCategory(SustainabilityLedgerEntry, SustainabilityJnlLine."Account Category");        CopyDateFromAccountSubCategory(SustainabilityLedgerEntry, SustainabilityJnlLine."Account Category", SustainabilityJnlLine."Account Subcategory");        SustainabilityLedgerEntry.Validate("User ID", CopyStr(UserId(), 1, 50));        SustainabilityLedgerEntry."G/L Entry No." := GLEntryNo;        UpdateCarbonFeeEmission(SustainabilityLedgerEntry);        OnBeforeInsertSustainabilityLedgerEntry(SustainabilityLedgerEntry, SustainabilityJnlLine);        IsHandled := false;        OnInsertLedgerEntryOnBeforeInsert(SustainabilityLedgerEntry, IsHandled);        if not IsHandled then begin            SustainabilityLedgerEntry.Insert(true);            CreateGLEntryRelations(SustainabilityJnlLine, SustainabilityLedgerEntry."Entry No.");        end;    end;    local procedure CreateGLEntryRelations(SustainabilityJnlLine: Record "Sustainability Jnl. Line"; SustLedgerEntryNo: Integer)    var        GLEntry: Record "G/L Entry";        SustGLSustLedgerRel: Record "Sust. G/L - Sust. Ledger Rel.";        SustJnlLineGLEntry: Record "Sust. Jnl. Line G/L Entry";    begin        if not SustainabilityJnlLine."Collected from G/L Entries" then            exit;        SustJnlLineGLEntry.SetJournalLineFilter(SustainabilityJnlLine);        if not SustJnlLineGLEntry.FindSet() then            exit;        repeat            if GLEntry.Get(SustJnlLineGLEntry."G/L Entry No.") then                SustGLSustLedgerRel.CreateRelation(GLEntry, SustLedgerEntryNo, SustJnlLineGLEntry."Account Category");        until SustJnlLineGLEntry.Next() = 0;    end;    procedure InsertValueEntry(SustainabilityJnlLine: Record "Sustainability Jnl. Line"; ValueEntry: Record "Value Entry"; ItemLedgerEntry: Record "Item Ledger Entry")    var        SustainabilityValueEntry: Record "Sustainability Value Entry";        FeatureTelemetry: Codeunit "Feature Telemetry";        ShouldCalcExpectedCO2e: Boolean;    begin        SkipUpdateCarbonEmissionValue :=            (ValueEntry."Item Ledger Entry Type" <> ValueEntry."Item Ledger Entry Type"::Purchase) or            ((ValueEntry."Item Ledger Entry Type" = ValueEntry."Item Ledger Entry Type"::Purchase) and (ValueEntry."Item Charge No." <> '')) or            ((ValueEntry."Item Ledger Entry Type" = ValueEntry."Item Ledger Entry Type"::Purchase) and (ValueEntry."Document Type" = ValueEntry."Document Type"::" "));        SustainabilityValueEntry.Init();        FeatureTelemetry.LogUsage('0000PH6', SustainabilityLbl, SustainabilityValueEntryAddedLbl);        FeatureTelemetry.LogUptake('0000PH4', SustainabilityLbl, Enum::"Feature Uptake Status"::"Used");        SustainabilityValueEntry."Entry No." := SustainabilityValueEntry.GetLastEntryNo() + 1;        SustainabilityValueEntry.CopyFromValueEntry(ValueEntry);        SustainabilityValueEntry.CopyFromSustainabilityJnlLine(SustainabilityJnlLine);        if SustainabilityValueEntry."Item Ledger Entry Type" = SustainabilityValueEntry."Item Ledger Entry Type"::Transfer then            SustainabilityValueEntry."Valued Quantity" := Abs(SustainabilityValueEntry."Valued Quantity");        if (ValueEntry."Order Type" = ValueEntry."Order Type"::Production) and           (ValueEntry."Item Ledger Entry Type" in [ValueEntry."Item Ledger Entry Type"::Output, ValueEntry."Item Ledger Entry Type"::" "])        then begin            SkipUpdateCarbonEmissionValue := true;            SustainabilityValueEntry."Expected Emission" := false;        end;        SustainabilityValueEntry.Validate("User ID", CopyStr(UserId(), 1, 50));        UpdateCarbonFeeEmissionForValueEntry(SustainabilityValueEntry, SustainabilityJnlLine);        ShouldCalcExpectedCO2e :=            ((SustainabilityValueEntry."Entry Type" = SustainabilityValueEntry."Entry Type"::"Direct Cost") and            ((SustainabilityValueEntry."Item Ledger Entry Quantity" = 0) and (SustainabilityValueEntry."Invoiced Quantity" <> 0)) and            (SustainabilityValueEntry."Item Ledger Entry No." <> 0));        if ShouldCalcExpectedCO2e then            CalcExpectedCO2e(                SustainabilityValueEntry."Item Ledger Entry No.",                SustainabilityValueEntry."Invoiced Quantity",                ItemLedgerEntry.Quantity,                SustainabilityValueEntry."CO2e Amount (Expected)",                ItemLedgerEntry.Quantity = ItemLedgerEntry."Invoiced Quantity");        if (SustainabilityJnlLine.Correction) and (not SustainabilityValueEntry."Expected Emission") then            SustainabilityValueEntry.Validate("CO2e Amount (Actual)", -SustainabilityValueEntry."CO2e Amount (Expected)");        SustainabilityValueEntry.Insert(true);        UpdateCO2ePerUnit(SustainabilityValueEntry);    end;    procedure InsertValueEntry(SustainabilityJnlLine: Record "Sustainability Jnl. Line"; JobLedgerEntry: Record "Job Ledger Entry")    var        SustainabilityValueEntry: Record "Sustainability Value Entry";        FeatureTelemetry: Codeunit "Feature Telemetry";    begin        SustainabilityValueEntry.Init();        FeatureTelemetry.LogUsage('0000PKW', SustainabilityLbl, SustainabilityValueEntryAddedLbl);        FeatureTelemetry.LogUptake('0000PKV', SustainabilityLbl, Enum::"Feature Uptake Status"::"Used");        SustainabilityValueEntry."Entry No." := SustainabilityValueEntry.GetLastEntryNo() + 1;        SustainabilityValueEntry.CopyFromJobLedgerEntry(JobLedgerEntry);        SustainabilityValueEntry.CopyFromSustainabilityJnlLine(SustainabilityJnlLine);        SustainabilityValueEntry.Validate("User ID", CopyStr(UserId(), 1, 50));        SkipUpdateCarbonEmissionValue := true;        UpdateCarbonFeeEmissionForValueEntry(SustainabilityValueEntry, SustainabilityJnlLine);        SustainabilityValueEntry.Insert(true);        UpdateCO2ePerUnit(SustainabilityValueEntry);    end;    procedure InsertValueEntry(SustainabilityJnlLine: Record "Sustainability Jnl. Line"; ResourceLedgerEntry: Record "Res. Ledger Entry")    var        SustainabilityValueEntry: Record "Sustainability Value Entry";        FeatureTelemetry: Codeunit "Feature Telemetry";    begin        SustainabilityValueEntry.Init();        FeatureTelemetry.LogUsage('0000QOZ', SustainabilityLbl, SustainabilityValueEntryAddedLbl);        FeatureTelemetry.LogUptake('0000QOY', SustainabilityLbl, Enum::"Feature Uptake Status"::"Used");        SustainabilityValueEntry."Entry No." := SustainabilityValueEntry.GetLastEntryNo() + 1;        SustainabilityValueEntry.CopyFromResourceLedgerEntry(ResourceLedgerEntry);        SustainabilityValueEntry.CopyFromSustainabilityJnlLine(SustainabilityJnlLine);        SustainabilityValueEntry.Validate("User ID", CopyStr(UserId(), 1, 50));        SkipUpdateCarbonEmissionValue := true;        UpdateCarbonFeeEmissionForValueEntry(SustainabilityValueEntry, SustainabilityJnlLine);        SustainabilityValueEntry.Insert(true);        UpdateCO2ePerUnit(SustainabilityValueEntry);    end;    procedure InsertValueEntry(SustainabilityJnlLine: Record "Sustainability Jnl. Line"; FALedgerEntry: Record "FA Ledger Entry")    var        SustainabilityValueEntry: Record "Sustainability Value Entry";        FeatureTelemetry: Codeunit "Feature Telemetry";    begin        SustainabilityValueEntry.Init();        FeatureTelemetry.LogUsage('0000QRO', SustainabilityLbl, SustainabilityValueEntryAddedLbl);        FeatureTelemetry.LogUptake('0000QRN', SustainabilityLbl, Enum::"Feature Uptake Status"::"Used");        SustainabilityValueEntry."Entry No." := SustainabilityValueEntry.GetLastEntryNo() + 1;        SustainabilityValueEntry.CopyFromFALedgerEntry(FALedgerEntry);        SustainabilityValueEntry.CopyFromSustainabilityJnlLine(SustainabilityJnlLine);        SustainabilityValueEntry.Validate("User ID", CopyStr(UserId(), 1, 50));        SkipUpdateCarbonEmissionValue := true;        UpdateCarbonFeeEmissionForValueEntry(SustainabilityValueEntry, SustainabilityJnlLine);        SustainabilityValueEntry.Insert(true);        UpdateCO2ePerUnit(SustainabilityValueEntry);    end;    procedure UpdateCO2ePerUnit(SustValueEntry: Record "Sustainability Value Entry")    var        Item: Record Item;        SustCostMgt: Codeunit SustCostManagement;    begin        if (SustValueEntry."Valued Quantity" > 0) and not (SustValueEntry."Expected Emission") then begin            if not Item.Get(SustValueEntry."Item No.") then                exit;            SustCostMgt.UpdateCO2ePerUnit(Item, 0);        end;    end;    procedure ResetFilters(var SustainabilityJnlLine: Record "Sustainability Jnl. Line")    begin        SustainabilityJnlLine.Reset();        SustainabilityJnlLine.FilterGroup(2);        SustainabilityJnlLine.SetRange("Journal Template Name", SustainabilityJnlLine."Journal Template Name");        SustainabilityJnlLine.SetRange("Journal Batch Name", SustainabilityJnlLine."Journal Batch Name");        SustainabilityJnlLine.FilterGroup(0);    end;    procedure UpdateCarbonFeeEmission(var SustainabilityLedgerEntry: Record "Sustainability Ledger Entry")    var        AccountCategory: Record "Sustain. Account Category";        ScopeType: Enum "Emission Scope";    begin        if SkipUpdateCarbonEmissionValue then            exit;        if AccountCategory.Get(SustainabilityLedgerEntry."Account Category") then            ScopeType := AccountCategory."Emission Scope";        UpdateCarbonFeeEmissionValues(            ScopeType, SustainabilityLedgerEntry."Posting Date", SustainabilityLedgerEntry."Country/Region Code", SustainabilityLedgerEntry."Emission CO2",            SustainabilityLedgerEntry."Emission N2O", SustainabilityLedgerEntry."Emission CH4", SustainabilityLedgerEntry."CO2e Emission", SustainabilityLedgerEntry."Carbon Fee");    end;    procedure UpdateCarbonFeeEmissionForValueEntry(var SustainabilityValueEntry: Record "Sustainability Value Entry"; SustainabilityJnlLine: Record "Sustainability Jnl. Line")    var        AccountCategory: Record "Sustain. Account Category";        ScopeType: Enum "Emission Scope";        CO2eEmission: Decimal;        CarbonFee: Decimal;    begin        if AccountCategory.Get(SustainabilityJnlLine."Account Category") then            ScopeType := AccountCategory."Emission Scope";        if not SkipUpdateCarbonEmissionValue then            UpdateCarbonFeeEmissionValues(                ScopeType, SustainabilityJnlLine."Posting Date", SustainabilityJnlLine."Country/Region Code", SustainabilityJnlLine."Emission CO2",                SustainabilityJnlLine."Emission N2O", SustainabilityJnlLine."Emission CH4", CO2eEmission, CarbonFee)        else            CO2eEmission := SustainabilityJnlLine."CO2e Emission";        if SustainabilityValueEntry."Expected Emission" then            SustainabilityValueEntry."CO2e Amount (Expected)" := CO2eEmission        else            SustainabilityValueEntry."CO2e Amount (Actual)" := CO2eEmission;        SustainabilityValueEntry."CO2e per Unit" := CalcCO2ePerUnit(CO2eEmission, SustainabilityValueEntry."Valued Quantity");    end;    procedure UpdateCarbonFeeEmissionValues(       ScopeType: Enum "Emission Scope";       PostingDate: Date;       CountryRegionCode: Code[10];       EmissionCO2: Decimal;       EmissionN2O: Decimal;       EmissionCH4: Decimal;       var CO2eEmission: Decimal;       var CarbonFee: Decimal): Decimal    var        EmissionFee: Record "Emission Fee";        CO2Factor: Decimal;        N2OFactor: Decimal;        CH4Factor: Decimal;        EmissionCarbonFee: Decimal;    begin        EmissionFee.SetFilter("Scope Type", '%1|%2', ScopeType, ScopeType::" ");        EmissionFee.SetFilter("Starting Date", '<=%1|%2', PostingDate, 0D);        EmissionFee.SetFilter("Ending Date", '>=%1|%2', PostingDate, 0D);        EmissionFee.SetFilter("Country/Region Code", '%1|%2', CountryRegionCode, '');        if EmissionCO2 <> 0 then            if FindEmissionFeeForEmissionType(EmissionFee, Enum::"Emission Type"::CO2) then begin                CO2Factor := EmissionFee."Carbon Equivalent Factor";                EmissionCarbonFee := EmissionFee."Carbon Fee";            end;        if EmissionN2O <> 0 then            if FindEmissionFeeForEmissionType(EmissionFee, Enum::"Emission Type"::N2O) then begin                N2OFactor := EmissionFee."Carbon Equivalent Factor";                EmissionCarbonFee += EmissionFee."Carbon Fee";            end;        if EmissionCH4 <> 0 then            if FindEmissionFeeForEmissionType(EmissionFee, Enum::"Emission Type"::CH4) then begin                CH4Factor := EmissionFee."Carbon Equivalent Factor";                EmissionCarbonFee += EmissionFee."Carbon Fee";            end;        CO2eEmission := (EmissionCO2 * CO2Factor) + (EmissionN2O * N2OFactor) + (EmissionCH4 * CH4Factor);        CarbonFee := CO2eEmission * EmissionCarbonFee;    end;    procedure GetTotalCO2eAmount(ItemLedgerEntry: Record "Item Ledger Entry"; ValueEntryType: Enum "Capacity Type Journal"; var TotalCO2e: Decimal; CO2ePerUnit: Decimal)    var        TempItemLedgerEntry: Record "Item Ledger Entry" temporary;        ShowAppliedEntries: Codeunit "Show Applied Entries";        AppliedAmount: Decimal;        AppliedQuantity: Decimal;        IsNegativeEntry: Boolean;    begin        if not IsCarbonTrackingSpecificItem(ItemLedgerEntry."Item No.") then            exit;        if TotalCO2e < 0 then            IsNegativeEntry := true;        ShowAppliedEntries.FindAppliedEntries(ItemLedgerEntry, TempItemLedgerEntry);        if TempItemLedgerEntry.IsEmpty() then            GetILEForAssemblyOutputs(ItemLedgerEntry, TempItemLedgerEntry);        if TempItemLedgerEntry.FindSet() then            repeat                GetCO2eAmountAndQuantity(TempItemLedgerEntry."Entry No.", AppliedAmount, AppliedQuantity);            until TempItemLedgerEntry.Next() = 0;        if ItemLedgerEntry."Entry Type" = ItemLedgerEntry."Entry Type"::Transfer then begin            if AppliedQuantity <> 0 then                TotalCO2e := Abs((AppliedAmount / AppliedQuantity) * ItemLedgerEntry.Quantity)            else                TotalCO2e := Abs(CO2ePerUnit * ItemLedgerEntry.Quantity);            CorrectSign(TotalCO2e, IsNegativeEntry);            exit;        end;        if AppliedAmount = 0 then            exit;        if ItemLedgerEntry."Entry Type" in [ItemLedgerEntry."Entry Type"::"Assembly Output", ItemLedgerEntry."Entry Type"::"Output"] then begin            CalculateForProductionOutput(TotalCO2e, AppliedAmount, ValueEntryType);            CorrectSign(TotalCO2e, IsNegativeEntry);            exit;        end;        if AppliedQuantity <> 0 then begin            TotalCO2e := Abs((AppliedAmount / AppliedQuantity) * ItemLedgerEntry.Quantity);            CorrectSign(TotalCO2e, IsNegativeEntry);        end;    end;    local procedure CalculateForProductionOutput(var TotalCO2e: Decimal; AppliedAmount: Decimal; ValueEntryType: Enum "Capacity Type Journal")    begin        if ValueEntryType in [ValueEntryType::"Machine Center", ValueEntryType::"Work Center"] then begin            TotalCO2e += Abs(AppliedAmount);            exit;        end;        TotalCO2e := Abs(AppliedAmount);    end;    procedure GetCO2eAmountAndQuantity(ItemLedgerEntryNo: Integer; var CO2eAmount: Decimal; var CO2eQuantity: Decimal)    var        SustainabilityValueEntry: Record "Sustainability Value Entry";    begin        SustainabilityValueEntry.SetLoadFields("Item Ledger Entry No.", "CO2e Amount (Actual)", "Item Ledger Entry Quantity");        SustainabilityValueEntry.SetRange("Item Ledger Entry No.", ItemLedgerEntryNo);        if SustainabilityValueEntry.IsEmpty() then begin            ResolveTransferInCO2e(ItemLedgerEntryNo, CO2eAmount, CO2eQuantity);            exit;        end;        SustainabilityValueEntry.CalcSums("CO2e Amount (Actual)", "Item Ledger Entry Quantity");        CO2eAmount += SustainabilityValueEntry."CO2e Amount (Actual)";        CO2eQuantity += SustainabilityValueEntry."Item Ledger Entry Quantity";    end;    local procedure ResolveTransferInCO2e(ItemLedgerEntryNo: Integer; var CO2eAmount: Decimal; var CO2eQuantity: Decimal)    var        TransferInILE: Record "Item Ledger Entry";        TransferOutILE: Record "Item Ledger Entry";        TempItemLedgerEntry: Record "Item Ledger Entry" temporary;        SustainabilityValueEntry: Record "Sustainability Value Entry";        ShowAppliedEntries: Codeunit "Show Applied Entries";    begin        TransferInILE.SetLoadFields("Entry No.", "Entry Type", Quantity, "Order No.", "Order Line No.", "Item Register No.", "Item No.", "Lot No.", "Serial No.");        if not TransferInILE.Get(ItemLedgerEntryNo) then            exit;        if TransferInILE."Entry Type" <> TransferInILE."Entry Type"::Transfer then            exit;        if TransferInILE.Quantity < 0 then begin            ShowAppliedEntries.FindAppliedEntries(TransferInILE, TempItemLedgerEntry);            if TempItemLedgerEntry.FindSet() then                repeat                    if (TempItemLedgerEntry."Lot No." = TransferInILE."Lot No.") and                       (TempItemLedgerEntry."Serial No." = TransferInILE."Serial No.")                    then                        GetCO2eAmountAndQuantity(TempItemLedgerEntry."Entry No.", CO2eAmount, CO2eQuantity);                until TempItemLedgerEntry.Next() = 0;            exit;        end;        if TransferInILE."Order No." <> '' then begin            TransferOutILE.SetRange("Order No.", TransferInILE."Order No.");            TransferOutILE.SetRange("Order Line No.", TransferInILE."Order Line No.");            TransferOutILE.SetRange("Item No.", TransferInILE."Item No.");            TransferOutILE.SetRange("Entry Type", TransferOutILE."Entry Type"::Transfer);            TransferOutILE.SetFilter(Quantity, '<%1', 0);            TransferOutILE.SetFilter("Entry No.", '<%1', TransferInILE."Entry No.");            TransferOutILE.SetRange("Lot No.", TransferInILE."Lot No.");            TransferOutILE.SetRange("Serial No.", TransferInILE."Serial No.");            if TransferOutILE.FindLast() then begin                GetCO2eAmountAndQuantity(TransferOutILE."Entry No.", CO2eAmount, CO2eQuantity);                exit;            end;        end;        // Reclassification transfer-in ILEs lack SVEs; resolve from the transfer-out counterpart.        TransferOutILE.SetRange("Item Register No.", TransferInILE."Item Register No.");        TransferOutILE.SetRange("Item No.", TransferInILE."Item No.");        TransferOutILE.SetRange("Entry Type", TransferOutILE."Entry Type"::Transfer);        TransferOutILE.SetFilter(Quantity, '<%1', 0);        TransferOutILE.SetRange("Lot No.", TransferInILE."Lot No.");        TransferOutILE.SetRange("Serial No.", TransferInILE."Serial No.");        if not TransferOutILE.FindFirst() then            exit;        SustainabilityValueEntry.SetLoadFields("Item Ledger Entry No.", "CO2e Amount (Actual)", "Item Ledger Entry Quantity");        SustainabilityValueEntry.SetRange("Item Ledger Entry No.", TransferOutILE."Entry No.");        SustainabilityValueEntry.CalcSums("CO2e Amount (Actual)", "Item Ledger Entry Quantity");        CO2eAmount += SustainabilityValueEntry."CO2e Amount (Actual)";        CO2eQuantity += Abs(SustainabilityValueEntry."Item Ledger Entry Quantity");    end;    procedure GetTotalCO2eAmountFromValueEntry(        ItemLedgerEntryDocumentType: Enum "Item Ledger Document Type";        DocumentNo: Code[20];        DocumentLineNo: Integer;        ItemNo: Code[20];        var TotalCO2eAmount: Decimal;        var TotalCO2eQuantity: Decimal)    var        ValueEntry: Record "Value Entry";    begin        ValueEntry.SetLoadFields("Document Type", "Document No.", "Document Line No.", "Item No.", "Item Ledger Entry No.");        ValueEntry.SetRange("Document Type", ItemLedgerEntryDocumentType);        ValueEntry.SetRange("Document No.", DocumentNo);        ValueEntry.SetRange("Document Line No.", DocumentLineNo);        ValueEntry.SetRange("Item No.", ItemNo);        if ValueEntry.FindSet() then            repeat                GetCO2eAmountAndQuantity(ValueEntry."Item Ledger Entry No.", TotalCO2eAmount, TotalCO2eQuantity);            until ValueEntry.Next() = 0;    end;    procedure IsCarbonTrackingSpecificItem(ItemNo: Code[20]): Boolean    var        Item: Record Item;    begin        Item.SetLoadFields("Carbon Tracking Method");        if not Item.Get(ItemNo) then            exit;        if Item."Carbon Tracking Method" <> Item."Carbon Tracking Method"::Specific then            exit;        exit(true);    end;    local procedure CorrectSign(var Value: Decimal; IsNegativeEntry: Boolean)    begin        if IsNegativeEntry then            Value := -Value;    end;    local procedure GetILEForAssemblyOutputs(ItemLedgerEntry: Record "Item Ledger Entry"; var TempItemLedgerEntry: Record "Item Ledger Entry" temporary)    var        ItemLedgerEntry2: Record "Item Ledger Entry";    begin        if ItemLedgerEntry."Item Register No." = 0 then            exit;        if not (ItemLedgerEntry."Entry Type" in [ItemLedgerEntry."Entry Type"::"Assembly Output", ItemLedgerEntry."Entry Type"::"Output"]) then            exit;        ItemLedgerEntry2.SetRange("Item Register No.", ItemLedgerEntry."Item Register No.");        ItemLedgerEntry2.SetRange("Entry Type", GetConsumptionEntryType(ItemLedgerEntry."Entry Type"));        if ItemLedgerEntry2.FindSet() then            repeat                TempItemLedgerEntry := ItemLedgerEntry2;                TempItemLedgerEntry.Insert();            until ItemLedgerEntry2.Next() = 0;    end;    local procedure GetConsumptionEntryType(ItemLedgerEntryType: Enum "Item Ledger Entry Type"): Enum "Item Ledger Entry Type"    begin        case ItemLedgerEntryType of            ItemLedgerEntryType::"Assembly Output":                exit(ItemLedgerEntryType::"Assembly Consumption");            ItemLedgerEntryType::Output:                exit(ItemLedgerEntryType::Consumption);        end;    end;    local procedure FindEmissionFeeForEmissionType(var EmissionFee: Record "Emission Fee"; EmissionType: Enum "Emission Type"): Boolean    begin        EmissionFee.SetRange("Emission Type", EmissionType);        if EmissionFee.FindLast() then            exit(true);    end;    internal procedure GetStartPostingProgressMessage(): Text    begin        exit(PostingSustainabilityJournalLbl);    end;    internal procedure GetCheckJournalLineProgressMessage(LineNo: Integer): Text    begin        exit(StrSubstNo(CheckSustainabilityJournalLineLbl, LineNo));    end;    internal procedure GetProgressingLineMessage(LineNo: Integer): Text    begin        exit(StrSubstNo(ProcessingLineLbl, LineNo));    end;    internal procedure GetJnlLinesPostedMessage(): Text    begin        exit(JnlLinesPostedLbl);    end;    internal procedure GetPostConfirmMessage(): Text    begin        exit(PostConfirmLbl);    end;    internal procedure SetSkipUpdateCarbonEmissionValue(NewSkipUpdateCarbonEmissionValue: Boolean)    begin        SkipUpdateCarbonEmissionValue := NewSkipUpdateCarbonEmissionValue;    end;    internal procedure SetNextGLEntryNo(NewGLEntryNo: Integer)    begin        GLEntryNo := NewGLEntryNo;    end;    local procedure CopyDataFromAccountCategory(var SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; CategoryCode: Code[20])    var        SustainAccountCategory: Record "Sustain. Account Category";    begin        SustainAccountCategory.Get(CategoryCode);        SustainabilityLedgerEntry.Validate("Emission Scope", SustainAccountCategory."Emission Scope");        SustainabilityLedgerEntry.Validate(CO2, SustainAccountCategory.CO2);        SustainabilityLedgerEntry.Validate(CH4, SustainAccountCategory.CH4);        SustainabilityLedgerEntry.Validate(N2O, SustainAccountCategory.N2O);        SustainabilityLedgerEntry.Validate("Calculation Foundation", SustainAccountCategory."Calculation Foundation");    end;    local procedure CopyDateFromAccountSubCategory(var SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; CategoryCode: Code[20]; SubCategoryCode: Code[20])    var        SustainAccountSubCategory: Record "Sustain. Account Subcategory";    begin        SustainAccountSubCategory.Get(CategoryCode, SubCategoryCode);        SustainabilityLedgerEntry.Validate("Emission Factor CO2", SustainAccountSubCategory."Emission Factor CO2");        SustainabilityLedgerEntry.Validate("Emission Factor CH4", SustainAccountSubCategory."Emission Factor CH4");        SustainabilityLedgerEntry.Validate("Emission Factor N2O", SustainAccountSubCategory."Emission Factor N2O");    end;    local procedure CalcCO2ePerUnit(CO2e: Decimal; Quantity: Decimal): Decimal    begin        if Quantity <> 0 then            exit(CO2e / Quantity);        exit(0);    end;    local procedure CalcExpectedCO2e(ItemLedgEntryNo: Integer; InvoicedQty: Decimal; Quantity: Decimal; var ExpectedCO2e: Decimal; CalcReminder: Boolean)    var        SustValueEntry: Record "Sustainability Value Entry";    begin        ExpectedCO2e := 0;        SustValueEntry.SetCurrentKey("Item Ledger Entry No.", "Entry Type");        SustValueEntry.SetRange("Item Ledger Entry No.", ItemLedgEntryNo);        SustValueEntry.SetFilter("Entry Type", '<>%1', SustValueEntry."Entry Type"::Revaluation);        if SustValueEntry.FindSet() and SustValueEntry."Expected Emission" then            if CalcReminder then begin                SustValueEntry.CalcSums("CO2e Amount (Expected)");                ExpectedCO2e := -SustValueEntry."CO2e Amount (Expected)";            end else begin                SustValueEntry.SetRange("Expected Emission", true);                SustValueEntry.SetRange(Adjustment, false);                if SustValueEntry.IsEmpty() then                    exit;                SustValueEntry.CalcSums("CO2e Amount (Expected)");                ExpectedCO2e := SustValueEntry."CO2e Amount (Expected)";                ExpectedCO2e := CalcExpCO2eToBalance(ExpectedCO2e, InvoicedQty, Quantity);            end;    end;    local procedure CalcExpCO2eToBalance(ExpectedCO2e: Decimal; InvoicedQty: Decimal; Quantity: Decimal): Decimal    begin        if (Quantity = 0) or (ExpectedCO2e = 0) or (InvoicedQty = 0) then            exit(0);        exit(-InvoicedQty / Quantity * ExpectedCO2e);    end;    var        SkipUpdateCarbonEmissionValue: Boolean;        GLEntryNo: Integer;        PostingSustainabilityJournalLbl: Label 'Posting Sustainability Journal Lines: \ #1', Comment = '#1 = sub-process progress message';        CheckSustainabilityJournalLineLbl: Label 'Checking Sustainability Journal Line: %1', Comment = '%1 = Line No.';        ProcessingLineLbl: Label 'Processing Line: %1', Comment = '%1 = Line No.';        JnlLinesPostedLbl: Label 'The journal lines were successfully posted.';        PostConfirmLbl: Label 'Do you want to post the journal lines?';        SustainabilityLbl: Label 'Sustainability', Locked = true;        SustainabilityValueEntryAddedLbl: Label 'Sustainability Value Entry Added', Locked = true;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertSustainabilityLedgerEntry(var SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; SustainabilityJnlLine: Record "Sustainability Jnl. Line")    begin    end;    [InternalEvent(false, false)]    local procedure OnInsertLedgerEntryOnBeforeInsert(var SustainabilityLedgerEntry: Record "Sustainability Ledger Entry"; var IsHandled: Boolean)    begin    end;}