Table extension 6211 Sustainability Purch. Line
src/Apps/W1/Sustainability/app/src/Purchase/SustainabilityPurchLine.TableExt.al806 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.Sustainability.Purchase;using Microsoft.FixedAssets.FixedAsset;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Document;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Calculation;using Microsoft.Sustainability.CBAM;using Microsoft.Sustainability.Certificate;using Microsoft.Sustainability.Energy;using Microsoft.Sustainability.Setup;tableextension 6211 "Sustainability Purch. Line" extends "Purchase Line"{ fields { field(6210; "Sust. Account No."; Code[20]) { Caption = 'Sustainability Account No.'; TableRelation = "Sustainability Account" where("Account Type" = const(Posting), Blocked = const(false)); DataClassification = CustomerContent; trigger OnValidate() var SustainabilityAccount: Record "Sustainability Account"; begin Rec.TestStatusOpen(); if Rec."Sust. Account No." <> xRec."Sust. Account No." then ClearEmissionInformation(Rec); if Rec."Sust. Account No." = '' then begin Rec.Validate("Sust. Account Category", ''); "Sust. Account Name" := ''; end else begin ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Sust. Account No.")); SustainabilityAccount.Get(Rec."Sust. Account No."); SustainabilityAccount.CheckAccountReadyForPosting(); SustainabilityAccount.TestField("Direct Posting", true); Rec.Validate("Sust. Account Name", SustainabilityAccount.Name); Rec.Validate("Sust. Account Category", SustainabilityAccount.Category); Rec.Validate("Sust. Account Subcategory", SustainabilityAccount.Subcategory); UpdateDefaultEmissionOnPurchLine(Rec); end; CreateDimFromDefaultDim(FieldNo(Rec."Sust. Account No.")); end; } field(6211; "Sust. Account Name"; Text[100]) { Caption = 'Sustainability Account Name'; DataClassification = CustomerContent; } field(6212; "Sust. Account Category"; Code[20]) { Caption = 'Sustainability Account Category'; Editable = false; TableRelation = "Sustain. Account Category"; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Sust. Account Category" <> '' then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Sust. Account Category")) else Rec.Validate("Sust. Account Subcategory", ''); if "Sust. Account Category" <> xRec."Sust. Account Category" then Rec.Validate("Shortcut Dimension 1 Code", ''); end; } field(6213; "Sust. Account Subcategory"; Code[20]) { Caption = 'Sustainability Account Subcategory'; Editable = false; TableRelation = "Sustain. Account Subcategory".Code where("Category Code" = field("Sust. Account Category")); DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Sust. Account Subcategory" <> '' then begin ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Sust. Account Subcategory")); UpdatePurchaseLineFromAccountSubcategory(); end else begin Rec.Validate("Energy Source Code", ''); Rec.Validate("Renewable Energy", false); end; end; } field(6214; "Emission CO2 Per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CO2 Per Unit'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission CO2 Per Unit" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission CO2 Per Unit")); UpdateSustainabilityEmission(Rec); end; } field(6215; "Emission CH4 Per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CH4 Per Unit'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission CH4 Per Unit" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission CH4 Per Unit")); UpdateSustainabilityEmission(Rec); end; } field(6216; "Emission N2O Per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission N2O Per Unit'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission N2O Per Unit" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission N2O Per Unit")); UpdateSustainabilityEmission(Rec); end; } field(6217; "Emission CO2"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CO2'; CaptionClass = '102,6,1'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission CO2" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission CO2")); if CurrFieldNo <> Rec.FieldNo("Emission CH4 Per Unit") then UpdateEmissionPerUnit(Rec); UpdateCarbonPricingInPurchLine(Rec); end; } field(6218; "Emission CH4"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CH4'; CaptionClass = '102,6,2'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission CH4" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission CH4")); UpdateEmissionPerUnit(Rec); UpdateCarbonPricingInPurchLine(Rec); end; } field(6219; "Emission N2O"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission N2O'; CaptionClass = '102,6,3'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission N2O" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission N2O")); UpdateEmissionPerUnit(Rec); UpdateCarbonPricingInPurchLine(Rec); end; } field(6220; "Posted Emission CO2"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Posted Emission CO2'; CaptionClass = '102,11,1'; Editable = false; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Posted Emission CO2" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Posted Emission CO2")); end; } field(6221; "Posted Emission CH4"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Posted Emission CH4'; CaptionClass = '102,11,2'; Editable = false; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Posted Emission CH4" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Posted Emission CH4")); end; } field(6222; "Posted Emission N2O"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Posted Emission N2O'; CaptionClass = '102,11,3'; Editable = false; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Posted Emission N2O" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Posted Emission N2O")); end; } field(6223; "Energy Source Code"; Code[20]) { Caption = 'Energy Source Code'; TableRelation = "Sustainability Energy Source"; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Energy Source Code" <> '' then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Energy Source Code")); if Rec."Energy Source Code" <> xRec."Energy Source Code" then Rec.Validate("Energy Consumption", 0); end; } field(6224; "Renewable Energy"; Boolean) { Caption = 'Renewable Energy'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Renewable Energy" then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Renewable Energy")); end; } field(6225; "Energy Consumption Per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Energy Consumption Per Unit'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Energy Consumption Per Unit" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Energy Consumption Per Unit")); UpdateSustainabilityEmission(Rec); end; } field(6226; "Energy Consumption"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Energy Consumption'; CaptionClass = '102,13,4'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Energy Consumption" <> 0 then begin Rec.TestField("Energy Source Code"); ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Energy Consumption")); end; UpdateEmissionPerUnit(Rec); end; } field(6227; "Posted Energy Consumption"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Posted Energy Consumption'; CaptionClass = '102,14,4'; Editable = false; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Posted Energy Consumption" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Posted Energy Consumption")); end; } field(6228; "Source of Emission Data"; Enum "Sust. Source of Emission") { DataClassification = CustomerContent; Caption = 'Source of Emission Data'; trigger OnValidate() begin if (Rec."Source of Emission Data" <> Rec."Source of Emission Data"::" ") then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Source of Emission Data")); end; } field(6229; "Emission Verified"; Boolean) { DataClassification = CustomerContent; Caption = 'Emission Verified'; trigger OnValidate() begin if Rec."Emission Verified" then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission Verified")); end; } field(6230; "CBAM Compliance"; Boolean) { DataClassification = CustomerContent; Caption = 'CBAM Compliance'; trigger OnValidate() begin if Rec."CBAM Compliance" then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("CBAM Compliance")); end; } field(6231; "Emission Cost Per Unit"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission Cost Per Unit'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Emission Cost per Unit" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Emission Cost per Unit")); UpdateSustainabilityEmission(Rec); end; } field(6232; "Total Emission Cost"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Total Emission Cost'; CaptionClass = '102,15,5'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Total Emission Cost" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Total Emission Cost")); UpdateEmissionPerUnit(Rec); end; } field(6233; "Posted Total Emission Cost"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Posted Total Emission Cost'; CaptionClass = '102,16,5'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Posted Total Emission Cost" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Posted Total Emission Cost")); end; } field(6234; "Unit for Sust. Formulas"; Code[10]) { Caption = 'Unit for Sust. Formulas'; TableRelation = "Unit of Measure"; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Unit for Sust. Formulas" <> '' then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Unit for Sust. Formulas")); end; } field(6235; "Fuel/Electricity"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Fuel/El. Decimal Places")); Caption = 'Fuel/Electricity'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Fuel/Electricity" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Fuel/Electricity")); if (Rec."Fuel/Electricity" <> xRec."Fuel/Electricity") and (Rec."Sust. Account No." <> '') then SustainabilityCalcMgt.CalculationEmissions(Rec); end; } field(6236; Distance; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Distance Decimal Places")); Caption = 'Distance'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec.Distance <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Distance")); if (Rec."Distance" <> xRec."Distance") and (Rec."Sust. Account No." <> '') then SustainabilityCalcMgt.CalculationEmissions(Rec); end; } field(6237; "Custom Amount"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Custom Amt. Decimal Places")); Caption = 'Custom Amount'; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Custom Amount" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Custom Amount")); if (Rec."Custom Amount" <> xRec."Custom Amount") and (Rec."Sust. Account No." <> '') then SustainabilityCalcMgt.CalculationEmissions(Rec); end; } field(6238; "Installation Multiplier"; Decimal) { AutoFormatType = 0; Caption = 'Installation Multiplier'; InitValue = 1; DataClassification = CustomerContent; trigger OnValidate() begin if (Rec."Installation Multiplier" <> 0) and (Rec."Installation Multiplier" <> xRec."Installation Multiplier") then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Installation Multiplier")); if (Rec."Installation Multiplier" <> xRec."Installation Multiplier") and IsSustainabilityFormulaPurchaseLine() then SustainabilityCalcMgt.CalculationEmissions(Rec); end; } field(6239; "Time Factor"; Decimal) { AutoFormatType = 0; Caption = 'Time Factor'; MaxValue = 1; DataClassification = CustomerContent; trigger OnValidate() begin if Rec."Time Factor" <> 0 then ValidateEmissionPrerequisite(Rec, xRec, Rec.FieldNo("Time Factor")); if (Rec."Time Factor" <> xRec."Time Factor") and (Rec."Sust. Account No." <> '') then SustainabilityCalcMgt.CalculationEmissions(Rec); end; }#pragma warning disable PTE0002 field(6240; "Received Sust. Cert. Type Code"; Code[50]) { Caption = 'Received Sustainability Certificate Type Code'; DataClassification = CustomerContent; } field(6241; "Received Sust. Prod. CL. Code"; Code[50]) { Caption = 'Received Sustainability Product Classification Code'; DataClassification = CustomerContent; }#pragma warning restore PTE0002 field(6242; "EUDR Relevant"; Boolean) { Caption = 'EUDR'; Editable = false; ToolTip = 'Indicates that the item on the purchase line is subject to the EU Deforestation Regulation, so lot-level certification details may be required.'; DataClassification = CustomerContent; } } procedure UpdateSustainabilityEmission(var PurchLine: Record "Purchase Line") begin PurchLine."Emission CO2" := PurchLine."Emission CO2 Per Unit" * PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; PurchLine."Emission CH4" := PurchLine."Emission CH4 Per Unit" * PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; PurchLine."Emission N2O" := PurchLine."Emission N2O Per Unit" * PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; PurchLine."Energy Consumption" := PurchLine."Energy Consumption Per Unit" * PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; if CurrFieldNo in [0, Rec.FieldNo("Emission CO2 Per Unit"), Rec.FieldNo("Emission CH4 Per Unit"), Rec.FieldNo("Emission N2O Per Unit"), Rec.FieldNo("Sust. Account No.")] then PurchLine.UpdateCarbonPricingInPurchLine(PurchLine); PurchLine."Total Emission Cost" := PurchLine."Emission Cost per Unit" * PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; end; procedure UpdateEmissionPerUnit(var PurchLine: Record "Purchase Line") var Denominator: Decimal; begin PurchLine."Emission CO2 Per Unit" := 0; PurchLine."Emission CH4 Per Unit" := 0; PurchLine."Emission N2O Per Unit" := 0; PurchLine."Energy Consumption Per Unit" := 0; PurchLine."Emission Cost per Unit" := 0; if (PurchLine."Qty. per Unit of Measure" = 0) or (PurchLine.Quantity = 0) then exit; Denominator := PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; if PurchLine."Emission CO2" <> 0 then PurchLine."Emission CO2 Per Unit" := PurchLine."Emission CO2" / Denominator; if PurchLine."Emission CH4" <> 0 then PurchLine."Emission CH4 Per Unit" := PurchLine."Emission CH4" / Denominator; if PurchLine."Emission N2O" <> 0 then PurchLine."Emission N2O Per Unit" := PurchLine."Emission N2O" / Denominator; if PurchLine."Energy Consumption" <> 0 then PurchLine."Energy Consumption Per Unit" := PurchLine."Energy Consumption" / Denominator; if PurchLine."Total Emission Cost" <> 0 then PurchLine."Emission Cost Per Unit" := PurchLine."Total Emission Cost" / Denominator; if Rec.Type = Rec.Type::"Charge (Item)" then Rec.UpdateItemChargeAssgnt(); end; internal procedure UpdateCarbonPricingInPurchLine(var PurchLine: Record "Purchase Line") var SustainabilityCarbonPricing: Record "Sustainability Carbon Pricing"; ExistCarbonPrice: Boolean; TotalCO2e: Decimal; Denominator: Decimal; begin PurchLine."Emission Cost Per Unit" := 0; PurchLine."Total Emission Cost" := 0; if (Rec."Sust. Account No." = '') or (Rec.Type <> Rec.Type::Item) then exit; FindCarbonPricingFromPurchaseLine(SustainabilityCarbonPricing, PurchLine, ExistCarbonPrice, TotalCO2e); if not ExistCarbonPrice then exit; PurchLine."Total Emission Cost" := SustainabilityCarbonPricing."Carbon Price" * TotalCO2e; if (PurchLine."Qty. per Unit of Measure" = 0) or (PurchLine.Quantity = 0) then exit; Denominator := PurchLine."Qty. per Unit of Measure" * PurchLine.Quantity; if PurchLine."Total Emission Cost" <> 0 then PurchLine."Emission Cost Per Unit" := PurchLine."Total Emission Cost" / Denominator; end; internal procedure IsSustainabilityFormulaPurchaseLine(): Boolean begin exit((Rec."Sust. Account No." <> '') and ((Rec."Unit for Sust. Formulas" <> '') or (Rec."Fuel/Electricity" <> 0) or (Rec."Time Factor" <> 0) or (Rec.Distance <> 0) or (Rec."Custom Amount" <> 0))); end; local procedure UpdateDefaultEmissionOnPurchLine(var PurchaseLine: Record "Purchase Line") var Item: Record Item; Resource: Record Resource; ItemCharge: Record "Item Charge"; FixedAsset: Record "Fixed Asset"; begin case PurchaseLine.Type of PurchaseLine.Type::Item: begin Item.Get(PurchaseLine."No."); if Item."GHG Credit" then PurchaseLine.Validate("Emission CO2 Per Unit", Item."Carbon Credit Per UOM") else begin PurchaseLine.Validate("Emission CO2 Per Unit", Item."Default CO2 Emission"); PurchaseLine.Validate("Emission CH4 Per Unit", Item."Default CH4 Emission"); PurchaseLine.Validate("Emission N2O Per Unit", Item."Default N2O Emission"); end; PurchaseLine.Validate("Source of Emission Data", Item."Source of Emission Data"); PurchaseLine.Validate("Emission Verified", Item."Emission Verified"); PurchaseLine.Validate("CBAM Compliance", Item."CBAM Compliance"); end; PurchaseLine.Type::Resource: begin Resource.Get(PurchaseLine."No."); PurchaseLine.Validate("Emission CO2 Per Unit", Resource."Default CO2 Emission"); PurchaseLine.Validate("Emission CH4 Per Unit", Resource."Default CH4 Emission"); PurchaseLine.Validate("Emission N2O Per Unit", Resource."Default N2O Emission"); end; PurchaseLine.Type::"Charge (Item)": begin ItemCharge.Get(PurchaseLine."No."); PurchaseLine.Validate("Emission CO2 Per Unit", ItemCharge."Default CO2 Emission"); PurchaseLine.Validate("Emission CH4 Per Unit", ItemCharge."Default CH4 Emission"); PurchaseLine.Validate("Emission N2O Per Unit", ItemCharge."Default N2O Emission"); end; PurchaseLine.Type::"Fixed Asset": begin FixedAsset.Get(PurchaseLine."No."); PurchaseLine.Validate("Emission CO2 Per Unit", FixedAsset."Default CO2 Emission"); PurchaseLine.Validate("Emission CH4 Per Unit", FixedAsset."Default CH4 Emission"); PurchaseLine.Validate("Emission N2O Per Unit", FixedAsset."Default N2O Emission"); end; end end; local procedure ClearEmissionInformation(var PurchLine: Record "Purchase Line") begin PurchLine.Validate("Emission CO2 Per Unit", 0); PurchLine.Validate("Emission CH4 Per Unit", 0); PurchLine.Validate("Emission N2O Per Unit", 0); PurchLine.Validate("Source of Emission Data", Rec."Source of Emission Data"::" "); PurchLine.Validate("CBAM Compliance", false); PurchLine.Validate("Emission Verified", false); PurchLine.Validate("Emission Cost Per Unit", 0); PurchLine.Validate("Unit for Sust. Formulas", ''); PurchLine.Validate("Fuel/Electricity", 0); PurchLine.Validate(Distance, 0); PurchLine.Validate("Time Factor", 0); PurchLine.Validate("Custom Amount", 0); end; local procedure ValidateEmissionPrerequisite(PurchaseLine: Record "Purchase Line"; xPurchaseLine: Record "Purchase Line"; CurrentFieldNo: Integer) var Item: Record Item; SustAccountCategory: Record "Sustain. Account Category"; begin case CurrentFieldNo of PurchaseLine.FieldNo("Emission N2O"), PurchaseLine.FieldNo("Emission N2O Per Unit"), PurchaseLine.FieldNo("Emission CH4"), PurchaseLine.FieldNo("Emission CH4 Per Unit"): begin PurchaseLine.TestStatusOpen(); PurchaseLine.TestField("Sust. Account No."); if (PurchaseLine.Type = PurchaseLine.Type::Item) and (PurchaseLine."No." <> '') then begin Item.Get(PurchaseLine."No."); if Item."GHG Credit" then Item.TestField("GHG Credit", false); end; if (CurrFieldNo in [PurchaseLine.FieldNo("Emission CH4"), PurchaseLine.FieldNo("Emission CH4 Per Unit"), PurchaseLine.FieldNo("Emission N2O"), PurchaseLine.FieldNo("Emission N2O Per Unit")]) then CheckSustainabilityFormula(PurchaseLine); end; PurchaseLine.FieldNo("Emission CO2"), PurchaseLine.FieldNo("Emission CO2 Per Unit"), PurchaseLine.FieldNo("Energy Source Code"), PurchaseLine.FieldNo("Renewable Energy"), PurchaseLine.FieldNo("Energy Consumption"), PurchaseLine.FieldNo("Energy Consumption Per Unit"), PurchaseLine.FieldNo("Emission Verified"), PurchaseLine.FieldNo("Source of Emission Data"), PurchaseLine.FieldNo("CBAM Compliance"), PurchaseLine.FieldNo("Emission Cost Per Unit"), PurchaseLine.FieldNo("Total Emission Cost"): begin PurchaseLine.TestStatusOpen(); PurchaseLine.TestField("Sust. Account No."); if (CurrFieldNo in [PurchaseLine.FieldNo("Emission CO2"), PurchaseLine.FieldNo("Emission CO2 Per Unit")]) then CheckSustainabilityFormula(PurchaseLine); end; PurchaseLine.FieldNo("Sust. Account No."), PurchaseLine.FieldNo("Sust. Account Category"), PurchaseLine.FieldNo("Sust. Account Subcategory"), PurchaseLine.FieldNo("Sust. Account Name"): begin PurchaseLine.TestField("No."); if not (PurchaseLine.Type in [PurchaseLine.Type::Item, PurchaseLine.Type::"G/L Account", PurchaseLine.Type::Resource, PurchaseLine.Type::"Charge (Item)", PurchaseLine.Type::"Fixed Asset"]) then Error(InvalidTypeForSustErr, PurchaseLine.Type::Item, PurchaseLine.Type::"G/L Account", PurchaseLine.Type::Resource, PurchaseLine.Type::"Charge (Item)", PurchaseLine.Type::"Fixed Asset"); if SustAccountCategory.Get(PurchaseLine."Sust. Account Category") then if SustAccountCategory."Water Intensity" or SustAccountCategory."Waste Intensity" or SustAccountCategory."Discharged Into Water" then Error(NotAllowedToUseSustAccountForWaterOrWasteErr, PurchaseLine."Sust. Account No."); if PurchaseLine.Type = PurchaseLine.Type::"Fixed Asset" then PurchaseLine.TestField("FA Posting Type", PurchaseLine."FA Posting Type"::"Acquisition Cost"); end; PurchaseLine.FieldNo("Unit for Sust. Formulas"), PurchaseLine.FieldNo("Fuel/Electricity"), PurchaseLine.FieldNo("Custom Amount"), PurchaseLine.FieldNo(Distance), PurchaseLine.FieldNo("Installation Multiplier"), PurchaseLine.FieldNo("Time Factor"): begin PurchaseLine.TestStatusOpen(); PurchaseLine.TestField("Sust. Account No."); CheckEmissionMustBeZeroWhenFormulaIsUpdated(PurchaseLine, xPurchaseLine); end; end; end; local procedure CheckEmissionMustBeZeroWhenFormulaIsUpdated(PurchaseLine: Record "Purchase Line"; xPurchaseLine: Record "Purchase Line") begin if (xPurchaseLine."Unit for Sust. Formulas" <> '') or (xPurchaseLine."Fuel/Electricity" <> 0) or (xPurchaseLine."Custom Amount" <> 0) or (xPurchaseLine.Distance <> 0) or (xPurchaseLine."Time Factor" <> 0) then exit; if not (CurrFieldNo in [PurchaseLine.FieldNo("Unit for Sust. Formulas"), PurchaseLine.FieldNo("Fuel/Electricity"), PurchaseLine.FieldNo("Custom Amount"), PurchaseLine.FieldNo(Distance), PurchaseLine.FieldNo("Installation Multiplier"), PurchaseLine.FieldNo("Time Factor")]) then exit; PurchaseLine.TestField("Emission CO2", 0); PurchaseLine.TestField("Emission CH4", 0); PurchaseLine.TestField("Emission N2O", 0); end; local procedure CheckSustainabilityFormula(PurchaseLine: Record "Purchase Line") begin PurchaseLine.TestField("Unit for Sust. Formulas", ''); PurchaseLine.TestField("Fuel/Electricity", 0); PurchaseLine.TestField("Custom Amount", 0); PurchaseLine.TestField(Distance, 0); PurchaseLine.TestField("Time Factor", 0); end; local procedure UpdatePurchaseLineFromAccountSubcategory() var SustainAccountSubcategory: Record "Sustain. Account Subcategory"; begin SustainAccountSubcategory.Get(Rec."Sust. Account Category", Rec."Sust. Account Subcategory"); Rec.Validate("Energy Source Code", SustainAccountSubcategory."Energy Source Code"); Rec.Validate("Renewable Energy", SustainAccountSubcategory."Renewable Energy"); end; local procedure FindCarbonPricingFromPurchaseLine(var SustainabilityCarbonPricing: Record "Sustainability Carbon Pricing"; var PurchLine: Record "Purchase Line"; var ExistCarbonPrice: Boolean; var TotalCO2e: Decimal) var PurchaseHeader: Record "Purchase Header"; PurchaseSubscriber: Codeunit "Sust. Purchase Subscriber"; begin PurchaseHeader := PurchLine.GetPurchHeader(); FilterCarbonPricing(SustainabilityCarbonPricing, PurchaseHeader, PurchLine); if not SustainabilityCarbonPricing.FindLast() then exit; PurchaseSubscriber.GetCO2eEmissionFromPurchLine(PurchLine, TotalCO2e); if (TotalCO2e > SustainabilityCarbonPricing."Threshold Quantity") then ExistCarbonPrice := true; end; local procedure FilterCarbonPricing(var SustainabilityCarbonPricing: Record "Sustainability Carbon Pricing"; PurchaseHeader: Record "Purchase Header"; PurchLine: Record "Purchase Line") var Item: Record Item; begin Item.Get(PurchLine."No."); SustainabilityCarbonPricing.Reset(); if Item."Country/Region of Origin Code" <> '' then SustainabilityCarbonPricing.SetRange("Country/Region of Origin", Item."Country/Region of Origin Code") else SustainabilityCarbonPricing.SetRange("Country/Region of Origin", PurchaseHeader."Buy-from Country/Region Code"); SustainabilityCarbonPricing.SetFilter("Ending Date", '%1|>=%2', 0D, PurchaseHeaderStartDate(PurchaseHeader)); SustainabilityCarbonPricing.SetRange("Starting Date", 0D, PurchaseHeaderStartDate(PurchaseHeader)); end; local procedure PurchaseHeaderStartDate(PurchaseHeader: Record "Purchase Header"): Date begin if PurchaseHeader."Document Type" in [PurchaseHeader."Document Type"::Invoice, PurchaseHeader."Document Type"::"Credit Memo"] then exit(PurchaseHeader."Posting Date") else exit(PurchaseHeader."Order Date"); end; var SustainabilitySetup: Record "Sustainability Setup"; SustainabilityCalcMgt: Codeunit "Sustainability Calc. Mgt."; InvalidTypeForSustErr: Label 'Sustainability is only applicable for Type: %1 , %2 , %3 , %4 and %5', Comment = '%1 - Purchase Line Type Item, %2 - Purchase Line Type G/L Account, %3 - Purchase Line Type Resource , %4 - Purchase Line Type Charge (Item) , %5 - Purchase Line Type Fixed Asset'; NotAllowedToUseSustAccountForWaterOrWasteErr: Label 'It is not allowed to use Sustainability Account %1 for water or waste in purchase document.', Comment = '%1 = Sust. Account No.';}