Hello,
This report read data from KNC1 and KNC3 tables.
KNC1 keeps customer non-special G/L indicators balance and KNC3 keeps balance for each special G/L indicator.
And this table always filled by posting date !
Do you forget run balance carryforward program after changing fiscal year ? (like F.07 transaction)
Regards,
Burak
Thanks Burak, as I know, FBL5N uses BSID and BSAD tables. those tables have posting date data. KNC1 and KNC3 tables can different from BSID and BSAD tables?
Hello,
I think that it's impossible. KNC1 and KNC3 must be identical with BSID and BSAD for amount. Did you check it with using SE16?
Regards,
Burak
should I sum DMBTR values for BSID and BSAD tables? I should check clearing date for past dates?(as an example, if I check january value, I should check clearing date after january for closed items, and posting date before january for open items.)
Hello,
You don't need to check clearing date.
Please select data from BSID and BSAD less equal to key date. Is it equal to total balance report?
You can balance report per each customer, I think you can check it for wrong balance's customer.
Please share result to me.
Regards,
Burak
