MDS Test AP Invoices Due

➜ Back to Library
Description
Select aps.vendor_name, aia.invoice_num, aia.invoice_amount, apsa.due_date, aia.*
from 
ap_suppliers aps, 
ap_invoices_all aia, 
ap_payment_schedules_all apsa
Where 
1 = 1 and 
aps.vendor_id = aia.vendor_id and
aia.invoice_id = apsa.invoice_id
and aia.payment_status_flag = 'N'
Parameter NameSQL textValidation
Supplier
aps.vendor_name=:vendor_name
LOV
Invoice Greater Than
aia.invoice_amount>=:inv_amount
Number
Due Date Before
apsa.due_date<=:min_due_date
Date
Download
Related Blitz Reports
XXSJ Report VAT Register AP Cash Requirement - draft GL MoFU KPI Dashboard Exceptions APL Testing : AP Accounted Invoice Aging RK: AP Invoices and Lines AP Invoice Upload GL Account Distribution Analysis Testing : AP Invoice Payments AP Accounted Invoice Aging TB Accounts Payables Trial Balance - FSSC
Blitz Report™