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

All responses (7)

Answers (0)

Sort by

Suggested answer

Amit Baru 3,043 on at

Like (0)

Report
Copy link

Link copied!

Hi,

For this custom the report as per the business requirement.

Regards

Amit Sharma
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
raerae 5 on at

Like (0)

Report
Copy link

Link copied!

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

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

Thank you, I will try that!
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Good luck!

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

YUN ZHU 103,660 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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