Skip to main content
Answer

Dashboard Trend missing data

  • January 21, 2022
  • 6 replies
  • 158 views

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

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 22, 2022

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.


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • January 23, 2022

Attached is the xml - thanks!


Forum|alt.badge.img+12
  • Acumatica Support Team
  • January 24, 2022

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,

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • January 24, 2022

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


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • January 24, 2022

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.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 24, 2022

Awesome  @alicezyks51 Thanks for sharing the update.