Report 1409 Posted Payment Reconciliation

// ------------------------------------------------------------------------------------------------
// 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';
}