How to pre-populate table AMMRPBucketDetailInq for use in a GI

Question

I want to create a GI over table AMMRPBucketDetailInq, to feed to a dashboard, to show forecasted inventory levels for items into future periods. The existing inquiry ‘MRP Requirements by Item’ (not a GI) dynamically loads rows to this table (from AMMRPPlan) as the inquiry is executed. But I cannot use this inquiry as the associated GI on a dashboard.

If I can create a GI that uses this table, I can associate it with a new dashboard I am also creating. Is there a way, in a Generic Inquiry, that rows in a selected table can be populated with data, prior to the display of said data?

icon

Best answer by BenjaminCrisman 2 November 2022, 16:10

View original

BenjaminCrisman · Accepted Answer

Hi @rdennisj57! Some tables are calculated and not able to be used in a GI setting as you have seen and described.

The only way to get a similar GI is to find the associated tables which are feeding into this table and then use these in the GI attempting to create the same calculations either in the joins or in the results.

Alternatively, you could create a SQL view which uses the above method but stores the joins and results into one view which can be used on the GI to power the dashboard.

I would recommend to scout the screens which have the data you are looking for to gather the associated tables and either make a SQL view or add them into GI and it should work similarly.

rdennisj57 · Answer

Thank you Benjamin for the quick reply!When using the SQL View approach, is it possible to create/use a constructor method for the SQL View’s related DAC, that would allow me to execute C# code that would populate the view?The challenge is that I don’t see any way I could populate the view with data via joins/results. Each row in this table has a from- and to-date that must be calculated based on MRP Buckets in another table. That’s probably why the MRP Requirements by Item Inquiry is not written as a GI?

How to pre-populate table AMMRPBucketDetailInq for use in a GI

2 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded