Hi Sap Gurus,
I would need to check reports of nearly seventy thousand vendor/ customer account balances in three ways like:
A) Zero Balances in the Vendor/Customer accounts
B) If balances are there, how old it is
C) Usage history of the vendor/customer i.e whether the account is used at all, if used what postings we made and when it was cleared
As per my understanding, we can check the balances of vendor through t.code FBL1N & S_ALR_87012082 but it takes long time as I need to check nearly 70000 vendor/customer codes.
Can we check all 70000 vendor/customer accounts in single t.code/report, if not how to approch and what t.code to use.
Please share your inputs.
Thanks in advance.