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

SQL-Applied Receipts

Received Response
2
Views
1
Comments
edited Dec 2, 2021 4:22PM in Receivables & Collections 1 comment

Summary:

Please share with me any SQL-Applied Receipts

Content (required):

Hello

I was trying to do an SQL for applied receipts , however I always get duplicate records and I do not know how to get rid of them, because I got all the history status like remitted, clear and reverse and I just need the latest one.

I am using the following tables and maybe I need to get rid of the ar_cash_receipt_history_all and ar_receivable_applications_all.

Please Advise

ar_receivable_applications_all rcvapp,

ar_payment_schedules_all apsch, 

ar_cash_receipts_all r, 

ar_cash_receipt_history_all h, 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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