Codeunit 6253 Sust. Sales Subscriber

Sustainability, Microsoft.Sustainability.Sales

src/Apps/W1/Sustainability/app/src/Sales/SustSalesSubscriber.Codeunit.al376 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Sales;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.ReceivablesPayables;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.Inventory;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Ledger;using Microsoft.Projects.Resources.Resource;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Posting;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Setup;codeunit 6253 "Sust. Sales Subscriber"{    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterAssignGLAccountValues', '', false, false)]    local procedure OnAfterAssignGLAccountValues(var SalesLine: Record "Sales Line"; GLAccount: Record "G/L Account")    begin        if SustainabilitySetup.IsValueChainTrackingEnabled() then            SalesLine.Validate("Sust. Account No.", GLAccount."Default Sust. Account");    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterAssignItemValues', '', false, false)]    local procedure OnAfterAssignItemValues(var SalesLine: Record "Sales Line"; Item: Record Item)    begin        SalesLine.Validate("EUDR Relevant", Item."EUDR Relevant");        if SustainabilitySetup.IsValueChainTrackingEnabled() then            SalesLine.Validate("Sust. Account No.", Item."Default Sust. Account");    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterAssignResourceValues', '', false, false)]    local procedure OnAfterAssignResourceValues(var SalesLine: Record "Sales Line"; Resource: Record Resource)    begin        if SustainabilitySetup.IsValueChainTrackingEnabled() then            SalesLine.Validate("Sust. Account No.", Resource."Default Sust. Account");    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterAssignItemChargeValues', '', false, false)]    local procedure OnAfterAssignItemChargeValues(var SalesLine: Record "Sales Line"; ItemCharge: Record "Item Charge")    begin        if SustainabilitySetup.IsValueChainTrackingEnabled() then            SalesLine.Validate("Sust. Account No.", ItemCharge."Default Sust. Account");    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterAssignFixedAssetValues', '', false, false)]    local procedure OnAfterAssignFixedAssetValues(var SalesLine: Record "Sales Line"; FixedAsset: Record "Fixed Asset")    begin        if SustainabilitySetup.IsValueChainTrackingEnabled() then            SalesLine.Validate("Sust. Account No.", FixedAsset."Default Sust. Account");    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnValidateQuantityOnBeforeResetAmounts', '', false, false)]    local procedure OnValidateQuantityOnBeforeResetAmounts(var SalesLine: Record "Sales Line")    begin        SalesLine.UpdateSustainabilityEmission(SalesLine);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnPostItemTrackingForShipmentConditionOnBeforeUpdateBlanketOrderLine', '', false, false)]    local procedure OnPostUpdateOrderLineOnBeforeUpdateBlanketOrderLine(var SalesHeader: Record "Sales Header"; var TempSalesLine: Record "Sales Line" temporary)    begin        if SalesHeader.Invoice then            UpdatePostedSustainabilityEmissionOrderLine(SalesHeader, TempSalesLine);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforeSalesShptLineInsert', '', false, false)]    local procedure OnBeforeSalesShptLineInsert(SalesLine: Record "Sales Line"; var SalesShptLine: Record "Sales Shipment Line")    begin        UpdatePostedSustainabilityEmission(SalesLine, SalesShptLine.Quantity, 1, SalesShptLine."Total CO2e", SalesShptLine."Total EPR Fee");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforeReturnRcptLineInsert', '', false, false)]    local procedure OnBeforeReturnRcptLineInsert(SalesLine: Record "Sales Line"; var ReturnRcptLine: Record "Return Receipt Line")    begin        UpdatePostedSustainabilityEmission(SalesLine, ReturnRcptLine.Quantity, 1, ReturnRcptLine."Total CO2e", ReturnRcptLine."Total EPR Fee");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforeSalesInvLineInsert', '', false, false)]    local procedure OnBeforeSalesInvLineInsert(SalesLine: Record "Sales Line"; var SalesInvLine: Record "Sales Invoice Line")    begin        UpdatePostedSustainabilityEmission(SalesLine, SalesInvLine.Quantity, 1, SalesInvLine."Total CO2e", SalesInvLine."Total EPR Fee");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforeSalesCrMemoLineInsert', '', false, false)]    local procedure OnBeforeSalesCrMemoLineInsert(SalesLine: Record "Sales Line"; var SalesCrMemoLine: Record "Sales Cr.Memo Line")    begin        UpdatePostedSustainabilityEmission(SalesLine, SalesCrMemoLine.Quantity, 1, SalesCrMemoLine."Total CO2e", SalesCrMemoLine."Total EPR Fee");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforePostUpdateOrderLineModifyTempLine', '', false, false)]    local procedure OnBeforePostUpdateOrderLineModifyTempLine(var TempSalesLine: Record "Sales Line" temporary)    begin        TempSalesLine.UpdateSustainabilityEmission(TempSalesLine);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales Post Invoice Events", 'OnAfterPrepareInvoicePostingBuffer', '', false, false)]    local procedure OnAfterPrepareInvoicePostingBuffer(var InvoicePostingBuffer: Record "Invoice Posting Buffer" temporary; var SalesLine: Record "Sales Line")    begin        if (SalesLine."Qty. to Invoice" <> 0) and (SalesLine.Type = SalesLine.Type::"Fixed Asset") then            CheckAndUpdateSustainabilityInvoicePostingBuffer(InvoicePostingBuffer, SalesLine);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"FA Insert Ledger Entry", 'OnInsertFAOnAfterInsertFALedgEntry', '', false, false)]    local procedure OnInsertFAOnAfterInsertFALedgEntry(var FALedgerEntry: Record "FA Ledger Entry")    begin        UpdateTotalCO2eForProceedsOnDisposal(FALedgerEntry);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales Post Invoice Events", 'OnAfterPrepareGenJnlLine', '', false, false)]    local procedure OnAfterPrepareGenJnlLine(InvoicePostingBuffer: Record "Invoice Posting Buffer" temporary; var GenJnlLine: Record "Gen. Journal Line")    begin        GenJnlLine."Sust. Account No." := InvoicePostingBuffer."Sust. Account No.";        GenJnlLine."Sust. Account Name" := InvoicePostingBuffer."Sust. Account Name";        GenJnlLine."Sust. Account Category" := InvoicePostingBuffer."Sust. Account Category";        GenJnlLine."Sust. Account Subcategory" := InvoicePostingBuffer."Sust. Account Subcategory";        GenJnlLine."CO2e per Unit" := InvoicePostingBuffer."CO2e per Unit";        GenJnlLine."Total CO2e" := InvoicePostingBuffer."Total CO2e";    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnPostItemJnlLineOnAfterPrepareItemJnlLine', '', false, false)]    local procedure OnPostItemJnlLineOnAfterPrepareItemJnlLine(var ItemJournalLine: Record "Item Journal Line"; SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line")    begin        if (ItemJournalLine.Quantity <> 0) or (ItemJournalLine."Invoiced Quantity" <> 0) then            UpdateSustainabilityItemJournalLine(ItemJournalLine, SalesHeader, SalesLine);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Undo Sales Shipment Line", 'OnBeforeNewSalesShptLineInsert', '', false, false)]    local procedure OnBeforeNewSalesShptLineInsert(OldSalesShipmentLine: Record "Sales Shipment Line"; var NewSalesShipmentLine: Record "Sales Shipment Line")    begin        UpdatePostedSustainabilityEmission(OldSalesShipmentLine, OldSalesShipmentLine.Quantity, -1, NewSalesShipmentLine."Total CO2e");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Undo Posting Management", 'OnPostItemJnlLineAppliedToListOnAfterSetInvoicedQty', '', false, false)]    local procedure OnPostItemJnlLineAppliedToListOnAfterSetInvoicedQty(var ItemJournalLine: Record "Item Journal Line"; TempApplyToItemLedgEntry: Record "Item Ledger Entry" temporary)    var        SalesShptLine: Record "Sales Shipment Line";    begin        if (ItemJournalLine."Quantity (Base)" <> 0) or (ItemJournalLine."Invoiced Qty. (Base)" <> 0) then            if ItemJournalLine."Document Type" = ItemJournalLine."Document Type"::"Sales Shipment" then                if SalesShptLine.Get(ItemJournalLine."Document No.", TempApplyToItemLedgEntry."Document Line No.") then                    UpdateSustainabilityItemJournalLine(ItemJournalLine, SalesShptLine);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Undo Sales Shipment Line", 'OnPostItemJnlLineOnBeforeRunItemJnlPostLine', '', false, false)]    local procedure OnPostItemJnlLineOnBeforeRunItemJnlPostLine(var ItemJnlLine: Record "Item Journal Line"; SalesShptLine: Record "Sales Shipment Line")    begin        if (ItemJnlLine."Quantity (Base)" <> 0) or (ItemJnlLine."Invoiced Qty. (Base)" <> 0) then            UpdateSustainabilityItemJournalLine(ItemJnlLine, SalesShptLine);    end;    local procedure UpdateSustainabilityItemJournalLine(var ItemJournalLine: Record "Item Journal Line"; SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line")    var        GHGCredit: Boolean;        Sign: Integer;        CO2eToPost: Decimal;        EPRFeeToPost: Decimal;    begin        GHGCredit := IsGHGCreditLine(SalesLine);        Sign := GetPostingSign(SalesHeader, GHGCredit);        if ItemJournalLine."Invoiced Quantity" <> 0 then begin            CO2eToPost := SalesLine."CO2e per Unit" * Abs(ItemJournalLine."Invoiced Quantity") * SalesLine."Qty. per Unit of Measure";            EPRFeeToPost := SalesLine."EPR Fee Per Unit" * Abs(ItemJournalLine."Invoiced Quantity") * SalesLine."Qty. per Unit of Measure";        end        else begin            CO2eToPost := SalesLine."CO2e per Unit" * Abs(ItemJournalLine.Quantity) * SalesLine."Qty. per Unit of Measure";            EPRFeeToPost := SalesLine."EPR Fee Per Unit" * Abs(ItemJournalLine.Quantity) * SalesLine."Qty. per Unit of Measure";        end;        CO2eToPost := CO2eToPost * Sign;        EPRFeeToPost := EPRFeeToPost * Sign;        if not CanPostSustainabilityJnlLine(SalesLine."Sust. Account No.", SalesLine."Sust. Account Category", SalesLine."Sust. Account Subcategory", CO2eToPost) then            exit;        ItemJournalLine."Sust. Account No." := SalesLine."Sust. Account No.";        ItemJournalLine."Sust. Account Name" := SalesLine."Sust. Account Name";        ItemJournalLine."Sust. Account Category" := SalesLine."Sust. Account Category";        ItemJournalLine."Sust. Account Subcategory" := SalesLine."Sust. Account Subcategory";        ItemJournalLine."CO2e per Unit" := SalesLine."CO2e per Unit";        ItemJournalLine."Total CO2e" := CO2eToPost;        ItemJournalLine."EPR Fee per Unit" := SalesLine."EPR Fee Per Unit";        ItemJournalLine."Total EPR Fee" := EPRFeeToPost;    end;    local procedure UpdateSustainabilityItemJournalLine(var ItemJournalLine: Record "Item Journal Line"; SalesShipmentLine: Record "Sales Shipment Line")    var        GHGCredit: Boolean;        Sign: Integer;        CO2eToPost: Decimal;    begin        Sign := 1;        GHGCredit := IsGHGCreditLine(SalesShipmentLine);        if GHGCredit then            Sign := -1;        if ItemJournalLine."Invoiced Qty. (Base)" <> 0 then            CO2eToPost := SalesShipmentLine."CO2e per Unit" * Abs(ItemJournalLine."Invoiced Qty. (Base)") * SalesShipmentLine."Qty. per Unit of Measure"        else            CO2eToPost := SalesShipmentLine."CO2e per Unit" * Abs(ItemJournalLine."Quantity (Base)") * SalesShipmentLine."Qty. per Unit of Measure";        CO2eToPost := CO2eToPost * Sign;        if not CanPostSustainabilityJnlLine(SalesShipmentLine."Sust. Account No.", SalesShipmentLine."Sust. Account Category", SalesShipmentLine."Sust. Account Subcategory", CO2eToPost) then            exit;        ItemJournalLine."Sust. Account No." := SalesShipmentLine."Sust. Account No.";        ItemJournalLine."Sust. Account Name" := SalesShipmentLine."Sust. Account Name";        ItemJournalLine."Sust. Account Category" := SalesShipmentLine."Sust. Account Category";        ItemJournalLine."Sust. Account Subcategory" := SalesShipmentLine."Sust. Account Subcategory";        ItemJournalLine."CO2e per Unit" := SalesShipmentLine."CO2e per Unit";        ItemJournalLine."Total CO2e" := CO2eToPost;    end;    local procedure CheckAndUpdateSustainabilityInvoicePostingBuffer(var InvoicePostingBuffer: Record "Invoice Posting Buffer" temporary; var SalesLine: Record "Sales Line")    var        SalesHeader: Record "Sales Header";        GHGCredit: Boolean;        Sign: Integer;        CO2eToPost: Decimal;    begin        SalesHeader := SalesLine.GetSalesHeader();        GHGCredit := IsGHGCreditLine(SalesLine);        Sign := GetPostingSign(SalesHeader, GHGCredit);        CO2eToPost := SalesLine."CO2e per Unit" * Abs(SalesLine."Qty. to Invoice") * SalesLine."Qty. per Unit of Measure";        CO2eToPost := CO2eToPost * Sign;        if not SustainabilitySetup.IsValueChainTrackingEnabled() then            exit;        if not CanPostSustainabilityJnlLine(SalesLine."Sust. Account No.", SalesLine."Sust. Account Category", SalesLine."Sust. Account Subcategory", CO2eToPost) then            exit;        InvoicePostingBuffer."Sust. Account No." := SalesLine."Sust. Account No.";        InvoicePostingBuffer."Sust. Account Name" := SalesLine."Sust. Account Name";        InvoicePostingBuffer."Sust. Account Category" := SalesLine."Sust. Account Category";        InvoicePostingBuffer."Sust. Account Subcategory" := SalesLine."Sust. Account Subcategory";        InvoicePostingBuffer."CO2e per Unit" := SalesLine."CO2e per Unit";        InvoicePostingBuffer."Total CO2e" := CO2eToPost;    end;    local procedure UpdateTotalCO2eForProceedsOnDisposal(var FALedgerEntry: Record "FA Ledger Entry")    var        FADepreciationBook: Record "FA Depreciation Book";    begin        if FALedgerEntry."Sust. Account No." = '' then            exit;        FADepreciationBook.Get(FALedgerEntry."FA No.", FALedgerEntry."Depreciation Book Code");        if (FALedgerEntry."FA Posting Type" = FALedgerEntry."FA Posting Type"::"Gain/Loss") then begin            FADepreciationBook.CalcFields("Book Total CO2e", "Proceeds on Disposal CO2e");            FALedgerEntry."Total CO2e" := FADepreciationBook."Book Total CO2e" + FADepreciationBook."Proceeds on Disposal CO2e";            FALedgerEntry.Modify();        end;        if (FALedgerEntry."FA Posting Type" = FALedgerEntry."FA Posting Type"::"Acquisition Cost") and           (FALedgerEntry."FA Posting Category" = FALedgerEntry."FA Posting Category"::Disposal)        then begin            FADepreciationBook.CalcFields("Acquisition Total CO2e");            FALedgerEntry."Total CO2e" := -FADepreciationBook."Acquisition Total CO2e";            FALedgerEntry.Modify();        end;    end;    local procedure UpdatePostedSustainabilityEmissionOrderLine(SalesHeader: Record "Sales Header"; var TempSalesLine: Record "Sales Line" temporary)    var        PostedEmissionCO2e: Decimal;        PostedEmissionEPRFee: Decimal;        GHGCredit: Boolean;        Sign: Integer;    begin        GHGCredit := IsGHGCreditLine(TempSalesLine);        Sign := GetPostingSign(SalesHeader, GHGCredit);        UpdatePostedSustainabilityEmission(TempSalesLine, TempSalesLine."Qty. to Invoice", Sign, PostedEmissionCO2e, PostedEmissionEPRFee);        TempSalesLine."Posted Total CO2e" += PostedEmissionCO2e;        TempSalesLine."Posted Total EPR Fee" += PostedEmissionEPRFee;    end;    local procedure UpdatePostedSustainabilityEmission(SalesLine: Record "Sales Line"; Quantity: Decimal; Sign: Integer; var PostedEmissionCO2e: Decimal; var PostedEmissionEPRFee: Decimal)    begin        PostedEmissionCO2e := (SalesLine."CO2e per Unit" * Abs(Quantity) * SalesLine."Qty. per Unit of Measure") * Sign;        PostedEmissionEPRFee := (SalesLine."EPR Fee Per Unit" * Abs(Quantity) * SalesLine."Qty. per Unit of Measure") * Sign;    end;    local procedure UpdatePostedSustainabilityEmission(SalesShipmentLine: Record "Sales Shipment Line"; Quantity: Decimal; Sign: Integer; var PostedEmissionCO2e: Decimal)    begin        PostedEmissionCO2e := (SalesShipmentLine."CO2e per Unit" * Abs(Quantity) * SalesShipmentLine."Qty. per Unit of Measure") * Sign;    end;    local procedure GetPostingSign(SalesHeader: Record "Sales Header"; GHGCredit: Boolean): Integer    var        Sign: Integer;    begin        Sign := 1;        case SalesHeader."Document Type" of            SalesHeader."Document Type"::Invoice, SalesHeader."Document Type"::Order:                if not GHGCredit then                    Sign := -1;            else                if GHGCredit then                    Sign := -1;        end;        exit(Sign);    end;    local procedure IsGHGCreditLine(SalesLine: Record "Sales Line"): Boolean    var        Item: Record Item;    begin        if SalesLine.Type <> SalesLine.Type::Item then            exit(false);        if SalesLine."No." = '' then            exit(false);        Item.Get(SalesLine."No.");        exit(Item."GHG Credit");    end;    local procedure IsGHGCreditLine(SalesShipmentLine: Record "Sales Shipment Line"): Boolean    var        Item: Record Item;    begin        if SalesShipmentLine.Type <> SalesShipmentLine.Type::Item then            exit(false);        if SalesShipmentLine."No." = '' then            exit(false);        Item.Get(SalesShipmentLine."No.");        exit(Item."GHG Credit");    end;    local procedure CanPostSustainabilityJnlLine(AccountNo: Code[20]; AccountCategory: Code[20]; AccountSubCategory: Code[20]; CO2eToPost: Decimal): Boolean    var        SustAccountCategory: Record "Sustain. Account Category";        SustainAccountSubcategory: Record "Sustain. Account Subcategory";    begin        if AccountNo = '' then            exit(false);        if not SustainabilitySetup.IsValueChainTrackingEnabled() then            exit(false);        if SustAccountCategory.Get(AccountCategory) then            if SustAccountCategory."Water Intensity" or SustAccountCategory."Waste Intensity" or SustAccountCategory."Discharged Into Water" then                Error(NotAllowedToPostSustLedEntryForWaterOrWasteErr, AccountNo);        if SustainAccountSubcategory.Get(AccountCategory, AccountSubCategory) then            if not SustainAccountSubcategory."Renewable Energy" then                if (CO2eToPost = 0) then                    Error(CO2eMustNotBeZeroErr);        if (CO2eToPost <> 0) then            exit(true);    end;    var        SustainabilitySetup: Record "Sustainability Setup";        CO2eMustNotBeZeroErr: Label 'The CO2e fields must have a value that is not 0.';        NotAllowedToPostSustLedEntryForWaterOrWasteErr: Label 'It is not allowed to post Sustainability Ledger Entry for water or waste in sales document for Account No. %1', Comment = '%1 = Sustainability Account No.';}