Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To report or analyse Customer Aging, there are 3 reports available in Business Central:

  • Customer Detailed Aging

  • Customer - Summary Aging

  • Customer - Summary Aging Simp.

Customer Detailed Aging Report

The Customer Detailed Aging report displays the balances that are due from customers, sorted by date interval, or aging period.

Steps

  • Search for Customer Detailed Aging Reoport (in the category Report and Analysis)

Image RemovedImage Added
  • When you click on the link, following window opens

  • First filter that can be used is a Filter on Ending Date in category Options

  • You can use filter on Customer No., Customer Posting Group and many more Customer related fields from the list:

  • You can also filter totals by:

    • Currency Filter

    • date Filter

    • Global Dimension 1 and 2 Code

    • Ship-to Filter

  • You will run the report by clicking on:

    • Send to - you can choose from many options (PDF Document, XML Document,…)

    • Print

    • Preview

Image RemovedImage Added

Document Appearance

Customer - Summary Aging report

The Customer - Summary Aging report displays the balances that are due from customers, sorted by ending date.

Steps

  • Search for Customer Detailed Agigng Report (in the category Report and Analysis)

Image RemovedImage Added
  • When you click on the link, following window opens:

Image RemovedImage Added
  • In the category Options, user can filter the results based on Starting Date, Period Length and it can be also switched on or switched off if user wants to Show Amounts in LCY (local currency)

Image RemovedImage Added
  • You can also filter on Customer No., Search Name, Customer Posting Group and many more fields from the list:

Image RemovedImage Added
  • You can also Filter totals by:

    • Currency Filter

    • Date Filter

    • Global Dimension 1 and 2 Code

    • Ship-to Filter

Image RemovedImage Added
  • You will run the report by clicking on:

    • Send to - you can choose from many options (PDF Document, XML Document,…)

    • Print

    • Preview

Image RemovedImage Added

Document Appearance

Customer - Summary Aging Simp.

The Customer - Summary aging Simp. report displays the balances that are due from customers, sorted by ending date.

Steps

  • Search for Customer Detailed Aging Simp. Report (in the category Report and Analysis)

Image RemovedImage Added
  • When you click on the link, following window opens

Image RemovedImage Added
  • In the category Options, user can filter the results based on Starting Date:

Image RemovedImage Added
  • You can also filter on Customer No., Search Name, Customer Posting Group and many more fields from the list:

Image RemovedImage Added
  • You can also Filter totals by:

    • Currency Filter

    • Date Filter

    • Global Dimension 1 and 2 Code

    • Ship-to Filter

Image RemovedImage Added
  • You will run the report by clicking on:

    • Send to - you can choose from many options (PDF Document, XML Document,…)

    • Print

    • Preview

Image RemovedImage Added

Document Appearance