Account balance different between FS10 (table GLT0) and FBL3 (table BSAS)

[Former Member]

I found the problem is "Account balance" value in currency group (USD) in transaction FS10

and total sum of "USD Amount" in transaction code FBL3 (If click to sum by currency)

are different for 17.79 USD

This problem happen for 2 year and only for 2 G/L Account with different (always) 17.79 USD.

I tried to get a logic of this 2 transaction code and found detail as below:

FS10 : Get data from table GLT0 and for group currency report. Program select data

from field KSLVT and KSLXX to display in report.

FBL3 : Get all data until selected period in table BSAS and sum total amount from field BSAS-DMBE2

(Amount of USD Currency)

Actually, This 2 report should to have the same account balance.

So, Anyone have a problem as this case?

I think usually when create or change accounting doc. This change should to synchronize to

update this 2 table to have the same value (I mean .. table GLT0 and BSAS)

Many thank in advance.

[Former Member]

Hello

Just to check. Is there any cleared item in the acoounts?

BSAS table is for Cleared Items, so you shuold also check BSIS table taht is for open items.

regards