Question

Debtors Days

S
Rank
Userlevel 6
Badge +9

Looking at reporting our debtors days, is there any reports etc that would be able to show/details this for us?

This topic has been closed for comments

10 replies

Sachin Vithanage
Rank
Userlevel 7
Badge +10

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

K
Rank
Userlevel 6
Badge +8

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.

Dismanthi Dissanayaka
Rank
Userlevel 5
Badge +6

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

S
Rank
Userlevel 6
Badge +9

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

S
Rank
Userlevel 6
Badge +10

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

S
Rank
Userlevel 6
Badge +10

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

Dhananga Jayatilake
Rank
Userlevel 6
Badge +7

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

Thank you and best regards, Dhananga
Heshani Vidanapathirana
Rank
Userlevel 6
Badge +9

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

Amalith Wijewardhana
Rank
Userlevel 5
Badge +7

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

 

Thanks & regards,

Amalith

Thanushi Jayaweera
Rank
Userlevel 7
Badge +15

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

Terms & ConditionsCookie settings