BPM Custom Code to sort open Op list by OprSeq

Epicor ERP 10
21

I think @Mark_Wonsil’s solution with string_agg is the best route since it saves all of the writing while users are working and has sql do the work for the operations.

In my case string_agg can’t do all I need, but custom code on GetList still avoids all of the writing and only reads when the dashboard is run. I rewrote that routine this weekend and you are welcome to it.

We are on 10.2.200, but I’ll have .700 available very soon
Does this mean you are planning to move from 400 to 700 and not up to almost current? I went from 400 to 11.1.200 and stayed classic.

22

We aren’t on Kinetic, do I need that for this to work?

23

Sorry, I was pulled and am not back on this task. It was left exacly where I left off. We are working on going to .700.40 in December, currently on .200.40.

24

Why are you only going to 700 and not to 11? It is virtually the same conversion time and you can still run classic.

2 Likes
25

You don’t need Kinetic, but your SQL Server must be at least 2017 and the compatibility level set to 14.

26

Ok, I don’t have that yet. Thank you! If not resolved by then I’ll circle back. Need to try another work around.

27

I don’t know if I was aware of that…haven’t tested. How do we run in classic still. You are on what version? Thanks!

28

I am 21.2 going to 23.2 in 2025 . I went from 10.2.400 to 11.1.200 18 months ago.

classic is a setting in the menu

1 Like