Reports 2017-11-18T12:27:27+00:00

AR Customers and Accounts

Description
Categories: Enginatics, Financials
Basic example report combining parties and customer accounts

select
hp.party_name customer_name,
hp.party_type,
hca.account_number
from
hz_parties hp,
hz_cust_accounts hca
where
1=1 and
hp.party_id=hca.party_id

Parameter Name SQL text Validation
Customer Name
upper(hp.party_name) like upper(:customer_name)
LOV
Account Number
hca.account_number=:account_number
LOV