cancel
Showing results for 
Search instead for 
Did you mean: 

AR/AP Aging report problem

Former Member
0 Kudos

Dear All,

I am very wondering why the result in the AR/AP Aging report is not as same as G/L account balance ? Pls give advice. TIA

Rgd,

John

Accepted Solutions (1)

Accepted Solutions (1)

former_member186095
Active Contributor
0 Kudos

I am sure it is caused by several things. You could try to read the SAP note # 752261. The note explains about "Business partner balance does not match journal entries". Let me know if you find difficulties to understand it.

Rgds,

Former Member
0 Kudos

Hi All,

There are 4 types of query in the notes:

1. Closed_document_with_open_JE

2. inconsistent_reconciliation

3. incorrect_bp_balance

4. potential_reconciliation

I run them and they gave results but the fourth are still confusing to me. Could you describe to me ?

former_member186095
Active Contributor
0 Kudos

This is the query of the fourth :

-


RCT----


select T0.ObjType PaymType,T2.DocNum PaymNum

,T0.CardCode

,T0.DocDate PaymRefDate,T0.DocDueDate PaymDueDate

,T0.DocCurr PaymCurr,T0.DocTotal PaymTotal,T0.DocTotalFC PaymtotalFC

,T1.IntrnMatch PaymIntM

,T3.IntrnMatch InvIntM

,T4.BaseRef InvNum,T4.TransType InvType

,InvRefDate =

CASE T2.InvType

WHEN 13 THEN T5.DocDate

WHEN 14 THEN T6.DocDate

ELSE T4.RefDate

END

,InvDueDate =

CASE T2.InvType

WHEN 13 THEN T5.DocDueDate

WHEN 14 THEN T6.DocDueDate

ELSE T4.DueDate

END

,InvTotal =

CASE T2.InvType

WHEN 13 THEN T5.DocTotal

WHEN 14 THEN T6.DocTotal

ELSE T4.LocTotal

END

,InvTotalFC =

CASE T2.InvType

WHEN 13 THEN T5.DocTotalFC

WHEN 14 THEN T6.DocTotalFC

ELSE T4.FcTotal

END

,InvPaid =

CASE T2.InvType

WHEN 13 THEN T5.PaidToDate

WHEN 14 THEN T6.PaidToDate

ELSE T4.LocTotal

END

,InvPaidFC =

CASE T2.InvType

WHEN 13 THEN T5.PaidFC

WHEN 14 THEN T6.PaidFC

ELSE T4.FCTotal

END

,T2.SumApplied Applied,T2.AppliedFC AppliedFC

from RCT2 T2

inner join ORCT T0 on T0.DocEntry = T2.DocNum

inner join JDT1 T1 on T1.TransId = T0.TransId

and T1.ShortName = T0.CardCode

inner join JDT1 T3 on T3.TransType = T2.InvType

and T3.CreatedBy = T2.DocEntry

and T3.ShortName = T0.CardCode

inner join OJDT T4 on T4.TransId = T3.TransId

left outer join OINV T5 on T2.InvType = 13

and T5.DocEntry = T2.DocEntry

left outer join ORIN T6 on T2.InvType = 14

and T6.DocEntry = T2.DocEntry

where T0.Canceled = 'N'

and not (T1.IntrnMatch <> 0 and T1.IntrnMatch = T3.IntrnMatch)

and not (T1.IntrnMatch < 0 and T3.IntrnMatch < 0)

-


VPM----


UNION

select T0.ObjType PaymType,T2.DocNum PaymNum

,T0.CardCode

,T0.DocDate PaymRefDate,T0.DocDueDate PaymDueDate

,T0.DocCurr PaymCurr,T0.DocTotal PaymTotal,T0.DocTotalFC PaymtotalFC

,T1.IntrnMatch PaymIntM

,T3.IntrnMatch InvIntM

,T4.BaseRef InvNum,T4.TransType InvType

,InvRefDate =

CASE T2.InvType

WHEN 18 THEN T5.DocDate

WHEN 19 THEN T6.DocDate

ELSE T4.RefDate

END

,InvDueDate =

CASE T2.InvType

WHEN 18 THEN T5.DocDueDate

WHEN 19 THEN T6.DocDueDate

ELSE T4.DueDate

END

,InvTotal =

CASE T2.InvType

WHEN 18 THEN T5.DocTotal

WHEN 19 THEN T6.DocTotal

ELSE T4.LocTotal

END

,InvTotalFC =

CASE T2.InvType

WHEN 18 THEN T5.DocTotalFC

WHEN 19 THEN T6.DocTotalFC

