This works on other grids, and I don’t see any difference on the Create Production Orders screen, but it’s not working and a lot of the columns on the screen are empty.
Any Ideas?
For example, the customer name column is added, and the column is visible on the grid, but is always empty.
Best answer by MichaelShirk
I managed to get the Production Order status to display by overriding a bunch of stuff from the POCreateAMExtension in my own extension. However, sorting and filtering wasn’t working.
Turns out I was overcomplicating it. Since the AMProdMatlSplitPlan table is already being joined to the query inside the POCreateAMExtension extension and it contains Order Type and ProdOrdID fields, it could be referenced by a PXDBScalar attribute on an unbound DAC extension field on the main POFixedDemand table. I didn’t need a graph extension at all.
Has anyone else noticed this behavior? Our purchasing manager really needs visibility into some of this data available in the linked columns, but we’re not able to show it because the columns are empty, even if we add them to the grid..
@darylbowman I tried this, but it didn’t work. After doing more digging I’m more confused than I was before.
I don’t want to copy-paste all the code here, but they’re doing something strange that I haven’t seen before. The data view query joins multiple other tables (SOOrder for example), and as you mentioned, the PXFieldScope is used to restrict the results to those specific fields. However, for all I can tell the data view delegate operates on, and returns only a POFixedDemand object…
It would be super helpful to get some insight on this. All I really need is to add the AMProdItem.statusID field to this screen. We don’t create purchase orders for custom order prod materials until the production order hits the “Released” status, so we need to make that visible for filtering purposes.
What I ultimately would like to know is, will it be better to create a “Clone” of this screen and implement it the way we want it, or is it feasible to override all the internals necessary to also include the AMProdItem.statusID field on this grid?
@darylbowman Thanks for responding again. This is still not working in my instance. I believe this is being affected by the fact that we have the manufacturing edition, which adds a graph extension that overrides a bunch of these virtual methods.
I’m in over my head and don’t understand how to go about making additional modifications to this! I’ll have to do more studying on how to work with multiple graph extensions that need to modify the same logic…..
I managed to get the Production Order status to display by overriding a bunch of stuff from the POCreateAMExtension in my own extension. However, sorting and filtering wasn’t working.
Turns out I was overcomplicating it. Since the AMProdMatlSplitPlan table is already being joined to the query inside the POCreateAMExtension extension and it contains Order Type and ProdOrdID fields, it could be referenced by a PXDBScalar attribute on an unbound DAC extension field on the main POFixedDemand table. I didn’t need a graph extension at all.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.