Vendor balances per reconciled account

[Former Member]

Dear all,

In my country, I use alternative account for vendors. Is there any function to get balance of vendor per reconciled account.

By example:

Input:

Vendor Number

Reconcile Account

Output:

Balance at key date

If not, can you show me the logic how to get it. I need it to show to my ABAPers.

Thank you very much for your help,

Sylvecat.

[Former Member]

Dear Sylvecat.

Use Report S_ALR_87012082

Enter Vendor Name and for entering Recocile A/c choose the field in dynamic selection.

If you want to see open items then go to FBL1N and give the details as above.

Hope it solves your query

Cheers

IMK

[Former Member]

Thanks for all your replies, But it's just correct with special GL. If we use alternative accounts, system cannot display by individual account.

[Former Member]

Hi,

In FBL1N, press change Layout button. there you will be find a field called G/L Account. Select it and bring it into display fields and press enter. It will show the recon a/c to which the vendor line item is posted to.

Hope this solves your problem....

Regards,

Sreekanth....

[Former Member]

FBL1N can not help me. Because this t-code is just show the balance in period. This report not show the accumulated balance.

[former_member182098]

Hello,

Use S_ALR_87012082 report.

Otherwise, ABAPer need to copy this report and accommodate further fields as per your requirement.

Regards,

Ravi