Hello IFS Friends,
When using Oracle SQL Developer I get a different value for balances of GL accounts vs using the GL Balance Analysis screen in IFS. We’re on IFS 10.11 and I’m using IEE. Logging in user App Owner in both cases. Am I using the wrong view?
Below is my SQL Query and the result:
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/1ae77808-8f28-432c-a88e-5bd2e1f8c5e9.png)
And here’s the same searching using IFS front end GL Balance Analysis screen, but getting different result:
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/543333b0-6455-484b-b08d-b75b8773ca00.png)
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/ecdea6ff-77e5-4d24-bc7c-3db4b4fdc489.png)
System info is telling me this is the right view:
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/b673c2fc-04d7-45e7-bc6f-dd09d40c23cb.png)
I’m getting the same type of issue no mater what parameters I use (specifying company code, time periods, etc.)
Any suggestions?
Thank you!