Demo of report creation

➜ Back to Library
Description
select
aps.vendor_name,
aps.segment1 vendor_number,
aia.*
from
ap_suppliers aps,
ap_invoices_all aia
where
1=1 and 
aia.vendor_id=aps.vendor_id
Parameter NameSQL textValidation
Supplier
aps.vendor_name=:supplier_name
LOV
Invoice Creation date from
aia.creation_date>=:p_date_from
Date
Invoice Creation Date To
aia.creation_date<:p_date_to+1
Date
Download
Related Blitz Reports
TB GL Account Analysis (Drilldown)v2 Mariia's report FA Cost Adjustments test demo report1 AP 1099 Payments Rares report number 2 LSE: INV Material Account Distribution Detail SAM Training XXSJ Report VAT Register AP Invoice Approval Status
Blitz Report™