Mass clearing documents not derived to the right Liquidity item

[former_member1379081]

Hello,

I am a Treasury professional trying to navigate a problem I see with our S4 HANA's liquidity item derivation for a few documents that have been mass cleared by our colleagues in Accounting.

Issue in detail with an example:

Say there's a journal document XXXXX I check using TR code FB03.

I go further into the journal, to find the clearing document number YYYYY. When I check the payment usage of YYYYY, the document fetches 10000 entries in it. There are other document numbers also cleared against YYYYY.

This is causing issues with amounts being derived under the correct Liquidity item category.

How to navigate this and make sure several amounts cleared against one clearing document number is derived to the correct liquidity item instead of one Leg being Market to technical account and another leg marked to a different liquidity category?

Many thanks for any ideas / pointers / suggestions.

Cheers.
Shiva.

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members. For example, you can:- share screenshots of what you've seen/done- make sure you've applied the appropriate tagsThe more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.htmlShould you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

[former_member1367138]

Hello,

Currently, I am a Treasury professional trying to figure out what is going on with our S4 HANA's liquidity item derivation for a few documents that have been mass cleared by our accounting colleagues.

Here is an example of the issue in detail. It may be that there is a journal document XXXXX which I would like to check using the TR code FB03.

In the journal, I go a little further in order to find the clearing document number YYYYY. There are 10000 entries in the document when I check the usage of funds under YYYYY when I check the usage of funds under YYYYY. Additionally, there are other document numbers that have been cleared against YYYYY as well.

There is an issue with amounts being derived under the correct Liquidity item category as a result of this issue.

How do you navigate this and make sure that several amounts cleared against one clearing document number are derived to the correct liquidity item and not one leg being marked to a technical account and the other leg being marked to a different liquidity category? I would appreciate any ideas, pointers, or suggestions that you may have.

[Former Member]

I saw your posted comment. Please raise your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. The author of the original question is no longer active in the community and won't receive your query. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Best,
Your SAP Community moderator

[former_member1013960]

There is not a standard mass reset function in SAP. Once reset you can use F. 80 for the mass reversal. If you have access to an ABAP resource he or she may be able to write a quick and dirty program to run the clearing docs in mass using FBRA.