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' ;

1 Responses to “Receipt Creation in R12 Account Receivables”

malini said...
January 8, 2021 at 3:45 AM

a recipt number has been created. When query the database, it is available on the ar_cash_receipts_All but it is not found in the EBS R12 form. What can be the reason.


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.