rares repo

➜ Back to Library
Description
this is a simple report
select
aps.vendor_name,
aps.segment1 vendor_number,
aia.*
from
ap_suppliers aps,
ap_invoices_all aia
where
1=1 and
aps.vendor_id=aia.vendor_id
Parameter NameSQL textValidation
Supplier
aps.vendor_name=:vendor_name
LOV
Supplier Number
aps.segment1=:supplier_number
LOV
Invoice Date From
aia.invoice_date>=:invoice_date_from
Date
Invoice Date To
aia.invoice_date<:invoice_date_to+1
Date
Download
Related Blitz Reports
TB GL Account Analysis (Drilldown)v2 COPY OF: AP Accounted Invoice Aging Rares report number 2 AP Intercompany Invoice Details (GST) LSE: INV Material Account Distribution Detail AP Supplier Statement(GST) SAM Training XXSJ Report VAT Register AP Period Close Exceptions (1) AP Invoice Approval Status
Blitz Report™