Report 319 Payments on Hold

Base Application, Microsoft.Purchases.Reports

src/Layers/W1/BaseApp/Purchases/Reports/PaymentsonHold.Report.al159 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN28// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Purchases.Reports;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;report 319 "Payments on Hold"{    ApplicationArea = Basic, Suite;    Caption = 'Payments on Hold (Obsolete)';    UsageCategory = ReportsAndAnalysis;    ObsoleteState = Pending;    ObsoleteReason = 'This report is obsolete and will be removed in a future release. See the documentation for alternative options.';    ObsoleteTag = '28.0';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Vendor Ledger Entry"; "Vendor Ledger Entry")        {            DataItemTableView = sorting("Vendor No.", Open, Positive, "Due Date") where(Open = const(true), "On Hold" = filter(<> ''));            RequestFilterFields = "Due Date";            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(Vendor_Ledger_Entry__TABLECAPTION__________VendLedgEntryFilter; TableCaption + ': ' + VendLedgEntryFilter)            {            }            column(VendLedgEntryFilter; VendLedgEntryFilter)            {            }            column(Vendor_Ledger_Entry__Due_Date_; Format("Due Date"))            {            }            column(Vendor_Ledger_Entry__Posting_Date_; Format("Posting Date"))            {            }            column(Vendor_Ledger_Entry__Document_Type_; "Document Type")            {            }            column(Vendor_Ledger_Entry__Document_No__; "Document No.")            {            }            column(Vendor_Ledger_Entry_Description; Description)            {            }            column(Vendor_Ledger_Entry__Vendor_No__; "Vendor No.")            {            }            column(Vend_Name; Vend.Name)            {            }            column(Vendor_Ledger_Entry__Remaining_Amount_; "Remaining Amount")            {            }            column(Vendor_Ledger_Entry__Currency_Code_; "Currency Code")            {            }            column(Vendor_Ledger_Entry__On_Hold_; "On Hold")            {            }            column(Vendor_Ledger_Entry__Remaining_Amt___LCY__; "Remaining Amt. (LCY)")            {            }            column(Payments_on_HoldCaption; Payments_on_HoldCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Vendor_Ledger_Entry__Due_Date_Caption; Vendor_Ledger_Entry__Due_Date_CaptionLbl)            {            }            column(Vendor_Ledger_Entry__Posting_Date_Caption; Vendor_Ledger_Entry__Posting_Date_CaptionLbl)            {            }            column(Vendor_Ledger_Entry__Document_Type_Caption; Vendor_Ledger_Entry__Document_Type_CaptionLbl)            {            }            column(Vendor_Ledger_Entry__Document_No__Caption; FieldCaption("Document No."))            {            }            column(Vendor_Ledger_Entry_DescriptionCaption; FieldCaption(Description))            {            }            column(Vendor_Ledger_Entry__Vendor_No__Caption; FieldCaption("Vendor No."))            {            }            column(Vend_NameCaption; Vend_NameCaptionLbl)            {            }            column(Vendor_Ledger_Entry__Remaining_Amount_Caption; FieldCaption("Remaining Amount"))            {            }            column(Vendor_Ledger_Entry__On_Hold_Caption; FieldCaption("On Hold"))            {            }            column(Vendor_Ledger_Entry__Remaining_Amt___LCY__Caption; Vendor_Ledger_Entry__Remaining_Amt___LCY__CaptionLbl)            {            }            trigger OnAfterGetRecord()            begin                CalcFields("Remaining Amt. (LCY)");                Vend.Get("Vendor No.");            end;        }    }    requestpage    {        AboutTitle = 'About Payments on Hold (Obsolete)';        AboutText = 'Print a checklist of all vendor ledger entries where the invoice is in dispute and the On Hold field isn''''t blank.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.';        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Purchases/Reports/PaymentsonHold.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        VendLedgEntryFilter := "Vendor Ledger Entry".GetFilters();    end;    var        Vend: Record Vendor;        VendLedgEntryFilter: Text;        Payments_on_HoldCaptionLbl: Label 'Payments on Hold';        CurrReport_PAGENOCaptionLbl: Label 'Page';        Vendor_Ledger_Entry__Due_Date_CaptionLbl: Label 'Due Date';        Vendor_Ledger_Entry__Posting_Date_CaptionLbl: Label 'Posting Date';        Vendor_Ledger_Entry__Document_Type_CaptionLbl: Label 'Document Type';        Vend_NameCaptionLbl: Label 'Name';        Vendor_Ledger_Entry__Remaining_Amt___LCY__CaptionLbl: Label 'Total (LCY)';}#endif