Table extension 6235 Sustainability Sales Line

Sustainability, Microsoft.Sustainability.Sales

src/Apps/W1/Sustainability/app/src/Sales/SustainabilitySalesLine.TableExt.al263 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Sales;using Microsoft.FixedAssets.Ledger;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;using Microsoft.Sales.Document;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Setup;tableextension 6235 "Sustainability Sales Line" extends "Sales 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, 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);                    UpdateCO2eInformation();                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, 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                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Sust. Account Subcategory"));            end;        }        field(6214; "CO2e per Unit"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'CO2e per Unit';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."CO2e per Unit" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("CO2e per Unit"));                UpdateSustainabilityEmission(Rec);            end;        }        field(6215; "Total CO2e"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Total CO2e';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Total CO2e" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Total CO2e"));                UpdateEmissionPerUnit(Rec);            end;        }        field(6216; "Posted Total CO2e"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Posted Total CO2e';            Editable = false;            DataClassification = CustomerContent;        }        field(6217; "EPR Fee Per Unit"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'EPR Fee Per Unit';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."EPR Fee Per Unit" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("EPR Fee Per Unit"));                UpdateSustainabilityEmission(Rec);            end;        }        field(6218; "Total EPR Fee"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Total EPR Fee';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Total EPR Fee" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Total EPR Fee"));                UpdateEmissionPerUnit(Rec);            end;        }        field(6219; "Posted Total EPR Fee"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Posted Total EPR Fee';            Editable = false;            DataClassification = CustomerContent;        }        field(6242; "EUDR Relevant"; Boolean)        {            Caption = 'EUDR Relevant';            Editable = false;            DataClassification = CustomerContent;        }    }    procedure UpdateSustainabilityEmission(var SalesLine: Record "Sales Line")    begin        SalesLine."Total CO2e" := SalesLine."CO2e per Unit" * SalesLine."Qty. per Unit of Measure" * SalesLine.Quantity;        SalesLine."Total EPR Fee" := SalesLine."EPR Fee Per Unit" * SalesLine."Qty. per Unit of Measure" * SalesLine.Quantity;    end;    procedure UpdateEmissionPerUnit(var SalesLine: Record "Sales Line")    var        Denominator: Decimal;    begin        SalesLine."CO2e Per Unit" := 0;        SalesLine."EPR Fee Per Unit" := 0;        if (SalesLine."Qty. per Unit of Measure" = 0) or (SalesLine.Quantity = 0) then            exit;        Denominator := SalesLine."Qty. per Unit of Measure" * SalesLine.Quantity;        if SalesLine."Total CO2e" <> 0 then            SalesLine."CO2e per Unit" := SalesLine."Total CO2e" / Denominator;        if SalesLine."Total EPR Fee" <> 0 then            SalesLine."EPR Fee Per Unit" := SalesLine."Total EPR Fee" / Denominator;    end;    local procedure ClearEmissionInformation(var SalesLine: Record "Sales Line")    begin        SalesLine.Validate("CO2e per Unit", 0);        SalesLine.Validate("EPR Fee Per Unit", 0);    end;    local procedure ValidateEmissionPrerequisite(SalesLine: Record "Sales Line"; CurrentFieldNo: Integer)    var        SustAccountCategory: Record "Sustain. Account Category";    begin        case CurrentFieldNo of            SalesLine.FieldNo("CO2e per Unit"),            SalesLine.FieldNo("Total CO2e"),             SalesLine.FieldNo("EPR Fee Per Unit"),            SalesLine.FieldNo("Total EPR Fee"):                begin                    SalesLine.TestStatusOpen();                    SalesLine.TestField("Sust. Account No.");                end;            SalesLine.FieldNo("Sust. Account No."),            SalesLine.FieldNo("Sust. Account Category"),            SalesLine.FieldNo("Sust. Account Subcategory"),            SalesLine.FieldNo("Sust. Account Name"):                begin                    SalesLine.TestField("No.");                    if not (SalesLine.Type in [SalesLine.Type::Item, SalesLine.Type::"G/L Account", SalesLine.Type::Resource, SalesLine.Type::"Fixed Asset"]) then                        Error(InvalidTypeForSustErr, SalesLine.Type::Item, SalesLine.Type::"G/L Account", SalesLine.Type::Resource, SalesLine.Type::"Fixed Asset");                    if SustAccountCategory.Get(SalesLine."Sust. Account Category") then                        if SustAccountCategory."Water Intensity" or SustAccountCategory."Waste Intensity" or SustAccountCategory."Discharged Into Water" then                            Error(NotAllowedToUseSustAccountForWaterOrWasteErr, SalesLine."Sust. Account No.");                end;        end;    end;    local procedure UpdateCO2eInformation()    var        Item: Record Item;        Resource: Record Resource;        FALedgerEntry: Record "FA Ledger Entry";    begin        case Rec.Type of            Rec.Type::Item:                begin                    Item.Get(Rec."No.");                    Rec.Validate("CO2e per Unit", Item."CO2e per Unit");                    Rec.Validate("EPR Fee Per Unit", Item."EPR Fees Per Unit");                end;            Rec.Type::Resource:                begin                    Resource.Get(Rec."No.");                    Rec.Validate("CO2e per Unit", Resource."CO2e per Unit");                end;            Rec.Type::"Fixed Asset":                begin                    FALedgerEntry.SetLoadFields("Total CO2e");                    FALedgerEntry.SetRange("FA No.", Rec."No.");                    FALedgerEntry.SetRange("Depreciation Book Code", Rec."Depreciation Book Code");                    FALedgerEntry.SetRange("FA Posting Category", FALedgerEntry."FA Posting Category"::" ");                    FALedgerEntry.SetRange(Reversed, false);                    FALedgerEntry.CalcSums("Total CO2e");                    Rec.Validate("CO2e per Unit", FALedgerEntry."Total CO2e");                end;        end;    end;    var        SustainabilitySetup: Record "Sustainability Setup";        InvalidTypeForSustErr: Label 'Sustainability is only applicable for Type: %1 , %2 , %3 and %4.', Comment = '%1 - Sales Line Type Item, %2 - Sales Line Type G/L Account, %3 - Sales Line Type Resource,, %4 - Sales Line Type Fixed Asset';        NotAllowedToUseSustAccountForWaterOrWasteErr: Label 'It is not allowed to use Sustainability Account %1 for water or waste in Sales document.', Comment = '%1 = Sust. Account No.';}