Skip to Content
avatar image
Former Member

AR Invoice not reconciled after Credit memo

A/R Invoice document was reversed with A/R Credit Memo document.

The two documents were CLOSED and supposed to be reconciled but A/R Invoice still listed unreconcile under customer account balance and the Invoice value still show in customer Balance Due

Internal Reconciliation list same A/R Invoice for reconciliation.

This issue has happened several times in the past but cannot be reproduce

Base document and Target document icon linked the two close A/R Invoice and A/R Credit Memo documents.

Their SAP user was recently upgraded from Starter Park to full SAP user

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 18, 2017 at 12:53 PM


    Check the following query and see if it has any result and the results have the identified document in it.

    select * from OINV T0 inner join INV6 T1 on T0.DocEntry = T1.DocEntry
    inner join JDT1 T2 on T1.DocEntry =t2.createdby
    where t0.DocTotal=t1.PaidToDate
    and T0.DocStatus ='O' and t1.Status = 'O'
    and T1.PaidToDate = T0.PaidToDate
    and T1.PaidToDate = T2.debit-T2.balduedeb



    Add comment
    10|10000 characters needed characters exceeded