Good morning all,
We have a simple query that shows current month's on hand quantity that greater than 0. We use one variable that return current month/year, and another condition which return on hand quantity > 0.
When we transported this query from DEV to PROD, it displayed correct data. But when we execute it agian on the second day, we still got yesterday's data.
We tried to save this query to a new one, and transported to PROD; it worked agian. But next day same thing happened! Query result did not get refreshed.
Does anyone know why is it? Any solutions? Thanks a lot in advance!