How do i get vendor or customer balances without any line items

[former_member506893]

Dear All, I want the balances of both vendor and customer without any line items. Normally in SAP we'll to FBL1N to check the vendor line items. But, it shows the balances with open or cleared items as per our requirement. But my requirement is I don't want any line items in the report but i need only the outstanding balance amount of the customer and vendor.

Please suggest me if there is any other way to take the report.

Thanks in advance

[former_member513101 · Accepted solution]

Hi Manivannan Karunanithy

In FBL1N or FBL5N, subtotal the vendor or customer code. Then, goto settings > summation levels > Define breakdown. Double click on vendor or customer code

[former_member506893 · Accepted solution]

Hi,

Thanks. It worked well. 🙂

[Gustavo_Vazquez]

Hi,

In ECC report RFKSLD00 or RFDSLD00 for information in Local currency, also RFKUML00 or RFDUML00 for other currencies.

Kind Regards

[TammyPowlas]

OK, are you using S4? That is what you have tagged. If you are using ECC you can use transaction FK10N to view vendor balances. Please clarify

[former_member506893]

Hi,

I'm using S 4Hana only. My requirement is different and i got the answer. I need only the total balances of the each vendor and not the line items.

Thank you for your part. 🙂