I’ve done a few of these already but this one seems to be a little extra. Background: I was tasked with creating an interface where the end user could input data into UD25. The fields are as follows: Key 1: OrderNum; Key 2: Department, Key 3: Pallet Size; Key 4; Blank; Key 5: Blank; Number 01: Qt…

You will need to get those other keys in order to use the DeleteByID method (or whatever it’s called). Are there multiple departments/pallet sizes per order? In other words, will there be multiple lines that will return if you did a lookup just by the OrderNum key?

Yes. If just by order it’ll bring them all up. But, I want to delete everything associated with that order.

As always, I’m not sure this is the best way… But, you could run a LINQ statement and pull in all UD25 records with Key1 = Your Order Num. Then, in your foreach loop, for each row get all the keys. Then you have what you need to do your delete. I can’t recall if I have used the DeleteByID or if I j…

@Will79 You can do this with updateExt like in this thread. [image] How to quickly delete table ud01? Epicor ERP 10 You might be able to use the UpdateExt method for UD01… UpdateExt does support datasets. If you run UpdateExt with UD01.RowMod = “D” on every record in the …

Thanks! I’ve been working in this today and have one little issue. I am trying to pass the Ordrenum to to the BO for UD25 and it keeps telling me there is multiple order numbers. Makes sense as the shipment has two lines. I’ve tried to use .First(), but that errors out as well. Any ideas on how …

You can only delete one record at a time with widgets. If you have more than one record, (which is sounds like you do) you’ll have to loop through the records. While that’s doable in widgets, it’s a huge PITA…

UGG…So, guess that means I have to use Custom Code… Not my favorite.

[image] Banderson: widgets I’m somewhat surprised they don’t have a looping widget of some sort.

That’s probably the best thing about workato, actually!

[image] Banderson: You can only delete one record at a time with widgets. I’ve never tried, but can you fill a dataset with one widget, update RowMod to “D”, and call update on the dataset? :thinking:

Delete UD Field By BPM

Epicor ERP 10

gpayne (Greg Payne) January 25, 2023, 11:53pm 5

@Will79 You can do this with updateExt like in this thread.

Topic		Replies	Views
Delete Rows UD Table Epicor ERP 10 bpm	10	11473	February 13, 2019
Clearing a Table Epicor ERP 10 e10 , bpm , baq , ud-table	18	3285	July 30, 2021
UD Table Fill BPM Error For Multiple Lines Epicor ERP 10 e10 , epicor , bpm	3	493	August 25, 2022
Job Deletion Tracking Epicor ERP 10 e10	12	3680	December 8, 2017
Insert UD Table Records from a BPM Epicor ERP 10 bpm	12	17396	October 19, 2020

Delete UD Field By BPM

Related topics