Table extension 6264 Sust. FA Journal Line
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.';}