on 11-06-2008 1:24 AM
Hi,
My client is using SAP 2005 SP 1 Patch 42.
He has an invoice $85000.
Incoming payment against this invoice is $25000 and $20000.
The Balance of this invoice should be $40,000.
However, when I go to the invoice, Paid/Credit = $85000 and the Balance due = 0.
I have checked there is no Credit Note raised against this invoice.
Any suggestion on how I can find out what is going on?
Thanks in advance for your help.
Dear,
Have you ever used the function of link invoices to payments?
Is yes, please refer to the note below:
1087355:
Symptom
You create an incoming\outgoing payment, not based on an invoice
(Payment on Account check box is selected).
Then you link a partial amount of an A/P or A/R invoice to the payment
via the Link Invoices to Payment function.
When you link the Invoice again to the payment, in order to close the
remaining amount, the paid\credited field on the Invoice and the balance
due field on the Incoming Payment are incorrect.
As a result, the Invoice remains open and can be paid again.
Other terms
Incoming Payment, Payment on Account, balance due, paid/credited, cancel
Reason and Prerequisites
Application error.
Solution
Workaround: Close the Invoice against the Payment using the Internal
Reconciliation function.
This issue has been fixed in 2005 B PL38/ 2005 A SP01 Patch 43
Wish the information above could solve your issue.
Regards
Apple
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,.
Is there a way that I can check whether the user has linked payment to this particular invoices?
Otherwise, I have to take his words that it is not done for this particular invoice.
Anway, the invoice is already closed because in the invoice, the balance due = 0.
Could you please explained further re the notes.
From my testing, performing internal reconciliation will not reopen the document.
So, when I am doing Internal Reconciliation, is this what I should do:
1. Matching the invoice to the receipt + create a journal entry to reduce the debtor balance.
Eg: Invoice = 100
Receipt = 80
Journal Entry = 20. (Credit debtors, Debit suspense account).
2. When I run the customer statement either by Journal Entry or by Sales Document, the statement balance is the same. However, it is the wrong balance because I should have $20 outstanding.
3. To record I still have $20 outstanding, I need to create a journal entry
Dr Cxxxx
Cr suspense account.
Please confirm whether this is the way to go.
Edited by: Rui Pereira on Dec 9, 2008 4:54 PM
Hi,
What is the document status of the AR Invoice?
If it is CLOSED and only partial payments were made based on the Incoming Payment documents, therefore a RECONCILIATION was performed. Go to Manage Previous External Reconciliation to validate it.
Laurence Resubal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.