cancel
Showing results for 
Search instead for 
Did you mean: 

Paid/Credit on Invoice does not agree.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member708266
Contributor
0 Kudos

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

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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