On the cloud, how can I update multiple rows at once to reset a field in PartTran?

Kinetic ERP
1

Hello,

I am now a cloud version of Epicor.

Is there a relatively easy way to update multiple rows at once in the table PartTran?

I have a boolean UD Field I use and need to reset it back to false.

Any help is appreciated.

Thanks,

Shawn

2

You want to update the part Tran table? You could write a custom code ubaq that does it

1 Like
3

My curiosity is peaked. Why did you add a UD field to partTran?

4

I am not sure what you are talking about.

Can you point me in the direction to do that, please?

5

Someone here wanted to take the info from the parttran and use it to print out labels.

My skillset at the time was to create a UD boolean field to select the record to print.

I then created a BPM that triggers on the update to check for the changed row to see if the UD field was true.

If so, then do an auto print from bartender to the label printer for that record.

What I didn’t think of at the time, and it is probably not an issue, is that they would leave it checked.

So now I have over 800 records with checked boxes I would like to uncheck quickly.

I was hoping there woulf be an easy way to uncheck them all at once.

I thought about DMT but I don’t think you can get the the PartTran tabel from it.

6

Updatable BAQ

Bring in the Part Tran Table

Use standard Db.XX command to update the checkbox

2 Likes
7

There are several tables that do not allow updates once written (at least through the Business Objects). I stay away from UD fields on these tables for this very reason.

I understand you’re in a fix at the moment but afterwards it may be worth rearchitecting this and finding another place for the trigger and removing the UD field. PartTran is a busy table and having a PartTran_UD has a performance penalty.

2 Likes