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

Sales by Vendor by Date

(0) Share

Report

Posted on by raerae

Looking for a report for item sales by vendor - similar to item sales statistics, but looking to figure out which vendor/brand is responsible for the most sales.

Reports I have found have some good results but you can't narrow down the date.

Need the report to sync into Power BI

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

For this custom the report as per the business requirement.

Regards

Amit Sharma

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Then the best option is to create a query and then base your Power BI report on the dataset you return from your query.

learn.microsoft.com/.../devenv-query-object

Was this reply helpful? Yes No
raerae 5 on at

Like (0)

Report

Thanks Inge - would you recommend using a query already made and modifying it? I did try to make one based off Item Sales but was unable to link a posted date field to it.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I would definitely make a new one so you have full control of your dataset and your relations.

Was this reply helpful? Yes No
raerae 5 on at

Like (0)

Report

Thank you, I will try that!

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Good luck!

Let us know if you need any assistance in creating the query.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

Hi, just adding some info.

If you use Query, you can also display it directly on the page without Power BI.

More details:

QueryCategory property – Smartlist? (Execute Queries from Pages)

https://yzhums.com/3206/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No