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

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)