Debtors Days

Hi @SMcLees ,

You can use the Customer Ledger Age Analysis report available in Order Report for this purpose.

You can set number of days in each intervals using the below parameters.

The report will look like this

Best Regards,

Sachin

Hi,

Below report will help you to solve the issue.

Financials > Report generator > Order Report
Choose report titled "Customer Ledger Age Analysis"

Kind Regards,

Kalpa.

Hi @SMcLees ,

You may also check whether the Customer Ledger Age Analysis report in Order Reports provides the necessary details for you.

Kind Regards,

Dismanthi

Sorry, @Kalpa Veranga @Sachin Vithanage @Dismanthi Dissanayaka @Sugandi Nadeeshika  I haven’t worded this question.  I’m looking to back date this report and check the details of days it takes to pay

Hi Stephen,

In addition to the ‘Customer Ledger Age Analysis’ report, you may use ‘Customer Aging Analysis’ window as well. This will provide detailed information for each customer. Also, you may use RMB option to go to invoices included in each age bucket.

Best Regards

Sugandi

Hi Stephen,

You may use ‘Cash Flow Forecast’ to identify number of days it might take to pay. 

In ‘Cash Flow Forecast Details’ window, there’s a field named ‘Number of days to event date’ and this will show how many days are pending or have already passed against each cash flow item.

Please let me know if you need further information on creating a cash flow forecast.

Best Regards

Sugandi

As detailed in above replies hope customer ledger age analysis report would be the ideal solution you are looking for.

If you browse to Financials > Report generator > Order Report

there are few other reports for debtor analysis such as customer ledger open items and customer invoices due for payment.

Further if you go to Financials > Account Receivable > AR Analysis that would contain different customer analysis options but not reports.

Also, you could develop your own report generator report as per your requirements.

Thank you,

Dhananga

Hi @SMcLees 

You can use Customer Ledger Analysis for your requirement as everyone has suggested. In addition to that you can use the reports  available in below navigator path in the application;

Financials/Accounts Receivable/AR analysis

Financials/ Customer Credit Management/ Analysis (you can use Customer Aging Analysis and Multi-Company Customer Aging Analysis reports)

Best regards

Heshani

You can use Customer Ledger Age Analysis report in Order Reports in order get the details for your requirement.

Thanks & regards,

Amalith

Dear @SMcLees ,

You will be able to simply achieve this via the Customer Analysis window.
 

• Go to the Customer Analysis window and Query for your Customer.
• Make sure to check the ‘Auto Populate’ checkbox which is highlighted below.
• In this window you will be able to do an analysis of the customer invoices, how much has been paid, how much is due, number of days it takes to pay etc. 
  
   

  

  
  
  However, for the reporting purposes you can use the Order Reports as mentioned above such as the Customer Ledger Age Analysis,  and then use Customer Aging Analysis to do an analysis of your receivables.
  
  Best Regards,
  Thanushi