Analysis of trade debtors report

[kinyanjui_kamau]

I would like to make a custom trade debtors report using crystal reports. I have a client that makes on manually and is shown in the excel file I have attached below.

I will want to have an ageing report that has total amounts for debtors in columns per month including other information. See attached file.

Could anyone help me get the table names and fields that contain the required information and any sample queries one may have. Any help appreciated.

[Former Member · Accepted solution]

Hi........

You may use OJDT and Mainly JDT1 table to get your report done.

Here you get complete details you want in your report........

Regards,

Rahul

[kinyanjui_kamau · Accepted solution]

Thanks Rahul.

[KennedyT21]

Hi  Kinyanjui Kamau ,

Have you tried with the Customer Receivable Aging Report which gives you the above said result.

Regards

Kennedy

[kinyanjui_kamau]

Hi Kennedy. I have tried with the customer receivable aging report but the customer requests that it be redone to the format above (attached). I just needed to know the tables/fields needed so I can make my own query and report.