Difference between F-03 Balance & FBL3N Open Item Balances

Situation:  One of the issue is when we seeing open items for three GL accounts which is related to bank account such as main, deposit & issue account in FBL3N, system showing the balance which is correct. Now my client clearing these deposit and issue account balances to main account in F-03 on a particular date where system showing different balance, also main account does not have any balance in FBL3N but don't know why system showing different amount in F-03.

Kindly request you to provide solution on this issue.

Solution:  Open FBL3N; Select Open Items, Open at key date -> 31.03.2014

This will lead to this screen, where you can see balance in local currency considering the valuation of foreign currency.

Now, go To f-03 screen and check the clearing GL Account. Open the GL with clearing date as of  31.03.2014.

This will give you Balance as per screen

Now you can see there is difference between the balance. Now to check this click on the 

 button and this will give you following screen if you toggle by pressing the 

Now you need to move the differential balance as per your company policy. We moved the balance to Valuation Gain/ Loss account. Hope it helps.

Regards

Vanisha