News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How can I run consolid...

Microsoft Dynamics RMS (Archived)

How can I run consolidatated quantiy reports without listing indiviual transactions?

(0) Share

Report

Report

Posted on by Saner

20

Hi,

We have just switched from a G7 EPOS system to Micrsoft RMS and I am finding diffuculty in running reports without listing transactions seperatly.

For example I would like to see how many of a particular item has sold within a catagory, listing On Hand, Description, Qty Sold, ILC, etc but how ever I arrange the coloums I either get the transactions broken down or have to expand through the grouping to view all relevent information which makes it difficult to read.

Hope I am making sense, and any help would be gratefully recieved.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Trent Bourgois on at

Like (0)

Report

Re: How can I run consolidatated quantiy reports without listing indiviual transactions?

Hello Saner,

Thank you for your questions.

It sounds like you are using the Detailed Sales Report.

Have you tried the Item Movement Report? It can be modified to include a column for On Hand. A link to our customization guide can be found below:

https://mbs.microsoft.com/customersource/documentation/setupguides/rmscustomizationguide.htm?printpage=false&sid=rz5bwlwfnpsvfjzct1zmcp2u&stext=customization

Let us know if you have any other questions.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2

Martin Dráb 231,493 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans