Skip to Content

AR Invoice not reconciled after Credit memo

Jan 17, 2017 at 12:24 PM


avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jitin Chawla
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



10 |10000 characters needed characters left characters exceeded