cancel
Showing results for 
Search instead for 
Did you mean: 

Missing balances in Vendor Balances in Local Currency

0 Kudos

Hello All,

I am writing because I am facing an issue and I can't find the answer.

We have a posting made on a vendor account which was correctly reconciliate with th GL account for vendors

(2060101000).

The entries are cleared at end 04/20 by a transaction done on 06.07.2020

The problem is there was no existing balances (either cleared or not cleared) for these entries at end of calendar date 30.04.2020 in report s_alr_87012082 -Vendor Balances in Local Currency.

Do you know what could have caused this?

TammyPowlas
Active Contributor
0 Kudos

What does FBL1N show for the vendor? You can run it for all postings

0 Kudos

FBL1N shows all items correctly.

0 Kudos

The item was manually posted on 07.04 and cleared at 06.07.

There was no existing balances (either cleared or not cleared) for this entry at end of calendar date 30.04.2020 in report s_alr_87012082 -Vendor Balances in Local Currency.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Finally I found the issue.

The problem was in another place, in Travel management. It was a partially posted posting run. The post was released in PRFI transaction but blocked in PRRW transaction.

Thank you all for your support!

Shikha_Saini
Participant
0 Kudos

Hello Adriana,

If the balances are correct in FBL1N then please check the output variant you are selecting for the report - adriannag You can configure a new variant , if required or do the changes in the variant and then run the report.

Regards,

Shikha Saini

Lakshmipathi
Active Contributor
0 Kudos

While adding further informations to the clarifications asked by members, please see that it is added under Comments and not under Answer as you were not Answering but only providing additional informations as asked by members. Also, by commenting to the queries asked by the member, mail will be triggered to the person who raised the query; instead if you Answer, it won't happen. By the way, I have converted this Answer to Comment

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello adriannag

If you have cleared an open item before 30/04( you have mentioned as end of 04/20), it would not show up in the balances for the vendor, even if the transaction has been entered in the system on 06/07. You need to check the posting data of the clearing document to check the accounting impact.

Thanks & Regards

Sanil Bhandari