Solved

Dashboard Trend missing data

  • 21 January 2022
  • 6 replies
  • 118 views

Userlevel 4
Badge +1

The Inventory Trend KPI is not returning any data. It uses the DB GL History generic inquiry filtered by “Inventory” class GL accounts. The KPI setup is as follows with the “Filter Settings” based on the Inventory filter.:

The Inventory tab on the GI looks as follows:

The drilldown tab of the GI returns no records and the filter settings include date parameters.

Where are those date parameters coming from and how can I work around them? I’m pretty certain that is causing the lack of data since the “Fin. Date” is month end and the dates being added to the filter are based on the current date.

 

Thanks!

icon

Best answer by Naveen Boga 24 January 2022, 12:23

View original

6 replies

Userlevel 7
Badge +17

Hi @alicezyks51  For some reason, I’m not able attach the text here, hence sharing the screenshot

Userlevel 4
Badge +1

Thanks Naveen B!

 

I added the financial period Start Date to the GI and used that instead of Fin Date as the timeline field in the KPI setup and it is now returning data as expected.

Userlevel 7
Badge +17

Hi @alicezyks51  Can you please share the XML format of the DB GL History generic inquiry, I can create and check the KPI dashboard from my side.

Userlevel 4
Badge +1

Attached is the xml - thanks!

Userlevel 7
Badge +11

Hi @alicezyks51 

Can you check if there are any lines that matches the filter criteria set? I am sure there are more lines on result and there may be, just wanted to confirm. 

 

Regards,

 

Userlevel 7
Badge +17

Awesome  @alicezyks51 Thanks for sharing the update.  

Reply


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