2

Accounts Receivable Cash Receipt / Debit Upload – Epicor ERP Custom Software Solution

  • 28 February 2013
  • cre8
  • 2 comment
Categories: Epicor

Standard Epicor Software does not allow automatic creation of Cash Receipts Groups for A/R Cash Receipts and Debits to be applied to. If large amount of Receipts and Debits need to be applied to different invoices, adding them manually can seriously impact productivity. A custom software solution was created to automate this process by importing data from a csv (comma separated values) file. A Service Connect workflow was created which sorts, validates, and processes the data from such file:

CashReceipt_001

(An example CSV file viewed in Excel)

 

The data is processed and stored in different UD fields. Customer ID is queried from the posted Invoice, if we verify the Invoice in question in Epicor Software, we can see the customer is ‘ADDISON’. This is stored in UD10.Key4:

CashReceipt_002

In order to make group creation more efficient, several records in the UD table are sorted so that certain information that entries in the csv have in common, are used to create a single posting group where Company ID, Apply Date, Bank Account, and Payment Method are the same:

CashReceipt_003

In this case, the first two rows will be included in a group. The third and fourth rows will be in separate groups.

 CashReceipt_004

CashReceipt_005

If a group or Customer ID has a validation error, a record (including all values in the UD table for each debit) is saved in an error log table for tracking purposes:

 CashReceipt_006

Standard Epicor Software does not automatically close Invoices where any remaining balance after payment requires write-off. As part of this custom software solution, a checkbox was added to the Cash Receipt Entry header tab in order to help automate this process. On posting, when the checkbox is set to false, standard Epicor Software functionality will process the group. When set to true, on posting of the group, additional processing is triggered, and for the specified payment, any invoices in the allocation where after payment is applied, the balance is > $0.00, the invoice is adjusted to $0.00 and closed:

 CashReceipt_007

 CashReceipt_008

Post the Group. Group posts, invoice referenced in allocation is closed (10320), remaining balance is adjusted off, using Book, GL account, description and comment as defined:

CashReceipt_009

2 responses to “Accounts Receivable Cash Receipt / Debit Upload – Epicor ERP Custom Software Solution”

  1. melvin peeks says:

    Once cash receipts are posted how do I go back and make corrections on the receipt if I entered the wrong amoount.

  2. hira khatri says:

    How I can print the receipt to be handed over to customer in Epicor 9 or 10
    Please guide us.

Leave a Reply

Your email address will not be published.