How to create customer aging report in crystal report?

[Former Member]

I am new in crystal report. I want to create a crystal report of customer aging report.

I want in column only (docdate,docnum, balance due, but not incoming payment of customer, days in the form of   (duedate to getdate shows in days e.g. 112 days)

Docnum           Docdate                   Outstanding Amount           Aging Days

Total Balance due amount.

How to create this type of report in crystal report. Please Solve this issue. How to calculate only balance due amount of customer.  Which table is required?

Please give me some suggestion.

Thanks

Anshul

[Former Member]

hi John,

do you know? please provide me solution.

How to print invoice with different headers in crystal report?

[Former Member]

Sorry for late reply.

Select docnum, docdate from OJDT and inner join with JDT1...and for outstanding amount, Make Formula like, Outstanding Amount= sum(debit)- sum(credit)..and for days,-- datediff(d, docdate, currentdate)..

Regards

Anshul

[Former Member]

HOW TO MAKE FORMULAS TO COME UP WITH THE BALANCE DUE AMOUNT? THE INFORMATION I NEEDED FOR THE CRYSTAL REPORTS ARE AS FOLLOWS

CARD CODE

CARD NAME

ITEM

INSTALLMENT

BALANCE

TOTAL PAYMENT

BALANCE DUE (0-30-60-90-120DAYS)

I HAVE ALREADY MADE EXCEPT FOR THE BALANCE DUE AMOUNT,SINCE I CAN NOT FIND IT IN THE DATASOURCE..AND THAT AS TO YOU,I HAVE TO MAKE FORMULA TO COME UP WITH IT.....I DONT KNOW HOW.

THANKS,

JOHN

[Former Member]

hi

have you solved this issue?

[Former Member]

I solved by myself..

[Former Member]

HOW? CAN YOU TECH ME HOW TO