Vendor Overview with Current Negative Balance (in our Favour) t-code

[former_member563556]

Hi,

I'm a bit new to SAP but getting beter everyday.

I have a question I need to create an overview of All my vendors with a Negative balance, beter said they need to pay to us.

Now I have been using t-code F.42 in combination with FBL1N and export all the data to Excel.

Now I noticed that F.42 is working for me partly but somehow when I run it I need to select 1 fiscal year (not more or less) it will give me a list of Vendor's but I noticed that I am missing vendor's in this list, while they indeed have a negative balance (in our favour).

Can someone help me out?

i also had a look in SQ00 but coudln't find a useful query and creating one by my self is a bit to difficult for me.

Any help is welcome and Always thank you in advance.

Willem

[Former Member]

Have a look at the LFC1 table (and use your query skills) 🙂

https://archive.sap.com/discussions/thread/1207927

[former_member563556]

Hi,

Thx for the info S_ALR_87012082 is like F.42

My main problem when I use the S_ALR_87012082 is that the Fiscal year option is in my way. when I use the option it gives me for supplier X that there is a positive balance to pay to the Supplier, However if I check FBL1N the open balance is negative (in our favour). the thing is I can only give 1 fiscal year, I am not allowed to leave it blank or

Therefore the info I am getting is not correct.

Someone else tipped me on a different report S_P99_41000099, it helps me a little bit more in the correct direction it really provides me the open balance per vendor, but the difficult part is that it is based on the payments (my company only pays 1 day per month). I ran the report based on the payment date 8 March and it gave me the balance on that day, again it is not entirely correct because we received a payment afterwards and the balance is lower, is there maybe a different report?

Regards,

Willem

[TammyPowlas]

Hello Willem - please use transaction/report S_ALR_87012082 and you can filter / select based on balance. Good luck