Hi sap gurus, I searched forum but I couldn't get enough knowledge. how does S_ALR_87012172 calculate customer's balance value? based on posting date, clearing date, document date or other date? I'm checking with fbl5n but balances are different.as I understand, other sap users have same problem but there isn't clear information.
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)
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.