Skip to main content



No record found.

Business Central forum

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

Posted on by 58
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.
  • Valentin Castravet Profile Picture
    Valentin Castravet 7,792 Super User on at
    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.
  • Yi Yong Profile Picture
    Yi Yong 287 on at
    Is there a way to sort by Unit Measure sold per month?
    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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans