Skip to Content
0

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

Mar 09 at 02:17 PM

39

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Mar 09 at 02:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 15 at 08:50 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Bastiaan Jansen Mar 15 at 12:04 PM
0

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

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

Share
10 |10000 characters needed characters left characters exceeded