I am working on DMT in a bunch of Account segments. One of the items needed is SegmentNbrName. Is this a number or alpha numeric? Trying to figure out what it is.
Those are system generated, try setting the SegmentNbrName to “0” on your import.
Just tried a sample and got the error COASegment record not found.
Not sure what it is but all of ours appear to be set to “1”. You should be able to see yours querying the “COASegValues” table.
Sadly nothing. I am def confused by this error. The csv file is exactly as the columns from the template are supposed to be. Just crazy.
Were you able to sort this? I’m having same issue.
Try using one of these for the “SegmentNbrName” on the import.
Natural
Department
Division
1 Like
How many rows are you bringing in?
Less than 100 I would consider manually adding or paste inserting them in vs using DMT
I have run into situations like this and found I have had to get creative. Here are a couple of creative thoughts. I don’t see the field, SegmentNbrName, in the table, COASegValues so the DMT may be giving you incorrect information which it has been known to do. I would try using the field, SegmentNbr instead which is an Epicor generated field in the COASegment table. You could also try the SegmentNbr and include the SegmentNbrName but as a blank field. As I said you may need to be creative.
1 Like
Thank you! this solution did the trick. 
1 Like