cancel
Showing results for 
Search instead for 
Did you mean: 

Query on migrated customer open items

Expert
Active Contributor
0 Kudos

Dear SAP    We have a question regarding migrated open items.  Issue1:  As Migration date we have set 30.03.2020 in the Testsystem and then have migrated open items for suppliers and customers. Therefore the posting date of the migrated open items is set to 30.03.2020. We also have migrated open items with due dates in 2019 or beginning of 2020. When we now search for "Open on Key Date" = 29.03.2020 we do not find any open items. But when we set the search date on the migration date or anytime after the migration date, the open items are found.  Issue 2:  Our client has a process, where they look for open items for credits that are open for p.e. 6 months. When they can not clear it with another open item within this 6 month, they send the customer a letter asking them if they should transfer the money or not. In the App "Create correspondence" you encounter exactly the same situation. If you select the 29.03.2020 as "open at key date" and click on PDF preview the open item list is empty, even though there are open items that have due dates in 2019 or beginning 2020.    Best Regardss.

Accepted Solutions (1)

Accepted Solutions (1)

Expert
Active Contributor
0 Kudos

Issue 1:

First of all, the “Open at key date”-logic takes into account when the document was posted.

So, if you post a document on 30-March-2020 and then you look for open items per 29-March-2020, the system cannot find the item created on 30-March-2020, because it exists only after 29-March-2020.

So, this behavior is correct. Hence as we already discussed, you can filter via journal entry date.

Issue 2: On create correspondence:

you cab select line items which are overdue for 6 months or longer – but the key date for open items has to be “today” – not in the past.

I would recommend you should check the dunning capabilities and go for an approach to send dunning letters for items which are overdue for a certain number of days.

Of course to do so for migrated items, it needs to be ensured that the correct base line date and payment terms is maintained.

Answers (1)

Answers (1)

Expert
Active Contributor
0 Kudos

This is a re-posted Q&A of an earlier question on this community