Update UD table with ud fields with DMT

Epicor ERP 10
1

Hello all,

I have an excel with 200 records I want to copy into my UD26 table. I have 3 UD fields added. But The DMT tells me it does not recognize the extra fields. How can I make this copy then?

I was able to create via DMT the list in the UD26 by removing the 3 extra columns. Can I just add the ForeignSysRowID besides my extra fields and make an update in SQL ? Would that work? How about the SysRevID is that automatically created?

I am stuck here. Not sure how to proceed.

thank you

Pierre

2

Something is wrong with your DMT, it should recognize the fields. Click on the template builder and see if they show up.

image

3

I just did a test using @Banderson suggestion and it worked for me.

1 Like
4

Thanks, it has been only a few hours I was trying to find an alternate solution…
All this for a badly named field… I did not pay attention… my bad.

Pierre

2 Likes