Wednesday, March 24, 2010

R12 Account Receivables: Receipt Application Overview

We can apply a receipt against the below canditates,
 1. Credit Memo
 2. Invoice
 3. Related Customer’s Invoice
 4. Deposit
 5. Chargeback
 6. Debit Memo and even open Receipts.
Further we can do three more actions named Refund, Receipt Write-off’s, On Account.
For every application we can find a new record in the table named “AR_RECEIVABLE_APPLICATIONS_ALL” with the application type as “CASH”.

For example,
If Receipt amount = 1500 and got applied against a invoice with amount 500.Then APPLIED_AMOUNT becomes 500 and UNAPPLIED AMOUNT becomes 1000.Further if you want to see the above data from back end use the below query,

SELECT status
             ,SUM(amount_applied)
FROM   ar_receivable_applications_all
WHERE cash_receipt_id = '&cash_receipt_id'
GROUP BY status;

Further we have the below important columns in “AR_RECEIVABLE_APPLICATIONS_ALL” table,
 Payment_schedule_id
,code_combination_id
,apply_date
,applied_customer_trx_id, 

Incase, if the application is at line level then we have the below columns also,
 Rule_set_id
,line_applied
,tax_applied
,applied_customer_trx_line_id
,freight_applied

If you want to know more information about the “RULE_SET_ID” then please check the below tables
AR_APP_RULE_SETS
AR_APP_RULES

This rule_set_id defaulted to each org_id and the corresponding information can be found in the table AR_SYSTEM_PARAMETERS_ALL

0 Responses to “R12 Account Receivables: Receipt Application Overview”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.