web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

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

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Trent Bourgois Profile Picture
    Microsoft Employee on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans