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

  • 2 November 2022
  • 2 replies

Userlevel 2

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?


Best answer by BenjaminCrisman 2 November 2022, 16:10

View original

2 replies

Userlevel 7
Badge +4

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.

Userlevel 2

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?


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved