Codeunit 6253 Sust. Sales Subscriber
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.';}