INCOMPLETE INVOICES REPORT, Add customer name to Report

TICKET 6: INCOMPLETE INVOICES REPORT:
                 Add to more PARAMETERS Complete flag, Customer Name.
WHAT IS: Use this report to review all of your incomplete invoices, debit memos, credit memos, and on-account credits. Incomplete invoices do not update your open receivables balance nor do they display on your agings. 
QUERY:
From hz_parties party,
          ra_customer_trx ct
Where
and party.party_name=nvl(:P_Party_name,party.party_name)
and ct.complete_flag =:P_Complete_Flag 
Added Complete flag, Customer Name in Concurrent Program Parameters
What it is:
Use this report to review all of your incomplete invoices, debit memos, credit memos, and on-account credits. Incomplete invoices do not update your open receivables balance nor do they display on your agings. Use the Transactions window to complete your invoice or debit memo once you have updated them. For credit memos and on-account credits, use the Credit Memos window.
Customization:
Add two parameters Complete flag and Customer name. Depending on complete flag customer name parameter should be enabled or disabled.
Value sets : XXCOMPLETE_FLAG, XXCUSTOMER_SAN
Parameters:
Order by, from invoice num, to Invoice Num etc..
TABLES:
ra_customer_trx ,hz_cust_accounts ,hz_parties ,ra_cust_trx_types,ra_cust_trx_line_gl_dist




Post a Comment