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

(1) Share

Report

Posted on by RH

396

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)

Yi Yong 2,555 Super User 2025 Season 2 on at

Like (1)

Report

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 31,340 Super User 2025 Season 2 on at

Like (0)

Report

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