You are trying to post a Supplier Credit Memo against the Supplier Invoice ABC (ABC represents the Supplier Invoice ID).
This results in an unposted source document and the following business task: Automatic clearing of source document with posting date DD.MM.YYYY failed. Supplier Invoice ABC to be cleared has postings assigned with posting date DD.MM.YYYY. Create a new manual clearing containing only ABC and save the clearing. Then post the business transaction for accounting. (DD.MM.YYYY represents the posting date of the document)
Reproducing the Issue
- Go to General Ledger work centre.
- Go to Source Documents view.
- Find ABC.
You will find the business task related to the unposted Supplier Credit Memo blocked by the Supplier Invoice ABC and with the following error: Automatic clearing of source document with posting date DD.MM.YYYY failed. Supplier Invoice ABC to be cleared has postings assigned with posting date DD.MM.YYYY. Create a new manual clearing containing only ABC and save the clearing. Then post the business transaction for accounting.
The error appears as the Supplier Invoice ABC was previously partially cleared with posting date DD.MM.XXXX. The credit memo now tries to automatically clear itself with the remaining open amount of the supplier invoice.
But as the credit memo’s posting date is before the most recent clearing date, the error appears.
In order to solve this issue, you need to select the invoice in the Payables account and create a clearing containing only the invoice ABC. You can follow these steps to do so:
- Go to work center Payables.
- Go to view Supplier Accounts.
- Find Supplier from invoice ABC.
- Click View.
- Go to tab Trade Payables.
- Select the Credit Memo.
- Click Clear Manually.
- Click Save.
The clearing will be created and generate an ID. This way the credit memo will not try to match itself with the open invoice anymore but will appear as an on account item in the supplier account. After that, you can post the Credit Memo from the Unposted Source document. Once the credit memo is posted, it will appear as open item in the Trade Payables tab of the Supplier Account Monitor as well.
You can then reset the newly created clearing for the invoice so it is also open again in the Supplier Account Monitor.
Finally, the Supplier Invoice ABC and the related Credit memo can be cleared manually.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To