ELSE T4.FcTotal

END

,InvPaid =

CASE T2.InvType

WHEN 18 THEN T5.PaidToDate

WHEN 19 THEN T6.PaidToDate

ELSE T4.LocTotal

END

,InvPaidFC =

CASE T2.InvType

WHEN 18 THEN T5.PaidFC

WHEN 19 THEN T6.PaidFC

ELSE T4.FCTotal

END

,T2.SumApplied Applied,T2.AppliedFC AppliedFC

from VPM2 T2

inner join OVPM T0 on T0.DocEntry = T2.DocNum

inner join JDT1 T1 on T1.TransId = T0.TransId

and T1.ShortName = T0.CardCode

inner join JDT1 T3 on T3.TransType = T2.InvType

and T3.CreatedBy = T2.DocEntry

and T3.ShortName = T0.CardCode

inner join OJDT T4 on T4.TransId = T3.TransId

left outer join OPCH T5 on T2.InvType = 18

and T5.DocEntry = T2.DocEntry

left outer join ORPC T6 on T2.InvType = 19

and T6.DocEntry = T2.DocEntry

where T0.Canceled = 'N'

and not (T1.IntrnMatch <> 0 and T1.IntrnMatch = T3.IntrnMatch)

and not (T1.IntrnMatch < 0 and T3.IntrnMatch < 0)

-


RIN----


UNION

select T0.ObjType PaymType,T0.DocNum PaymNum

,T0.CardCode

,T0.DocDate PaymRefDate,T0.DocDueDate PaymDueDate

,T0.DocCur PaymCurr,T0.DocTotal PaymTotal,T0.DocTotalFC PaymtotalFC

,T1.IntrnMatch PaymIntM

,T3.IntrnMatch InvIntM

,T4.BaseRef InvNum,T4.TransType InvType

,InvRefDate = T5.DocDate

,InvDueDate = T5.DocDueDate

,InvTotal = T5.DocTotal

,InvTotalFC = T5.DocTotalFC

,InvPaid = T5.PaidToDate

,InvPaidFC = T5.PaidFC

,T0.DocTotal Applied,T0.DocTotalFC AppliedFC

from RIN1 T2

inner join ORIN T0 on T0.DocEntry = T2.DocEntry

inner join JDT1 T1 on T1.TransId = T0.TransId

and T1.ShortName = T0.CardCode

inner join JDT1 T3 on T3.TransType = T2.BaseType

and T3.CreatedBy = T2.BaseEntry

and T3.ShortName = T0.CardCode

inner join OJDT T4 on T4.TransId = T3.TransId

inner join OINV T5 on T5.DocEntry = T2.BaseEntry

where T2.BaseType = 13

and not (T1.IntrnMatch <> 0 and T1.IntrnMatch = T3.IntrnMatch)

and not (T1.IntrnMatch < 0 and T3.IntrnMatch < 0)

-


RPC----


UNION

select T0.ObjType PaymType,T0.DocNum PaymNum

,T0.CardCode

,T0.DocDate PaymRefDate,T0.DocDueDate PaymDueDate

,T0.DocCur PaymCurr,T0.DocTotal PaymTotal,T0.DocTotalFC PaymtotalFC

,T1.IntrnMatch PaymIntM

,T3.IntrnMatch InvIntM

,T4.BaseRef InvNum,T4.TransType InvType

,InvRefDate = T5.DocDate

,InvDueDate = T5.DocDueDate

,InvTotal = T5.DocTotal

,InvTotalFC = T5.DocTotalFC

,InvPaid = T5.PaidToDate

,InvPaidFC = T5.PaidFC

,T0.DocTotal Applied,T0.DocTotalFC AppliedFC

from RPC1 T2

inner join ORPC T0 on T0.DocEntry = T2.DocEntry

inner join JDT1 T1 on T1.TransId = T0.TransId

and T1.ShortName = T0.CardCode

inner join JDT1 T3 on T3.TransType = T2.BaseType

and T3.CreatedBy = T2.BaseEntry

and T3.ShortName = T0.CardCode

inner join OJDT T4 on T4.TransId = T3.TransId

inner join OPCH T5 on T5.DocEntry = T2.BaseEntry

where T2.BaseType = 18

and not (T1.IntrnMatch <> 0 and T1.IntrnMatch = T3.IntrnMatch)

and not (T1.IntrnMatch < 0 and T3.IntrnMatch < 0)

The query is not certainly correcting the inconsistent reconciliation, but you must peform manually. I will return to give you better solution. The important things are it will display the incorrect recconciliation.

Rgds,

Answers (0)