Vendor Spend Report

(0) Share

Report

Posted on by fmjay256

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?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

YUN ZHU 99,660 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
fmjay256 10 on at

Like (0)

Report
Copy link

Link copied!

Hi ZHU. Thanks but we aren't on BC22:-(

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,660 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Thanks.

ZHU

Was this reply helpful? Yes No
fmjay256 10 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No