Loading

Thursday, March 4, 2010

Receipt Creation in R12 Account Receivables

Whenever we create a receipt it finds its entry in the below tables 

  1. AR_CASH_RECEIPTS_ALL
  2. AR_CASH_RECEIPT_HISTORY_ALL
  3. AR_RECEIVABLE_APPLICATIONS_ALL with the status = 'UNAPP'
Different Status: 
    1. APP                                                       -- Applied
    2. UNAPP                                               -- Unapplied 
    3. UNID                                                  -- Unidentified 

UNID: - Come when customer is not known
UNAPP: - Come when no application has been done

select cash_receipt_id,status, amount,receipt_method_id
from ar_cash_receipts_All a
where receipt_number = 'TEST06';

select name 
from ar_receipt_methods
where receipt_method_id = 'Receipt method id from previous Query' ;

0 Responses to “Receipt Creation in R12 Account Receivables”

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.