DMT Project Criteria - MilestoneID 'Input string not correct format'

Epicor ERP 10
1

I am trying to use DMT to setup Sales orders, Projects, Jobs, Demand, Milestones and finally apply Project Criteria to the Milestones.
I have got my SO’s in, jobs linked, scheduled - all that good stuff - when I go to apply the Criteria I get the error in the title
‘Input string was not in the correct format.’
However this is only occurring on Criteria that are of Type J or ‘Job Operation Complete’.
In the same file I’m loading F types (Fixed Date) and they are going in with no issue. The milestone ID format is the same (8 characters).

this is a snip of the initial csv

image
image1589×189 43.6 KB

I have tried removing the fixed date lines from the csv, and I’ve taken out the spare date column that’s there - but it’s still not working.
I’m on 10.1.600.38 for Epicor - and DMT is always telling me it’s up to date.

Looking for someone with experience in this area - or who might have been through this.
Thanks.

JK

2

When I took DMT training which was a decade ago the advice was to duplicate errors in the UI to see if you could get a clue what else was needed. Sometimes it is another field is missing for that type or just the order of the fields in the upload file.

2 Likes
3

For the eagle eyed viewers - you’d see that I used a JobNum in the Assembly Seq column. Bad spreadsheeting on my part.
But your advice was perfect, and that’s exactly how I found the issue.
Thank you very much.

1 Like