Hi All, I can’t seem to figure out how to get this to work assuming I even can. I have a UD_Field that gets updated by BPM with custom code to list open operations by OpCode. There is no sort and when looking at it it’s just random. I want the list to display the operation code but in the proper ope…

So this is on OpComplete, but not in MES? What is this supposed to do?

[image] jenjen7981: C# linq classes. I started a “Code Camp” thread, that may help. We haven’t tackled LINQ specifically, but it’s on the todo list. There is quite a bit of LINQ in there already I believe, at least in the comments. [image] Kinetic Code Camp - Bring y…

When an operation get’s completed or any change made to JobOper table, it writes the list of open operations to OpenOp_C field. This field is then used on dashboards for production to reivew jobs and they can see what operations by OpCode are still open. It shows the open Ops, just not putting them …

I have a routine that does this same process, but on the fly in a dashboard. Export and upload your bpm and we can take a look. Your version just says 10. The earliest I have to work in is 10.2.400.

We are on 10.2.200, but I’ll have .700 available very soon. Are routines new in Kinetic?

They have existed since 10.2, but the last ones are in 11.1, so the tt to ds changed somewhere along the line. If you want us to look upload the bpm.

Greg can’t move very well, give the man something to do! [Work From Home Sport GIF by UFC]

Yes, I do. Thank you was pulled in 9 directions, yeehaaa! OpenOpList.bpm (33.2 KB)

For my jobs it seems to get the correct ordering, but they are fairly simple. I took your routine and made as few changes as possible (rowmod was changed, so it did not run twice) and one I made closer to how I would write it and both produced the same list. Can you add the write lines or use the b…

[image] gpayne: I can’t stand seeing code in the action pane A little ocd isn’t a bad thing. When you start flipping the light switch 27 times before you leave a room you may have a problem.

BPM Custom Code to sort open Op list by OprSeq

Epicor ERP 10

Mark_Wonsil (Mark Wonsil) May 12, 2024, 1:18am 20

I know you’ve spent a couple of days on this but another option is to do the query in a BAQ and use string_aggregate to generate your string.

Topic		Replies	Views
LINQ Assistance - orderby Epicor ERP 10 sql , bpm , linq	3	2252	January 30, 2020
BAQ Current Open Operation Only Epicor ERP 10	16	6267	June 8, 2017
Previous Operation in BAQ Epicor ERP 10	35	15831	September 17, 2024
Only show job's where OP10 is complete but OP20 is not Epicor ERP 10 e10 , epicor , bpm , baq , ssrs , reports	13	1126	May 11, 2023
Bpm Epicor ERP 10 bpm	12	2960	May 16, 2019

BPM Custom Code to sort open Op list by OprSeq

Related topics