Symptom
You want to clear a customer invoice with an open item managed G/L account but it is not available for clearing.
Reproducing the Issue
- Go to the General Ledger work centre.
- Go to the Master Data View, G/L Accounts sub-view.
- Use the Advanced search criteria to find the concerned G/L Account.
- Select the concerned G/L account which is open item managed, press the Edit Open Items button.
The open item for the customer invoice is not available in the list and as such cannot be cleared.
Cause
In G/L account open item management line items can be processed only if they are posted in the Miscellaneous Sub-ledger Account (General Ledger only postings without sub-ledger). However, customer invoice always posts to sales sub-ledger.
Resolution
To have the customer invoice indirectly available for clearing in the open item managed account, you need to implement the following workaround.
Via a first Journal Entry Voucher post in the customer invoice to a non open item managed "dummy" G/L account. Then post it again manually via a second Journal Entry Voucher from this "dummy" G/L account to the concerned open item managed G/L account.
Create the first Journal Entry Voucher:
- Go to the General Ledger work centre.
- From the Common Tasks area the option New Journal Entry Voucher.
- In the Journal Entry Voucher, Input the mandatory data for Journal Entry Type select 00088 - Manual Entry for Sales Documents, for the Screen Variant select 634 - Man. Write-Up/Write-Down for Sales Doc.
- press the Add Row button, enter the concerned open item managed G/L Account, the amount of the invoice on the debit side and, if necessary, the Sales Doc. ID and the Sales Doc. Item ID. The offset account is the "dummy" G/L account with on the credit side the amount of the invoice and, if necessary, the Sales Doc. ID and the Sales Doc. Item ID.
Create the second Journal Entry Voucher:
- Go to the General Ledger work centre.
- From the Common Tasks area the option New Journal Entry Voucher.
- In the Journal Entry Voucher, Input the mandatory data for Journal Entry Type select 00047 - Manual Posting - Journal Entry Voucher, for the Screen Variant select 601 - Journal Entry Voucher.
- press the Add Row button, enter the concerned open item managed G/L Account, the amount of the invoice on the credit side. The offset account is the "dummy" G/L account with on the debit side the amount of the invoice.
The customer invoice is now posted to the open item managed G/L account without the sales sub-ledger and therefore available for clearing.
Keywords
KBA , SRD-FIN-ACR , Receivables , How To