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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/62a87c80-768f-4b8d-8ba7-997e0080db96.png)
Simple enough. Set the date range to this month, run report:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1be6cac9-d446-465c-a4b3-07540766fdd2.png)
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):
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3693098a-5925-4cab-96f3-a135870d6a66.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c2822e4f-0df2-4efe-bd03-59156746a7fe.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/50ad0475-903a-44f0-b0db-a9d46d2aad65.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/bbe9922d-0e00-4cdd-ba72-2b0b71743579.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/383c4e1f-514f-474f-bf7f-d4c3a3bcce4c.png)
I’m thinking maybe it’s the Left joins here?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/180689fe-7dac-4e01-bbe3-b2b524d03e0e.png)
I’m new to this so I’m not sure where else to look… thank you!
Best answer by swartzfeger
View original