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

Question
58
Views
0
Comments

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!