Thursday, March 4, 2010
Receipt Creation in R12 Account Receivables
Whenever we create a receipt it finds its entry in the below tables
- AR_CASH_RECEIPTS_ALL
- AR_CASH_RECEIPT_HISTORY_ALL
- AR_RECEIVABLE_APPLICATIONS_ALL with the status = 'UNAPP'
Different Status:
1. APP -- Applied
2. UNAPP -- Unapplied 1. APP -- Applied
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' ;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
1 Responses to “Receipt Creation in R12 Account Receivables”
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