Supplier / Vendor Age Ananlysis at a certain date

Owned by Nora Nemcova (Unlicensed)
Last updated: Aug 02, 2022
3 min read

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

  • Vendor - Summary Aging

  • Aged Accounts Payables

 

Vendor - Summary Aging Report

Steps

  • Search for Vendor - Summary Aging Report (in the category Report and Analysis)

 

  • When you click on the link, following window opens

 

  • Category Options: First filters that can be used are Filters on: Starting Date, Period Length and you can also switch on/off the option to Show Amount in LCY (Local Currency)

 

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

 

  • You can also filter totals by:

    • Currency Filter

    • Date Filter

    • Global Dimension 1 and 2 Code

 

  • You will run the report by clicking on:

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

    • Print

    • Preview

 

Document Appearance

 

Aged Accounts Payable Report

Shows a list of aged remaining balances for each vendor by period.

Steps

  • Search for Aged Accounts Payable Report (in the category Report and Analysis)

 

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

 

  • In Category Options some set-up for the report can be done. User can filter on these values:

    • Aged As Of (choose a date)

    • Aging by: choose from options Due Date, Posting Date, Document Date

    • Period Length (use number and shortcut → D = day, M = month, y = year)

    • choose if you want to Print Amounts in LCY (Local Currency)

    • choose if you want to Print Details

    • Heading Type: choose from options Date Interval or Number of Days

    • choose if you want a New Page per Vendor

    • choose if you want to Use External Document No.

 

  • You can use filter on Vendor No. and many more fields from the list: which opens after clicking on:

 

  • You can also filter totals by:

    • Currency Filter

    • Date Filter

    • Global Dimension 1 and 2 Code

 

  • You will run the report by clicking on:

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

    • Print

    • Preview

 

Document Appearance