Report 319 Payments on Hold, source in 29
Source29
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