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

(1) Share

Report

Posted on by RH

452

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.

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Yi Yong 2,704 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,670 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No