Part Transaction History BAQDataview

Epicor ERP 10
1

The employee ID is in the parttran table but not in the dataview in part transaction history. What is the most efficient way to get it there?

If I were to replace the existing grid with a BAQDataView, is there a way to create greater than or less than publish//subscribe relationships? I have the part and plant working but the starting and cutoff dates are not integrated yet. Am I better off using a Dynamic Query adapter approach? Or is there a better approach all together?

Adding a column to the grid on the fly is heavy on performance. I thought of creating a BAQDataView and just having it relate to the part grid part number and display the employee in a separate text box but then we have to click on every row to see the employees.

Any thoughts?

Thanks,
Ross

2

I would have thought that this would be in the view, and maybe just a hidden field, and that a personalization would/could expose it…
That said… the way I typically get around something like this would be to create my own BAQ, and then create my own Dashboard to replace the other functionality. With this approach, you can create exactly what the user wants.

3

Thanks, Tim. That is exactly what I ended up doing. I made it a dashboard browse type and added to the context menu for easy access.

All of the other approaches seem too involved to get the job done.

Thanks for the response.

Ross

1 Like