DMT Says Job Number is Invalid, but it's Not

Kinetic ERP
1

I’m trying to use Job Complete / Closing in DMT but when I try my test file, it says my job number is invalid. I’m in the job in Epicor so I know it’s a valid job. The job number has a leading 0, but I’ve tried every Excel trick I know to make it format correctly.
Any suggestions?

image
image991×643 79 KB

2

Sometimes DMT can be picky about the order your columns are in. My template, which works, looks like this:

image

Also if you are trying to complete/close the job, your JobClosed/JobComplete columns should be true, not false.

2 Likes
3

Yep, it was the order. Helpful errors, DMT :roll_eyes:
I’m uncompleting/reopening to add Project IDs to jobs then I’ll reclose/complete.
Thanks for your help!!

1 Like