Report 1409 Posted Payment Reconciliation

Base Application, Microsoft.Bank.Reports

src/Layers/W1/BaseApp/Bank/Reports/PostedPaymentReconciliation.Report.al143 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.Bank.Reports;using Microsoft.Bank.Reconciliation;/// <summary>/// Generates report of completed payment reconciliation transactions with applied amounts./// Displays posted payment reconciliation headers and lines with transaction details and amounts./// </summary>/// <remarks>/// Data Sources: Posted Payment Recon. Hdr, Posted Payment Recon. Line. /// Features: Applied amount tracking, transaction date reporting, document reference display./// Usage: Payment reconciliation audit, transaction verification, compliance reporting, historical analysis./// </remarks>report 1409 "Posted Payment Reconciliation"{    Caption = 'Posted Payment Reconciliation';    WordMergeDataItem = "Posted Payment Recon. Hdr";    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Posted Payment Recon. Hdr"; "Posted Payment Recon. Hdr")        {            DataItemTableView = sorting("Bank Account No.", "Statement No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "Bank Account No.", "Statement No.";            column(ComanyName; COMPANYPROPERTY.DisplayName())            {            }            column(PostedPaymentReconciliationTableCaptFltr; TableCaption + ': ' + PostedPaymentReconciliationFilter)            {            }            column(PostedPaymentReconciliationFilter; PostedPaymentReconciliationFilter)            {            }            column(StmtNo_PostedPaymentReconciliation; "Statement No.")            {                IncludeCaption = true;            }            column(Amt_PostedPaymentReconciliationLineStmt; "Posted Payment Recon. Line"."Statement Amount")            {            }            column(AppliedAmt_PostedPaymentReconciliationLine; "Posted Payment Recon. Line"."Applied Amount")            {            }            column(BankAccNo_PostedPaymentReconciliation; "Bank Account No.")            {            }            column(PostedPaymentReconciliationCapt; PostedPaymentReconciliationCaptLbl)            {            }            column(CurrReportPAGENOCapt; CurrReportPAGENOCaptLbl)            {            }            column(PostedPaymentReconciliationLinTrstnDteCapt; PostedPaymentReconciliationLinTrstnDteCaptLbl)            {            }            column(BnkAcStmtLinValDteCapt; BnkAcStmtLinValDteCaptLbl)            {            }            dataitem("Posted Payment Recon. Line"; "Posted Payment Recon. Line")            {                DataItemLink = "Bank Account No." = field("Bank Account No."), "Statement No." = field("Statement No.");                DataItemTableView = sorting("Bank Account No.", "Statement No.", "Statement Line No.");                column(TrnsctnDte_BnkAcStmtLin; Format("Transaction Date"))                {                }                column(Type_PostedPaymentReconciliationLine; Type)                {                    IncludeCaption = true;                }                column(LineDocNo_PostedPaymentReconciliation; "Document No.")                {                    IncludeCaption = true;                }                column(AppliedEntr_PostedPaymentReconciliationLine; "Applied Entries")                {                    IncludeCaption = true;                }                column(Amt1_PostedPaymentReconciliationLineStmt; "Statement Amount")                {                    IncludeCaption = true;                }                column(AppliedAmt1_PostedPaymentReconciliationLine; "Applied Amount")                {                    IncludeCaption = true;                }                column(Desc_PostedPaymentReconciliationLine; Description)                {                    IncludeCaption = true;                }                column(ValueDate_PostedPaymentReconciliationLine; Format("Value Date"))                {                }            }        }    }    requestpage    {        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Bank/Reports/PostedPaymentReconciliation.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {        TotalCaption = 'Total';    }    trigger OnPreReport()    begin        PostedPaymentReconciliationFilter := "Posted Payment Recon. Hdr".GetFilters();    end;    var        PostedPaymentReconciliationFilter: Text;        PostedPaymentReconciliationCaptLbl: Label 'Posted Payment Reconciliation';        CurrReportPAGENOCaptLbl: Label 'Page';        PostedPaymentReconciliationLinTrstnDteCaptLbl: Label 'Transaction Date';        BnkAcStmtLinValDteCaptLbl: Label 'Value Date';}