Table extension 6224 Sust. Gen. Journal Line

Sustainability, Microsoft.Sustainability.Journal

src/Apps/W1/Sustainability/app/src/Journal/SustGenJournalLine.TableExt.al221 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Journal;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Foundation.AuditCodes;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Setup;tableextension 6224 "Sust. Gen. Journal Line" extends "Gen. Journal Line"{    fields    {        field(6214; "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;                Rec.CreateDimFromDefaultDim(FieldNo(Rec."Sust. Account No."));            end;        }        field(6215; "Sust. Account Name"; Text[100])        {            Caption = 'Sustainability Account Name';            DataClassification = CustomerContent;        }        field(6216; "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(6217; "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(6218; "Total Emission CO2"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Total Emission CO2';            CaptionClass = '102,12,1';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Total Emission CO2" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Total Emission CO2"));            end;        }        field(6219; "Total Emission CH4"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Total Emission CH4';            CaptionClass = '102,12,2';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Total Emission CH4" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Total Emission CH4"));            end;        }        field(6220; "Total Emission N2O"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Total Emission N2O';            CaptionClass = '102,12,3';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Total Emission N2O" <> 0 then                    ValidateEmissionPrerequisite(Rec, Rec.FieldNo("Total Emission N2O"));            end;        }        field(6221; "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(6222; "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;        }    }    local procedure ClearEmissionInformation(var GenJournalLine: Record "Gen. Journal Line")    begin        GenJournalLine.Validate("Total Emission CO2", 0);        GenJournalLine.Validate("Total Emission CH4", 0);        GenJournalLine.Validate("Total Emission N2O", 0);        GenJournalLine.Validate("CO2e per Unit", 0);    end;    local procedure ValidateEmissionPrerequisite(GenJournalLine: Record "Gen. Journal Line"; CurrentFieldNo: Integer)    begin        case CurrentFieldNo of            GenJournalLine.FieldNo("Total Emission N2O"),            GenJournalLine.FieldNo("Total Emission CH4"),            GenJournalLine.FieldNo("Total Emission CO2"):                GenJournalLine.TestField("Sust. Account No.");            GenJournalLine.FieldNo("CO2e per Unit"),            GenJournalLine.FieldNo("Total CO2e"):                begin                    if not GenJournalLine.IsSourceFixedAssetGLJournal() then                        GenJournalLine.TestField("Job No.");                    GenJournalLine.TestField("Sust. Account No.");                end;            GenJournalLine.FieldNo("Sust. Account No."):                CheckSustGenJournalLine(GenJournalLine);        end;    end;    procedure CheckSustGenJournalLine(GenJournalLine: Record "Gen. Journal Line")    begin        if (GenJournalLine."Document Type" in [GenJournalLine."Document Type"::" ", GenJournalLine."Document Type"::Invoice, GenJournalLine."Document Type"::"Credit Memo"]) then            GenJournalLine.TestField("Sust. Account No.")        else            Error(InvalidDocumentTypeErr, GenJournalLine."Journal Template Name", GenJournalLine."Journal Batch Name", GenJournalLine."Line No.");    end;    procedure UpdateSustainabilityEmission(var GenJournalLine: Record "Gen. Journal Line")    begin        GenJournalLine."Total CO2e" := GenJournalLine."CO2e per Unit" * GenJournalLine."Job Quantity";    end;    procedure UpdateEmissionPerUnit(var GenJournalLine: Record "Gen. Journal Line")    var        Denominator: Decimal;    begin        GenJournalLine."CO2e Per Unit" := 0;        if (GenJournalLine."Job Quantity" = 0) then            exit;        Denominator := GenJournalLine."Job Quantity";        if GenJournalLine."Total CO2e" <> 0 then            GenJournalLine."CO2e per Unit" := GenJournalLine."Total CO2e" / Denominator;    end;    internal procedure IsSourceFixedAssetGLJournal(): Boolean    var        SourceCodeSetup: Record "Source Code Setup";    begin        SourceCodeSetup.SetLoadFields("Fixed Asset G/L Journal");        SourceCodeSetup.Get();        exit(Rec."Source Code" = SourceCodeSetup."Fixed Asset G/L Journal");    end;    var        SustainabilitySetup: Record "Sustainability Setup";        InvalidDocumentTypeErr: Label 'You can only specify Sustainability Accounts for lines of type blank, invoice and credit memo for Journal Template Name=%1 ,Journal Batch Name=%2 ,Line No.=%3.', Comment = '%1 = Journal Template Name , %2 = Journal Batch Name , %3 = Line No.';}