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=:vendor_name | LOV | |
| Invoice Creation date From |
aia.creation_date>=:date_from | Date |
Blitz Report™ provides multiple benefits: