When a cash receipt is created , sooner or later the Cash receipt will be applied to an open AR transaction in the system.
In this post we will discuss the entries in the table and how are the records affected during this process.
1. Receipt Creation : When cash receipt is created entry will be made in the system in the tables
AR_CASH_RECEIPTS_ALL --> storing details of the Cash receipt
AR_CASH_RECEIPT_HISTORY_AL --> Detail of the changes made to the receipt which need tracking Eg : Creation , reversal etc
AR_RECEIVABLE_APPLICATIONS_ALL --> Detail of the RECEIPT creation record with STATUS = UNAPP , Amount_applied as the Receipt amount
2. Receipt Application : When the Cashe Receipt is applied to an AR transaction the open amount of the Receipt and the Ar invoice will decrease. Entry is made into the table AR_RECEIVABLE_APPLICATIONS_ALL with 2 records .one with Status = UNAPP and a negative amount of the amount applied debiting the acutal account affected when the receipt was created , since the Open balance in the account decreases.
Another entry is made with status = APP , Amount_applied is the actual amount applied to the receipt and the column applied_customer_trx_id , applied_payment_schedule_id all get populated with the details of the AR Invoice which has been impacted. In the relevant columns the split of LINE and TAX amount is also visible.
Eg : Receipt crearted for amount : 100
entry is made in table AR_RECEIVABLE_APPLICATIONS_ALL with amount : 100 , STAUS = UNAPP
60 is applied to a transaction
2 entries are made in the table : AR_RECEIVABLE_APPLICATIONS_ALL
1. Amount : -60 , status = UNAPP debiting the actual account
2. Amount : 60 , status = APP , Crediting the receivale Account and also storing the details of the affected invoice in the columns applied_customer_trx_id , applied_payment_schedule_id.
Depending on the Receipt method used and the Receipt method Setup , If the receipt is fully applied the status will be remitted or cleared
If Receipt is using a receipt method with Setup : By Matching and receipt is fully applied the status will be remitted . Once the receipt is matched with Bank statement the status will be cleared.
