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