I need assistance with running a Vendor Spend report in Business Central. i'm currently using the Vendor Purchase Statistics report but it wont let me filter out the zero balance vendors nor will it allow me to just show the purchase lines. Any ideas?
Hi, I think you can try the Purchase Lines page, if you are the latest BC22, you can use the In-client Analysis mode.More details: https://yzhums.com/35080/
Hope this helps.
Thanks.
ZHU
Hi ZHU. Thanks but we aren't on BC22:-(
Okay, It is recommended to export to Excel for manual statistics.
And, if you consider customization, you can use Excel Layout.More details: https://yzhums.com/23873/
Hope this helps
We dont have that analyze button and when I search Purchase Lines it does not give me every Vendor and their balance as of current.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,377
Jainam M. Kothari 2,696 Super User 2025 Season 2
YUN ZHU 1,512 Super User 2025 Season 2
