Customer Receivables Ageing Report

To generate this report select:

  • Business Partner- Business Partner Reports  – Aging –Customer – Receivables aging
  • Financials – Financial Reports – Accounting – Aging
  • You may run this report either by your customers or by your sales employees
  • If you would like to run by customers, check the customer option as shown below:

 

 

 

 

 

 

 

 

If you would like to run by sales employees, check the sales employee option as shown below:

 

 

 

 

 

 

 

 

If you have selected by sales employee, then the bottom options to select customer groups and properties will automatically hidden.

 

You can either select a range from one business partner to another, or leave the, from and to options in the code fields blank for all business partners to be included in report.

 

 

 

 

 

 

 

 

 

 

Under customer group you are also given the option to select customers from the certain customer groups you have already set up.

 

 

 

 

 

 

 

 

 

 

If you click on the property button, a list of all the properties will be available, if you have setup properties for your business partners and would like to run this report on those properties uncheck the ignore all option and check the properties you would like to use. If not leave the ignore all option checked and click ok.

 

 

 

 

 

 

 

 

 

 

You may run this report according to control accounts as well, if you would like to do so, when checking the control account option, a list of control accounts will automatically pop up. When trying to balance back to a historical value for the control account the “0 balances” must be ticked.

 

 

 

 

 

 

 

 

 

 

Choose the control accounts you would like to run the report by checking the choose option for each account and then click ok.

 

 

 

 

 

 

 

 

 

 

 

Aging date: enter the date at which you would like to run this report, this would usually be the current date, which is therefore set as default, while you may choose a different date if you like. An example of why you would change the date would be: setting the date a week forward in case you want to display all receivables that are due for payment during the following week.

 

The interval option allows you to view your Aging report in days, months or periods, it should usually be run in months.

 

 

 

 

 

 

 

 

 

 

 

You can run this report by:  Posting date, due date or document date

 

If you would like to view all customer receivables to that aging date only fill in the “to” field in posting date and leave the from date blank, otherwise you may specify the period according to your preference.

 

 

 

 

 

 

 

 

 

 

Display Customers with Zero Balance = Includes customers with a zero balance in the report, if you would like to view all customer receivables, without excluding any history this should always be checked.

 

Display Reconciled Transactions = Displays reconciled journal entries of the accounting documents generated for the customers.

 

Ignore Future Remit = Hides the Future Remit column in the report and excludes transactions that have a value in this field

 

 

 

 

 

 

 

 

 

 

This is an example of how your Customer Receivables Report would look: