Skip to main content
Solved

Report not pulling correct date range


Forum|alt.badge.img

Hi all, having an issue with our Hard Goods Forecast not pulling a correct date range. This is a report which I always struggle with because there’s no apparent GI it’s tied to, and then have to poke around in Report Designer to see what’s up.

Here’s the basic report:

Simple enough. Set the date range to this month, run report:

And it pulls all historical data.

So I go poking in Report Designer and nothing looks amiss (but then again I don’t know what the heck I’m looking for):

 

I’m thinking maybe it’s the Left joins here?

I’m new to this so I’m not sure where else to look… thank you!

Best answer by swartzfeger

I’m going to close this as “solved” (for now). I changed the two left joins to inner, saved to server, refreshed the report and re-ran, and it pulled 0 items. I changed the two joins back to their original state, re-uploaded… and now it’s pulling the correct date range. Don’t know how I fixed it but I’m not complaining. :)

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

2 replies

Forum|alt.badge.img
  • Author
  • Freshman II
  • 158 replies
  • Answer
  • May 10, 2023

I’m going to close this as “solved” (for now). I changed the two left joins to inner, saved to server, refreshed the report and re-ran, and it pulled 0 items. I changed the two joins back to their original state, re-uploaded… and now it’s pulling the correct date range. Don’t know how I fixed it but I’m not complaining. :)


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2749 replies
  • May 10, 2023

Thank you for sharing your solution with the community @swartzfeger !


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