select * from ap_suppliers aps, ap_invoices_all aia where 1=1 and aps.vendor_id=aia.vendor_id |
select * from ap_suppliers aps, ap_invoices_all aia where 1=1 and aps.vendor_id=aia.vendor_id
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Supplier |
aps.vendor_name=:supplier_name | LOV | |
| Invoice Creation Date from |
aia.creation_date>=:date_from | Date | |
| Invoice Creation Date to |
aia.creation_date<:date_to+1 | Date |
Blitz Report™ provides multiple benefits: