I am trying to update some _UD fields with summed data by using a Data Directive. I believe it should be In-Transaction. Do I HAVE to use custom code (which I have no idea where to start)? Or is there some way to run SQL code which i am waaay more proficient and knowledgeable with? Or is there som…

LINQ may be another option then. It’s pretty similar to SQL, and can be used in a Set Argument / Variable widget. You could set up 5 LINQ statements for each UD field to use in a set-field widget. Here’s a statement I previously used for labor quantity sums. I changed it to calculate indirect labor …

How to update UD fields with Data Directive

Epicor ERP 10

ckrusen (Calvin Krusen) April 27, 2020, 11:06pm 14

And this…

Note that the ICE manual shows the different ways for DD’s and MD’s, but has the swapped.