Skip to Content
0
Former Member
Jun 11, 2009 at 11:33 AM

How we can find out reconciliation details for AR.

110 Views

Hi,

We are adding Manual JE as a receipt against for multiple AR invoices. For these entries we are doing reconciliation but my out standing report itu2019s showing as pending amount. In out standing report how we can identify this manual JE is reconciled against for multiple AR Invoices numbers. If we I identify multiple A/R invoice document number then I can disable both entries i.e., AR Invoices and Manual JE in the outstanding report. In JDT1 table intrnmatch field is storing related to reconcilation but itu2019s not stroing against which document numbers they did ? and also I checked AJDT,AJD1 in this also AR Invoice details and for this automatic JE details also itu2019s not storing how we can solve this issues.please guide me.based on docstaus for AR Invoice we can find out but one more i need make cross check.

SELECT t0.transid, T0.Account, intrnmatch

FROM JDT1 T0

WHERE T0.[TransId] =51162

Regds,

Sampath Kumar.