Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

query for receivables receipts

I wrote the query of receipts, but I need the receipt date, I think it's in the table AR_CASH_RECEIPT_ALL but I don't know how to join with the others. Can anyone help me complete it with the "receipt_date"?

select

CTL.REVENUE_AMOUNT,

APS.AMOUNT_DUE_REMAINING,

APS.AMOUNT_APPLIED AS Incassato, 

APS.GL_DATE,

APS.TAX_ORIGINAL,

RCTA.TRX_NUMBER,

(CTL.REVENUE_AMOUNT - APS.TAX_ORIGINAL) AS imponibile

FROM 

AR_PAYMENT_SCHEDULES_ALL APS,

ra_customer_trx_all RCTA,

ra_customer_trx_lines_all CTL

WHERE 1=1

AND

RCTA.CUSTOMER_TRX_ID=CTL.CUSTOMER_TRX_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!