aging report

[Former Member]

hii experts .

while generating aging report for customer and vendor there are following fields like vendor code , vendor name.balance due etc . now i want to generate a aging report which contains pan no. details of vendor along with these fields.

how it is possible .pls update

Regards

Saurav Gupta

[Former Member · Accepted solution]

Hi Saurav.......

You can not incorporate these fields in Aging Report as SAP has not provided such facilty.

But you can encorporate anyhow in your own query report.......

Try this report......

SELECT T0.[DocNum], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], T1.TaxId0, T0.[DocTotal], T0.[PaidToDate], DateDiff (Day,T0.[DocDate], T0.[DocDueDate]) Overdue FROM OPCH T0 LEFT Join CRD7 T1 On T0.CardCode=T1.CardCode
Where T0.[DocTotal]>T0.[PaidToDate] And T0.CardName='[%0]'

Hope this will help you......

Regards,

Rahul

[Former Member · Accepted solution]

thanx rahul ......but i want to generate the report for all the vendor in a single report.

Regards

Saurav gupta

[Former Member]

Hi,

It depends what lelve of aging report you want to change, you can certainly bring through BP's details on the detailed aging report by editing your report layout mager (crystal or pld) to include data from those tables, just depends whether you have enough experience of pld/crystal to do that.