Skip to Content
0
Former Member
Jan 13, 2011 at 03:21 PM

Customer Ageing Report

27 Views

Hi Guys,

In SBO there is a report called Customer Receivables Ageing, our auditors have demanded that we are able to break the information in the repot down further, currently it reports the data as follows:

0-30 Days

31-60 Days

31-90 Days

91-120 Days it then lumps everying older into

120+ Days

Our auditors need the 120+ Days Breaking down further i.e

121-150 Days

151-180 Days

181-210 Days

I have looked at this report only to discover that it is founded on variables which leaves me stuck as I have no clue on those yet. I did try to write a query to give me this information but not with much success as I need it presented in the same format as the Customer Recievables Aging Report. This was my attempt:

SELECT T0.DocNum, T0.DocDate, T0.CardCode, T0.CardName, T0.DocTotal, T0.PaidSum, T0.PaidToDate FROM OINV T0 WHERE datediff(DD, T0.DocDate , getdate())>180 and T0.DocStatus = 'O'

Is there anyway of getting this information in a query or is there simply another report in SAP that I am just missing.

Sean Martin