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

(0) Share

Report

Posted on by NatRRam

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.

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

DAnny3211 11,334 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NatRRam 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NatRRam 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NatRRam 30 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,740 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
NatRRam 30 on at

Like (0)

Report

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??

Was this reply helpful? Yes No
NatRRam 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,740 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
NatRRam 30 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Mohana Yadav 60,740 Super User 2025 Season 2 on at

Like (1)

Report

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

Book Vendor Ledger Entry

Was this reply helpful? Yes No