Skip to main content
Solved

Dashboard Trend missing data

  • January 21, 2022
  • 6 replies
  • 137 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

View original
Did this topic help you find an answer to your question?

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3407 replies
  • 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
  • 45 replies
  • January 23, 2022

Attached is the xml - thanks!


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • 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
  • 3407 replies
  • 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
  • 45 replies
  • 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
  • 3407 replies
  • January 24, 2022

Awesome  @alicezyks51 Thanks for sharing the update.  


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings