DMT Combined Cash Receipt

Epicor ERP 10
1

We receive an excel file from our bank showing the invoice, amount paid, and check number. We are able to upload this file through the Combined Cash Receipt DMT but it does not automatically send the invoices to the allocation tab. We still have to go into Invoice Selection, select the invoices and then allocate.

Since we have the invoice, check number, and payment amount is there a way for these invoices to automatically go to the Allocation tab? We tried the appliedamt field but that did not help. Is there a select invoice field or some other way for this to auto allocate the invoices?

2

You could set up a BPM that does this after DMT runs. You may want to have criteria to ensure they are auto-allocated only when doing DMT (and not someone doing cash receipt manually).

3

Thanks Terry. I was thinking maybe a BPM but was hoping it was something DMT could handle. I do like your thought on only doing it after a DMT upload,

I have not seen in the cash receipt detail template whether or not this was possible,

thanks again

4

Any reason not to use Bank Receipt File Import?

image
image1051×545 22.1 KB

5

Mark I haven’t used it much. Will that do the allocations and/or the on account?

6

I’m not sure, Mark. I know that our German facility just did Bank Recon daily and that does allow for misc fees, direct debits, on account, etc.