test demo report1

Description
select 
aps.segment1 vendor_number,
aps.vendor_name,
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
Invoice Date from
aia.creation_date>=:date_from
Date
INvoice Date To
aia.creation_date<:date_to+1
Date