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.
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
But real quick it has no vendor names so now what
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!
yes, some filters maybe mandatory and some are optional
you can leave optional blank
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??
well the reason why i use that filter is because we have numeric and alpha vendor
bt i can always delete
you can leave vendor no. blank if you want to get all vendors.
click preview of the report.
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
Book Vendor Ledger Entry
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156