AR Invoice not reconciled after Credit memo

[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

[jitin_chawla]

Hi,

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

Regards,

Jitin