Customizing Planning Workbench EpiUltraGrid

Epicor ERP 10
, ,
1

Good afternoon fine people. I have several coworkers who want to add a column for a custom field to the existing standard EpiUltraGrid titled, Suggestions, seen in the screenshot below…

image
image.png850×613 16.4 KB

I have told them that we can’t add (or remove) columns from this standard control but they keep coming back with, “there’s got to be a way”. So now I’m reaching out to the vast intelligence here to either tell me I’m wrong and there is a way to achieve this or offer me technical reasons as to why it can’t be done.

Thank you for your time and any help you can offer. Have a great day!

2

You can do this - question is how hard will it be and what type of performance will you get.

The easiest way bar none I think is to recreate the data you see in that grid into a BAQ. The hard part is figuring out where all the data comes from and how to link it - from there its easy to display those BAQ results in a grid (and even have it driven off that job number field).

The harder way requires coding and explicit manipulation of the grid - each time a row is updated by the system, you have to also do your update of special data.

1 Like
3

Thanks for the reply, Chris!

I’m working on creating a BAQ that collects the same data as the grid. I figured out that the data is coming from the PartSug table. What I can’t figure out is where the Type description is coming from. In the screenshot below you see it reads “Increase Qty”…

image

But in the database table it shows two fields, Type and SubType…

image

Type has “Qty” and SubType has “I”, which I imagine stands for “Increase”. I’ve tried looking for another table that holds these descriptions but can’t find any. Does anyone know of such a table, or are these two fields used to determine the type description through code? Thanks in advance for any help! Have a great afternoon.

4

Is that dataview named WB? Look in the Object Explorer -> Data ->

Or just tell me what the EpiBinding on the grid is

5

The EpiBinding for the grid is WB.

6

Ok so that dataView is built off of the PlanningWBAdapter.

Looking at the code below, it’s some sort of classification. Still digging to see where it comes from though.

.GetNewPartSug(this.planningWBData, classifier, targetJobNum, orderNum, orderLine, orderRelNum, warehouseCode, partNum, dueDate, jobNum, assemblySeq, jobSeq, targetAssemblySeq, targetMtlSeq);

it appears if the WB dataView is a one-to-one drop of the results of the adapter I mention

1 Like
7

PartSug.Classifier - BAM!

Type is probably relevant too.

1 Like
8

Were you ever able to get this working? I have created a BAQ that I would like to use as my dataview, but I don’t know how to link it to the data to get the grid to populate after the search is executed. Any advice would be greatly appreciated. Is a BAQ dataview the best route for this, or is there a better/easier way?

Thanks,
Patti