Symptom
You open the report Accounts Payable - Open Items (ID FINGLAU08_Q0004) and notice that a check that you cashed in and thought cleared is displayed in the report.
Environment
SAP Business ByDesign
Reproducing the Issue
- Open Work Centre Business Analytics, display all reports.
- Search and open report: Accounts Payable - Open Items.
- Execute the report with the relevant data such as Key Date, Company and Supplier involved.
- There is a Journal Entry Type for Cash disbursement of amount for a Source Document of type Payment.
- Add the characteristics Clearing dates, Clearing ID and Clearing Journal Entry to rows.
- The Clearing date is DD.MM.9999 and both Clearing ID and Journal Entry are unassigned (#).
- Open Work Centre Payables.
- Navigate to View Supplier Account, show all.
- Search and select the relevant supplier as seen in the report.
- Navigate to the Trade/Payables tab, check ABC (ABC represents the check ID) is listed in the Open items but is not associated to any payment
Cause
The check appears in the Open items for this supplier as the option "Reference to items" was selected when it was posted, as opposed to "Direct Posting to G/L account.":
- Go to Work Centre Payment management.
- Open View Payment Monitor.
- Search and select the relevant Outgoing check, open it.
- In the Outgoing Check Overview, scroll down to Payment Application Method.
- "Reference to Items" is displayed.
Since the check hasn't been posted against an open item as seen in the Supplier Account Monitor, its amount remains outstanding while waiting to be cleared, therefore, the system's behaviour is the one expected and this is why this document is listed in report Account Payables - Open Items.
Resolution
If the Outgoing check is not against a payment recorded in the system, it is always a better option to choose the "Direct Posting to G/L Account" option.
If the decision is made not to do so or if a mistake was made while posting the check, the payment can be cleared against a New Charge/Credit in the Supplier Account Monitor:
- Open Work Centre Payables.
- Navigate to View Supplier Account, show all.
- Search and select the relevant supplier as seen in the report.
- Navigate to the Trade/Payables tab, Click on the button "New Charge/Credit".
- In the new windows, select "Charge", then fill in the relevant information.
- Maintain the amount as indicated on the Outgoing check.
- Click on Post.
The Outgoing check should no longer be in the Open items for this supplier and should disappear from report Accounts Payable - Open Items.
The whole business process can also be reversed, starting from the very last document or transaction displayed on the Document Flow of the check until the Check itself can be reversed. Once this is done, the Outgoing check can be re-created and the option "Direct Posting to G/L Account" can be chosen.
See Also
For further information on the "Direct Posting to G/L Account" feature, please refer to Help Document: Create an Outgoing Cash Payment
Keywords
Outgoing Check, Accounts Payable - Open Items, Journal Entry, Report, Displayed. , KBA , SRD-FIN-GL , General Ledger , How To