How to add total average days to pay to the Time Taken To Pay Sales Invoices report and the Time Taken To Pay Purchase Invoices report

How to add total average days to pay to the Time Taken To Pay Sales Invoices report and the Time Taken To Pay Purchase Invoices report

 

The following two reports show how long it’s taken for an invoice to be paid and calculates the average number of days taken to pay per customer or supplier.

  • Customers > Reports > Credit control reports > Time Taken To Pay Sales Invoices report.
  • Suppliers > Reports > Credit control reports > Time Taken To Pay Purchase Invoices report.

A common request is to add a total to these reports to show the average number of days taken to pay across all invoices. This article takes you through how to add a total for the average days to pay invoices on the Time Taken To Pay Sales Invoices report and also the Time Taken To Pay Purchase Invoices report as the method is the same.

 

Open the report in Sage Report Designer

 

1. Customers or Suppliers > Reports > Credit control reports.

2. Select the required report > Edit.

 

Add the average total

 

1. ACCOUNT_REF Footer > right-click the expression Average_Days_To_Pay > Copy > Report Footer > right-click > Paste.

2. Properties pane > Reset Section > check that Report Footer is selected.

 

 

Save the report

1. Report menu > Report Properties > enter a new report name and description > OK.

Report Designer v1.3 and below – Report Explorer pane > select report name at the top > Properties pane > Name > enter a new report name > Enter.

 You can check your Report Designer version in Help > About > Application > File Version. 

2. File > Save As > select correct folder > File name > enter a new file name > Save.

3. File > Exit.

 

 

 

 

 

 

Pimbrook Software
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.