My Oracle Support Banner

E1: 03B: How To Process Automatic Receipts (Auto Cash) and Troubleshooting Tips (R03B551, P03B121, P03B124, R03B50, R03B0041A) (Doc ID 1458442.1)

Last updated on FEBRUARY 11, 2019

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

Immediate recognition of cash received is an essential part of the accounts receivable process. To ensure early cash recognition, you can process receipts automatically to quickly apply payments from customers to their invoices. This method of processing receipts enables you to:

Prior to processing receipts automatically, you need to perform the set up tasks described  in <Document 1458481.1> E1: 03B: Automatic Receipt Set Up in EnterpriseOne Accounts Receivable (P03B50, P03B52, R03B50A, R03B50B, R03B50D, R03B50E, R03B50F). Once the set up tasks are complete, you can then process automatic receipts. Automatic receipts processing consists of the following tasks:

  1. Upload customer payment information. A custom program, EDI lockbox program, or the Text File Processor program (P007101) can be used to transfer receipt information from a customer’s bank media to the Electronic Receipts Input table (F03B13Z1) for processing.
  2. Create receipt records automatically. A batch program, Update Receipts Header (R03B551), can be run to extract receipt information from the Electronic Receipts Input table (F03B13Z1) and creates either unapplied or logged receipt records in the Receipts Header (F03B13) and Receipts Detail (F03B14) tables.
  3. Apply receipts to invoices automatically. A batch program, Apply Receipts to Invoices (R03B50), can be run to automatically apply the receipts to the open invoices using algorithms that were defined in a set up procedure.
  4. Review, revise, and add electronic receipts. You can review and revise the receipts that the system was unable to process successfully so that you can reprocess them successfully later. If necessary, you can also add electronic receipts.
  5. Purge electronic receipts. Electronic receipts can be purged from the Electronic Receipts Input table (F03B13Z1) after processing the receipts successfully. This batch process improves processing time by removing unnecessary records.

Additionally, you can manually apply receipts to invoices and run reports to review deposits and transactions.

This document discusses how to use automatic receipt processing and how to purge electronic receipt records within Oracle JD Edwards EnterpriseOne Accounts Receivable.

Scope

 This document is intended for users who are setting up or using the Automatic Receipt process in the EnterpriseOne Accounts Receivable module

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Overview
Scope
Details
 Step 1: Upload Customer Payment Information
 Step 2: Update Receipts Header (R03B551)
 Setting Processing Options for Update Receipts Header (R03B551)
 Step 3: Apply Receipts to Invoices (R03B50)
 Setting Processing Options for Apply Receipts to Invoices (R03B50)
 Applying Receipts Generated in a Prior Period
 Applying Receipts to Invoices with Multiple Pay Items, Including Credit Memos
 Step 4: Review, Revise and Reprocess
 Steps to Add a Receipt Manually:
 Unsuccessful (Unapplied) Receipts
 Overriding the Customer Number
 Deleting Electronic Receipts
 Changing the Upload Status of a Batch
 Applying Electronic Receipts to Invoices Manually
 Report Options
 Step 5: Purge Electronic Receipts (R03B0041A)
 Setting the processing options for Purge Electronic Receipts (R03B0041A)
 Troubleshooting Tips
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.