Table extension 6264 Sust. FA Journal Line

Sustainability, Microsoft.Sustainability.FixedAssets

src/Apps/W1/Sustainability/app/src/FixedAssets/SustFAJournalLine.TableExt.al125 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sustainability.FixedAssets;using Microsoft.FixedAssets.Journal;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Setup;tableextension 6264 "Sust. FA Journal Line" extends "FA Journal 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                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);                end;            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(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"));            end;        }    }    local procedure ClearEmissionInformation(var FAJournalLine: Record "FA Journal Line")    begin        FAJournalLine.Validate("Total CO2e", 0);    end;    local procedure ValidateEmissionPrerequisite(FAJournalLine: Record "FA Journal Line"; CurrentFieldNo: Integer)    var        SustAccountCategory: Record "Sustain. Account Category";    begin        case CurrentFieldNo of            FAJournalLine.FieldNo("Total CO2e"):                FAJournalLine.TestField("Sust. Account No.");            FAJournalLine.FieldNo("Sust. Account No."),            FAJournalLine.FieldNo("Sust. Account Category"),            FAJournalLine.FieldNo("Sust. Account Subcategory"),            FAJournalLine.FieldNo("Sust. Account Name"):                begin                    FAJournalLine.TestField("FA No.");                    FAJournalLine.TestField("FA Posting Type", FAJournalLine."FA Posting Type"::"Acquisition Cost");                    if SustAccountCategory.Get(FAJournalLine."Sust. Account Category") then                        if SustAccountCategory."Water Intensity" or SustAccountCategory."Waste Intensity" or SustAccountCategory."Discharged Into Water" then                            Error(NotAllowedToUseSustAccountForWaterOrWasteErr, FAJournalLine."Sust. Account No.");                end;        end;    end;    var        SustainabilitySetup: Record "Sustainability Setup";        NotAllowedToUseSustAccountForWaterOrWasteErr: Label 'It is not allowed to use Sustainability Account %1 for water or waste in Sales document.', Comment = '%1 = Sust. Account No.';}