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

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?

All responses (4)

Answers (0)

fmjay256 10 on at

Like (0)

Report

RE: Vendor Spend Report

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.
Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Spend Report

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
fmjay256 10 on at

Like (0)

Report

RE: Vendor Spend Report

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

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Spend Report

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