Page 116 G/L Registers
src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/GLRegisters.Page.al498 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.Finance.GeneralLedger.Ledger;using Microsoft.Bank.Ledger;using Microsoft.Bank.Reconciliation;using Microsoft.Finance.Dimension.Correction;using Microsoft.Finance.GeneralLedger.Reports;using Microsoft.Finance.GeneralLedger.Reversal;using Microsoft.Finance.VAT.Ledger;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Maintenance;using Microsoft.Foundation.AuditCodes;using Microsoft.HumanResources.Payables;using Microsoft.Inventory.Ledger;using System.Security.User;/// <summary>/// Displays G/L registers with navigation to related ledger entries and reporting capabilities./// Provides drill-down access to G/L entries, VAT entries, and other related ledger records by register./// </summary>/// <remarks>/// Primary data source: G/L Register table. Read-only list showing posting batch information./// Navigation: G/L entries, customer/vendor ledger entries, VAT entries, fixed asset entries./// Actions: Navigate, reverse entries, print reports, dimension corrections./// </remarks>page 116 "G/L Registers"{ AdditionalSearchTerms = 'general ledger registers'; ApplicationArea = Basic, Suite; Caption = 'G/L Registers'; Editable = false; PageType = List; AboutTitle = 'About G/L Registers'; AboutText = 'Review posted general ledger transactions, track posting details such as user and source, and access related entry information for audit, reconciliation, and financial analysis purposes.'; SourceTable = "G/L Register"; SourceTableView = sorting("No.") order(descending); UsageCategory = History; layout { area(content) { repeater(Control1) { ShowCaption = false; field("No."; Rec."No.") { ApplicationArea = Basic, Suite; } /// <summary> /// The Creation Date field has been replaced with the SystemCreateAt field but needs to be kept for historical audit purposes. /// </summary> field("Creation Date"; Rec."Creation Date") { ApplicationArea = Basic, Suite; Visible = false; } /// <summary> /// The Creation Time field has been replaced with the SystemCreateAt field but needs to be kept for historical audit purposes. /// </summary> field("Creation Time"; Rec."Creation Time") { ApplicationArea = Basic, Suite; Visible = false; } field(SystemCreatedAt; Rec.SystemCreatedAt) { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the date and time when the entries in the register were posted.'; } field("User ID"; Rec."User ID") { ApplicationArea = Basic, Suite; trigger OnDrillDown() var UserMgt: Codeunit "User Management"; begin UserMgt.DisplayUserInformation(Rec."User ID"); end; } field("Source Code"; Rec."Source Code") { ApplicationArea = Basic, Suite; } field("Journal Batch Name"; Rec."Journal Batch Name") { ApplicationArea = Basic, Suite; } field(Reversed; Rec.Reversed) { ApplicationArea = Suite; Visible = false; } field("From Entry No."; Rec."From Entry No.") { ApplicationArea = Basic, Suite; } field("To Entry No."; Rec."To Entry No.") { ApplicationArea = Basic, Suite; } field("From VAT Entry No."; Rec."From VAT Entry No.") { ApplicationArea = Basic, Suite; } field("To VAT Entry No."; Rec."To VAT Entry No.") { ApplicationArea = Basic, Suite; } field("No. of Transactions"; Rec."No. of Transactions") { ApplicationArea = Basic, Suite; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(navigation) { group("&Register") { Caption = '&Register'; Image = Register; action("General Ledger") { ApplicationArea = Basic, Suite; Caption = 'General Ledger'; Image = GLRegisters; RunObject = Codeunit "G/L Reg.-Gen. Ledger"; ToolTip = 'View the general ledger entries that resulted in the current register entry.'; } action("Customer &Ledger") { ApplicationArea = Basic, Suite; Caption = 'Customer &Ledger'; Image = CustomerLedger; RunObject = Codeunit "G/L Reg.-Cust.Ledger"; ToolTip = 'View the customer ledger entries that resulted in the current register entry.'; } action("Ven&dor Ledger") { ApplicationArea = Basic, Suite; Caption = 'Ven&dor Ledger'; Image = VendorLedger; RunObject = Codeunit "G/L Reg.-Vend.Ledger"; ToolTip = 'View the vendor ledger entries that resulted in the current register entry.'; } action("Bank Account Ledger") { ApplicationArea = Basic, Suite; Caption = 'Bank Account Ledger'; Image = BankAccountLedger; RunObject = Codeunit "G/L Reg.-Bank Account Ledger"; ToolTip = 'View the bank account ledger entries that resulted in the current register entry.'; } action("Fixed &Asset Ledger") { ApplicationArea = FixedAssets; Caption = 'Fixed &Asset Ledger'; Image = FixedAssetLedger; RunObject = Codeunit "G/L Reg.-FALedger"; ToolTip = 'View registers that involve fixed assets.'; } action("Maintenance Ledger") { ApplicationArea = FixedAssets; Caption = 'Maintenance Ledger'; Image = MaintenanceLedgerEntries; RunObject = Codeunit "G/L Reg.-Maint.Ledger"; ToolTip = 'View the maintenance ledger entries for the selected fixed asset.'; } action("VAT Entries") { ApplicationArea = Basic, Suite; Caption = 'VAT Entries'; Image = VATLedger; RunObject = Codeunit "G/L Reg.-VAT Entries"; ToolTip = 'View the VAT entries that are associated with the current register entry.'; } action("Employee Ledger") { ApplicationArea = Basic, Suite; Caption = 'Employee Ledger'; Image = EmployeeAgreement; ToolTip = 'View the employee ledger entries that resulted in the register entry.'; trigger OnAction() var EmployeeLedgerEntry: Record "Employee Ledger Entry"; begin EmployeeLedgerEntry.SetRange("Entry No.", Rec."From Entry No.", Rec."To Entry No."); PAGE.Run(PAGE::"Employee Ledger Entries", EmployeeLedgerEntry); end; } action("Item Ledger Relation") { ApplicationArea = Suite; Caption = 'Item Ledger Relation'; Image = ItemLedger; RunObject = Page "G/L - Item Ledger Relation"; RunPageLink = "G/L Register No." = field("No."); RunPageView = sorting("G/L Register No."); ToolTip = 'View the link between the general ledger entries and the value entries.'; } action("Transactions") { ApplicationArea = Basic, Suite; Caption = 'Transactions'; Image = GLRegisters; RunObject = Page "G/L Transactions"; RunPageLink = "G/L Register No." = field("No."); ToolTip = 'View the general ledger transactions that resulted in the current register entry.'; } action("Update Registers") { ApplicationArea = All; Caption = 'Update Registers'; Image = Refresh; ToolTip = 'Update the register information for the selected register entry. Use this action if you have enabled concurrent posting to create G/L transaction records and update G/L Register No. in ledger entries.'; trigger OnAction() var GLRegister: Record "G/L Register"; begin CurrPage.SetSelectionFilter(GLRegister); if GLRegister.FindFirst() then repeat GLRegister.UpdateGLEntriesWithRegisterNo(); until GLRegister.Next() = 0; CurrPage.Update(); end; } action(ChangeDimensions) { ApplicationArea = All; Image = ChangeDimensions; Caption = 'Correct Dimensions'; ToolTip = 'Correct dimensions for the related general ledger entries.'; trigger OnAction() var GLRegsiter: Record "G/L Register"; DimensionCorrection: Record "Dimension Correction"; DimensionCorrectionMgt: Codeunit "Dimension Correction Mgt"; begin CurrPage.SetSelectionFilter(GLRegsiter); DimensionCorrectionMgt.CreateCorrectionFromGLRegister(GLRegsiter, DimensionCorrection); Page.Run(PAGE::"Dimension Correction Draft", DimensionCorrection); end; } } } area(processing) { group(Reverse) { Caption = 'Reverse'; Image = "ReverseRegister"; action(ReverseRegister) { ApplicationArea = Basic, Suite; Caption = 'Reverse Register'; Ellipsis = true; Image = ReverseRegister; ToolTip = 'Undo entries that were incorrectly posted. You can only reverse entries that were posted from a journal and have not already been involved in a reversal.'; Enabled = ReverseRegisterEnabled; trigger OnAction() var ReversalEntry: Record "Reversal Entry"; PostedPaymentReconHdr: Record "Posted Payment Recon. Hdr"; ReversePaymentRecJournal: Codeunit "Reverse Payment Rec. Journal"; begin if GetPostedPaymentReconHdr(Rec, PostedPaymentReconHdr) then begin if not PostedPaymentReconHdr."Is Reversed" then ReversePaymentRecJournal.RunReversalWizard(PostedPaymentReconHdr) else Error(PaymentRecJournalAlreadyReversedMsg); exit; end; Rec.TestField("No."); ReversalEntry.ReverseRegister(Rec."No."); end; } } group("F&unctions") { Caption = 'F&unctions'; Image = "Action"; action("Delete Empty Registers") { ApplicationArea = All; Caption = 'Delete Empty Registers'; Image = Delete; RunObject = Report "Delete Empty G/L Registers"; ToolTip = 'Find and delete empty G/L registers.'; } } } area(reporting) { action("Detail Trial Balance") { ApplicationArea = Basic, Suite; Caption = 'Detail Trial Balance'; Image = "Report"; RunObject = Report "Detail Trial Balance"; ToolTip = 'Print or save a detail trial balance for the general ledger accounts that you specify.'; }#if not CLEAN28 action("Trial Balance") { ApplicationArea = Suite; Caption = 'Trial Balance (Obsolete)'; Image = "Report"; //The property 'PromotedCategory' can only be set if the property 'Promoted' is set to 'true' //PromotedCategory = "Report"; RunObject = Report "Trial Balance"; ToolTip = 'Print or save the chart of accounts that have balances and net changes.'; ObsoleteState = Pending; ObsoleteReason = 'This report has been replaced by the report Trial Balance (Excel). This report will be removed in a future release.'; ObsoleteTag = '28.0'; }#endif action("Trial Balance by Period") { ApplicationArea = Basic, Suite; Caption = 'Trial Balance by Period'; Image = "Report"; RunObject = Report "Trial Balance by Period"; ToolTip = 'Print or save the opening balance by general ledger account, the movements in the selected period of month, quarter, or year, and the resulting closing balance.'; } action("G/L Register") { ApplicationArea = Suite; Caption = 'G/L Register'; Image = "Report"; RunObject = Report "G/L Register"; ToolTip = 'View posted G/L entries.'; } } area(Promoted) { group(Category_Process) { Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.'; actionref("General Ledger_Promoted"; "General Ledger") { } actionref("Customer &Ledger_Promoted"; "Customer &Ledger") { } actionref("Ven&dor Ledger_Promoted"; "Ven&dor Ledger") { } actionref("Employee Ledger_Promoted"; "Employee Ledger") { } actionref("Bank Account Ledger_Promoted"; "Bank Account Ledger") { } actionref("Fixed &Asset Ledger_Promoted"; "Fixed &Asset Ledger") { } actionref("Maintenance Ledger_Promoted"; "Maintenance Ledger") { } actionref("VAT Entries_Promoted"; "VAT Entries") { } } group(Category_Report) { Caption = 'Report', Comment = 'Generated from the PromotedActionCategories property index 2.'; actionref("Detail Trial Balance_Promoted"; "Detail Trial Balance") { } actionref("Trial Balance by Period_Promoted"; "Trial Balance by Period") { } actionref("G/L Register_Promoted"; "G/L Register") { } } group(Category_Category4) { Caption = 'Reverse', Comment = 'Generated from the PromotedActionCategories property index 3.'; actionref(ReverseRegister_Promoted; ReverseRegister) { } actionref(ChangeDimensions_Promoted; ChangeDimensions) { } } } } analysisviews { analysisview("GL Entries By Source") { Caption = 'GL entries by source'; DefinitionFile = './Finance/GeneralLedger/Ledger/GLEntriesBySource.analysis.json'; ToolTip = 'Get an overview of the types of transactions that happen to your general ledger and the types of sources for them.'; } } var PaymentRecJournalAlreadyReversedMsg: Label 'This Payment Reconciliation Journal has already been reversed.'; trigger OnOpenPage() begin if Rec.FindSet() then; end; trigger OnAfterGetRecord() begin ReverseRegisterEnabled := GetReverseRegisterEnabled(); end; local procedure GetReverseRegisterEnabled(): Boolean var PostedPaymentReconHdr: Record "Posted Payment Recon. Hdr"; IsHandled: Boolean; ReverseEnabled: Boolean; begin IsHandled := false; OnBeforeGetReverseRegisterEnabled(Rec."No.", ReverseEnabled, IsHandled); if IsHandled then exit(ReverseEnabled); if Rec.Reversed then exit(false); if Rec."Journal Batch Name" <> '' then exit(true); exit(GetPostedPaymentReconHdr(Rec, PostedPaymentReconHdr)); end; local procedure GetPostedPaymentReconHdr(var GLRegister: Record "G/L Register"; var PostedPaymentReconHdr: Record "Posted Payment Recon. Hdr"): Boolean var SourceCodeSetup: Record "Source Code Setup"; BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; begin if not SourceCodeSetup.Get() then exit(false); if GLRegister."Source Code" <> SourceCodeSetup."Payment Reconciliation Journal" then exit(false); BankAccountLedgerEntry.SetRange("Entry No.", GLRegister."From Entry No.", GLRegister."To Entry No."); if not BankAccountLedgerEntry.FindFirst() then exit(false); if (BankAccountLedgerEntry."Bank Account No." = '') or (BankAccountLedgerEntry."Statement No." = '') then exit(false); exit(PostedPaymentReconHdr.Get(BankAccountLedgerEntry."Bank Account No.", BankAccountLedgerEntry."Statement No.")); end; var ReverseRegisterEnabled: Boolean; /// <summary> /// Integration event raised before determining if reverse register functionality is enabled. /// </summary> /// <param name="RegisterNo">G/L register number being checked.</param> /// <param name="ReverseEnabled">Boolean indicating if reverse functionality should be enabled.</param> /// <param name="IsHandled">Boolean indicating if the check has been handled by the subscriber.</param> [IntegrationEvent(false, false)] local procedure OnBeforeGetReverseRegisterEnabled(RegisterNo: Integer; var ReverseEnabled: Boolean; var IsHandled: Boolean) begin end;}