News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Is there a way to sort...

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

Answered

Is there a way to sort by Unit Measure sold per month?

(1) Share

Report

Report

Posted on by RH

166

We are using 'kg' for our products. I've been trying the past week or so searching all the out-of-box both Dynamics panes and "web services" but they're all showing financials. What's an easy way to sort by total unit measure/kg sold per month by customer. I know I might have to do some Excel for this. We are not using Power BI so I am trying to see another way to do this.

Thanks in advance.

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Valentin Castravet 24,793 Super User 2024 Season 2 on at

Like (0)

Report

Is there a way to sort by Unit Measure sold per month?

You can get this from the Item Ledger Entries Page. Filter on the unit of measure code, posting date, and entry type=sale. You can then use the source no. field to see the customer no.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Yi Yong 1,359 Super User 2024 Season 2 on at

Like (1)

Report

Is there a way to sort by Unit Measure sold per month?

Hello,

I assumed 'KG' is the base unit of measure for all of the products.

You can try using 'Sales Analysis Reports' module with customers as Row and quantities sold as Column.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans