UK Oracle User Group


Use Autocash and Let the System Do the Heavy Lifting

27 May 2015

To save time you can use the Autocash functionality to have the system apply cash receipts to A/R invoices automatically... find out more...

There are several algorithms available that will apply the cash in different ways:

  • Known Invoice Match With Amount (R03B50D) - Your customer provides you with information to identify a specific invoice, and specifies the amount they want to apply to it.
  • Known Invoice Match Without Amount (R03B50E) - Your customer provides you with information to identify a specific invoice, but does not specify an amount to apply to it.
  • Balance Forward Match (R03B50B) - Your customer does not provide you with any specific information regarding the invoice(s). You apply their receipt(s) to the invoice(s) in sequential order, either the oldest first aka First In First Out (FIFO), or the newest first aka Last In First Out (LIFO).
  • Invoice Selection Match (R03B50A) - Your customer does not provide you with any specific information regarding the invoice(s). The system applies the receipt to a single invoice or a running total based on due date.
  • Combination Invoice Match (R03B50F) - Your customer does not provide you with any specific information regarding the invoice(s). The system applies the receipt to a combination of invoices. You define how many invoices the system selects, in a random order, to find a matching pattern.

 

Here's a summary of the various tasks setting up and processing cash receipts via the Autocash functionality:


Setup:

    1. Determine which algorithm or combination of algorithms you want to use. You can even use different versions of the same algorithm at the same time.
    2. Using Batch Versions set up versions of the chosen algorithm(s) and set the processing options on them as desired.
    3. In Define Execution Lists set up an execution list with the algorithm version(s) in the desired sequence or order.
    4. You can assign this execution list as a default on the customer master records of your clients. You can also put it in the processing options of Update Receipt Header (R03B551) or Apply Receipts to Invoices (R03B50). More on this later.
    5. Determine how you are going to upload the cash records received in a file from your bank into the F03B13Z1. You can use one of these methods:
    6. Set up a version of Update Receipt Header (R03B551).
      1. A custom UBE or process (make sure to check and use the information on how to map the file to the F03B13Z1),
      1. The EDI Lockbox functionality,
      1. The Text File Processor program (P007101)

This UBE will create unapplied cash receipt records (doc type RU) in the Receipt Header (F03B13) and the Receipt Details (F03B14) tables, based on the records in the F03B13Z1. The processing option for Execution List is only used if the field for default Execution List on the Customer Master (F03012) record of the customer is blank.

    1. Set up a version of Apply Receipts to Invoices (R03B50).

This UBE will process the RUs created by R03B551 or manually created RUs or both, and attempt to apply these to existing, open invoices, using the algorithm version(s) specified on the Execution List.

The processing option for Execution List is only used if the Execution List field in the Receipts Header table (F03B13) for the unapplied receipt is blank and the field for default Execution List on the Customer Master (F03012) record of the customer is blank, in that order.

Process:

    1. Upload the receipts into the F03B13Z1.
    2. Run R03B551.
    3. Run R03B50.
    4. Post the resulting batch(es).
    5. Revise any receipts if necessary.


Post the revisions.

 

For more information on setting up and processing cash receipts via the Autocash functionality, have a look at the following knowledge articles:

  • How To Set Up and Map Data for Automatic Receipts In EnterpriseOne Accounts Receivable (Doc ID 1458481.1)
  • How To Process Automatic Receipts (Auto Cash) In EnterpriseOne Accounts Receivable (Doc ID 1458442.1)
  • FAQ - Frequently Asked Questions Regarding Automatic Receipts/Auto Cash (Doc ID 945692.1)
  • Troubleshooting Common Errors on Automatic Receipts/Auto Cash (Doc ID 1988280.1)
  • FAQ - Frequently Asked Questions on A/R Interoperability (Doc ID 945685.1)
Source: JDE EnterpriseOne Support Blog

We'd love to get your feedback on this; you'll need a UKOUG login to provide it, so if you don't have one, please click on 'create a web profile' first.

Top