COPY OF: AR Past Due Invoice (2)

➜ Back to Library
Description
Detail past due AR invoice report with invoice number, days past due, amount past due and currency code

When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CESS Amount, CGST Amount, Custom Amount, IGST Amount, SGST Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CESS Rate, CGST Rate, IGST Rate, SGST Rate, CGST Non ...  Detail past due AR invoice report with invoice number, days past due, amount past due and currency code

When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CESS Amount, CGST Amount, Custom Amount, IGST Amount, SGST Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CESS Rate, CGST Rate, IGST Rate, SGST Rate, CGST Non-Recoverable, CGST Recoverable, IGST Non-Recoverable, IGST Recoverable, SGST Non-Recoverable, SGST Recoverable, Reverse Charge Flag.   more 
select
haouv.name operating_unit,
apsa.invoice_currency_code currency,
hp.party_name customer_name,
hca.account_number,
apsa.trx_number invoice_number,
xxen_util.meaning(apsa.class,'INV/CM/ADJ',222) class,
rctta.name invoice_type,
rcta.purchase_order,
apsa.trx_date invoice_date,
apsa.due_date,
apsa.amount_due_original invoice_amount,
apsa.tax_original tax_amount,
apsa.balance_due,
apsa.days_past_due,
ac.name collector,
rs.name salesperson,
xxen_util.user_name(rcta.created_by) created_by,
xxen_util.client_time(rcta.creation_date) creation_date,
xxen_util.user_name(rcta.last_updated_by) last_updated_by,
xxen_util.client_time(rcta.last_update_date) last_update_date
&il_reg_columns
&il_columns_amt
&il_columns_rate
&il_columns_rec
&il_columns_tp
from
hr_all_organization_units_vl haouv,
(select arpt_sql_func_util.get_balance_due_as_of_date(apsa.payment_schedule_id,:p_as_of_date,apsa.class) balance_due, :p_as_of_date-trunc(apsa.due_date) days_past_due, apsa.* from ar_payment_schedules_all apsa where apsa.actual_date_closed>:p_as_of_date and apsa.due_date<=:p_as_of_date) apsa,
ra_customer_trx_all rcta,
ra_cust_trx_types_all rctta,
hz_cust_accounts hca,
hz_parties hp,
ra_salesreps rs,
hz_customer_profiles hcp,
hz_customer_profiles hcp1,
ar_collectors ac
&il_from
where
1=1 and
apsa.balance_due<>0 and
haouv.organization_id=apsa.org_id and
apsa.customer_trx_id=rcta.customer_trx_id and
rcta.cust_trx_type_id=rctta.cust_trx_type_id and
rcta.org_id=rctta.org_id and
rcta.bill_to_customer_id=hca.cust_account_id and
hca.party_id=hp.party_id and
rcta.primary_salesrep_id=rs.salesrep_id(+) and
rcta.org_id=rs.org_id(+) and
hca.cust_account_id=hcp.cust_account_id and
hcp.site_use_id is null and
apsa.customer_site_use_id=hcp1.site_use_id(+) and
nvl(hcp1.collector_id, hcp.collector_id)=ac.collector_id
&il_where
order by
decode(:p_order_by,'Salesperson',rs.name,'Customer',hp.party_name),
decode(:p_order_by,'Balance Due',apsa.balance_due,0)
Parameter NameSQL textValidation
Operating Unit
haouv.name=:operating_unit
LOV
Order By
 
LOV Oracle
As of Date
 
Date
Days Late Low
apsa.days_past_due>=:p_past_days_due_low
Number
Days Late High
apsa.days_past_due<=:p_past_days_due_high
Number
Balance Due Low
apsa.balance_due>=:p_amount_low
Number
Balance Due High
apsa.balance_due<=:p_amount_high
Number
Collector
ac.name=:p_collector
LOV Oracle
Customer Name
hp.party_name=:customer_name
LOV
Exclude Customer Name
hp.party_name<>:customer_name_exclude
LOV
Customer Number
hca.account_number=:customer_number
LOV
Type Low
rctta.name=:invoice_type
LOV
Salesperson/Agent Low
rs.name=:salesrep
LOV
Download
Related Blitz Reports
AR Aging AR Aging - SLA Account COPY OF: AR Aging AR Past Due Invoice SDS AR Aging with document currency amounts COPY OF: AR Past Due Invoice (1) SAM: AR Past Due Invoice (6) Galana AR Aging COPY OF: AR Past Due Invoice
Blitz Report™