Skip to main content
Solved

Dashboard Trend missing data

  • Jan 21, 2022 7:59 PM UTC
  • 6 replies
  • 195 views
  • Translate All

Forum|alt.badge.img+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!

Best answer by Naveen Boga

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

View original

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Jan 22, 2022 12:55 PM UTC

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.

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Jan 23, 2022 12:00 AM UTC

Attached is the xml - thanks!

Translate

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Jan 24, 2022 10:55 AM UTC

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,

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Jan 24, 2022 11:23 AM UTC

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

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Jan 24, 2022 4:12 PM UTC

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.

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Jan 24, 2022 4:41 PM UTC

Awesome  @alicezyks51 Thanks for sharing the update.  

Translate