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.