I have attempted to use the DMT for Check Header and also with Misc Detail to automate loading paychecks from our third party provider into Epicor so that we can use the system to reconcile our bank account. I have found that through many attempts and including different arrangements of the columns in the CSV file that the file fails to upload. It states “No Errors” but the data does not load in the system.
Has anyone solved this and is able to upload paycheck information through DMT?
I tried both the Check Header and the Misc Detail templates. I was not sure which one (or both) that I needed to use. Have you found success in using a DMT for this?
Unfortunately no. Epicenter said they could write us something to make this work but we would have to pay for it. I am just surprised their is no standard DMT solution that can work for this.
I found this challenging, and I love challenging issues
So, I’ve just tried to upload to Check Head with DMT, faced some issues, and then finally I’m able to do it !!
If possible, provide me with few rows (sample data) you are trying to upload, I’ll try from my side and will tell you the possible causes of the issue and possible solutions.
First, create empty payment group, set bank account and any required fields.
Then, import payments to this group with DMT.
Exit the group and open it again to see if payments imported, because the refresh button doesn’t work!
I gave this a try and it did upload but would not allow me to add the Misc Payment information. Do you know how to get this information included in the upload?