Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

I need a report that shows how much we have spent with our vendor between a certain time frame

Posted on by 30

Hello, I am having a hard time finding a report for what I need. 

I need to have a report that shows for each one of the vendors we have the following information

-amount spent between a certain time period

-how they were paid with in that time period

-how many bills we have in the system for them in that time period

-there information (Name and Address)

Please help I have been tasked this project so that I can fail. That is how I look at it. I have no guidance so if you could help me that would be awesome. 

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    hi

    look this

    learn.microsoft.com/.../purchase-reports

    DAniele

  • NatRRam Profile Picture
    NatRRam 30 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    So i get it but this report needs to be broken down a little more because within each date i need the vendors and how much $$ was contributed to each vendor

  • NatRRam Profile Picture
    NatRRam 30 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    But real quick it has no vendor names so now what

  • NatRRam Profile Picture
    NatRRam 30 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    you are awesomely awesome. Thank you so much. I have another question now for my next project. I believe though its probably best to start a new discussion so it is easily found if somebody else has that same question. Right? New to the community!

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,133 Super User 2024 Season 2 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    yes, some filters maybe mandatory and some are optional

    you can leave optional blank

  • NatRRam Profile Picture
    NatRRam 30 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    Just so i know for the future when using the reports if i add a filter and leave it blank it will put up stuff still....it does not need to have something typed in it in order to pull information??

  • NatRRam Profile Picture
    NatRRam 30 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    well the reason why i use that filter is because we have numeric and alpha vendor

    bt i can always delete

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,133 Super User 2024 Season 2 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    you can leave vendor no. blank if you want to get all vendors.

    click preview of the report.

  • NatRRam Profile Picture
    NatRRam 30 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    Yes score....

    WE are in LOL.

    Now please help me with the filters. These really mess me up LOL

    okay i need to use filters to get the following information on the report

    1. DATE RANGE NEEDED: 01.01.2022 to 12.31.2022

    2. Vendor NO. to only be ALPHA: aaaa.00 to zzzz99 (and that has worked for me for other reports) so I will use that again.

    3. So, within the date range in #1 with also the filter of #2 I need to know how many invoices we entered into BC for each vendor

    4. Last is the total amount we paid out to each vendor due to the amount on the invoices we put into BC

    Does that make sense? I tried explaining it the best i could

    And again thank you so much for your help

  • Mohana Yadav Profile Picture
    Mohana Yadav 59,133 Super User 2024 Season 2 on at
    RE: I need a report that shows how much we have spent with our vendor between a certain time frame

    Book Vendor Ledger Entry

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans