web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Vendor Aging Report
Small and medium business | Business Central, N...
Answered

Vendor Aging Report

(0) ShareShare
ReportReport
Posted on by Community Member

Hello, 

Is anyone able to advise me please if there is a Vendor Aging Report available on BC? 

In the Customers area of the system you can view a nice detailed report of the outstanding invoices and how overdue they are, however on the vendors side you only appear to be able to get a total for each vendor with the total value overdue by period. We would like a report that matches the customer one, with details of the overdue invoices owed, by vendor. 

Maybe it's just called something different in BC which is why we are struggling to find this. Or maybe there is a work around to achieve a similar thing? 

Any advice gratefully received. 

Thank you, 

Amy 

I have the same question (0)
  • Jack Carter Profile Picture
    Jack Carter 110 on at
    RE: Vendor Aging Report

    thankyou soo much it helps me too ...

  • Community Member Profile Picture
    Community Member on at
    RE: Vendor Aging Report

    Hi Laeticia, Thanks for such a detailed answer and definitions. This works well. Thanks!

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Vendor Aging Report

    Hi Amy,

    You can find Vendor Aging Report in Business Central. Please see if the follow report can help you.

    In the search button type "Aged Accounts Payable":

    pastedimage1595339798663v1.png

    The system will open the following page:

    pastedimage1595340410481v2.png

    Bellow you can fin an explanation for each field:

    Note: You can find different information, if you are using a different version or Localization.

    Aged as of

    Enter, in MMDDYY format, the date that aging is based on. Transactions posted after this date will not be used in this report. The default is the current date.

    Aging by

    Select Due Date to age by due date, which is the number of days that the transaction is overdue. Amounts not yet due are current. Select Posting Date to age documents by the transaction date, which is the number of days since the transaction posting date. Select Document Date to age documents by the document date, which is the number of days since the document date.

    Period Length

    Enter the length of each of the aging periods. For example, enter 30D to base aging on 30 day intervals.

    Print Amounts in LCY

    Place a check mark in this field if you want the report to specify the aging per vendor ledger entry

    Print Details

    Place a check mark in this field if you want the report to show the detailed entries that add up the total balance for each vendor

    Print Detail

    Select to include individual transactions. Clear this field to include only totals for vendors.

    Heading Type

    Select whether the column heading for the three periods will indicate a date interval or the number of days overdue

    New Page per Vendor

     If you have chosen two or more vendors to be included in the report, enter a check mark to print each vendor balance on a separate page

    Use External Doc. No.

    Select to print the vendor's document numbers, such as the invoice number, on all transactions. Clear this field to print only internal document numbers.

    You will have a report similar to the following image, depending in the fields filled.

    pastedimage1595341483830v3.png

    Hope this can help you to move forward.

  • Verified answer
    Renni Profile Picture
    Renni 960 on at
    RE: Vendor Aging Report

    Hello Amy,

    No problem, did you tick the print details box on the pop up box when entering the details before running?

  • Community Member Profile Picture
    Community Member on at
    RE: Vendor Aging Report

    Hi Paul, Thanks so much for coming back so quickly. It does have the entries by period but unfortunately doesn't give the invoice detail. We are looking for a report of list of all outstanding invoices per vendor. Thanks, Amy

  • Suggested answer
    Renni Profile Picture
    Renni 960 on at
    RE: Vendor Aging Report

    Hello Amy,

    From memory I think there is one called aged accounts payable report that gives a breakdown with the invoices 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,220

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,958

#3
Sumit Singh Profile Picture

Sumit Singh 2,961

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans