Thursday, January 3, 2019

AR_CASH_RECEIPTS_ALL.STATUS in Oracle APPS


  • The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter.
  • Oracle Receivables concurrently creates records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts. 
  • For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table. 
  • Receivables associates a status with each receipt. These statuses include: 
    • APP for applied
    • UNAPP for unapplied
    • UNID for unidentified
    • NSF for nonsufficient funds
    • REV for reversed receipt and 
    • STOP for stop payment
  • Receivables does not update the status of a receipt from UNAPP to APP until the entire amount of the receipt is either applied or placed on account. 
  • A receipt can have a status of APP even if the entire receipt amount is placed on account.

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...