AP invoice and payment integration with third party supplier

Kinetic ERP
1

We are attempting to use a 3rd party supplier to automate AP and AP payments in Epicor. We are using DMT and have successfully created a combined AP entry template. The Payment entry using DMT is very difficult. Any ideas on how to make payment entry using DMT easier? We are currently using 2 separate template for payment entry Check Head and Payment entry. Our roadblocks are head number and check number.
.

2

Hi Lesia. Did you find a solution for this? We are planning to automate our AP payments using a 3rd party also. Part of the data flow will be them sending us a payment file which we will need to import to Kinetic. Have you been able to get this to work? If so, what does your workflow look like?
Thanks,
Carl

3

We use 3 templates in DMT to upload payment entries to EPICOR:
-Group
-Check Head
-Invoice

1 Like
4

Hi, can you share your templates with me?

5

Hello Armado.
These are the 3 templates that I use to upload payments into my system.
Details.csv (629 Bytes)
Group.csv (34 Bytes)
Head.csv (660 Bytes)

There’s a little bit of manipulation using PowerShell to get the data organized and populated. :sign_of_the_horns:

6

thanks for the templates
Do you know which table it’s obtained from HeadNum?

7

I upload the Group then the Head. Then for each payment that I need to upload using the Details I search the CheckHed table for the HeadNum value. I have to do it in this order because the system generates the HeadNum automatically after I upload the Head template. I use the GroupID, VendorID, and CheckNum as parameters to search the CheckHed table.