Refund Transactions not visible on Receipt Summry Form
Query a Receipt from UI
- Able to see Applied Transaction Lines
- Unable to see Refund Line
Ran Following Query:
select distinct SCE.Amount_applied, SCE.GL_DATE, account_number , application_type , HZ.category_code,SCE.APPLIED_PAYMENT_SCHEDULE_ID, sce.org_id, ps.org_id,
decode(PS.CLASS,'PMT','Receipt','CM','Credit Memo') Type,PS.TRX_NUMBER "Receipt/CM number"
from AR_RECEIVABLE_APPLICATIONS_ALL SCE ,HZ_PARTIES HZ , HZ_CUST_ACCOUNTS CUST , AR_PAYMENT_SCHEDULES_ALL PS
where
SCE.APPLIED_PAYMENT_SCHEDULE_ID = -8
SCE.DISPLAY='Y'
and SCE.GL_DATE between '01-SEP-2018' and '30-SEP-2019'