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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Consolidating Items Sold in RMS Reports

(0) ShareShare
ReportReport
Posted on by 25

Hello,

We have just started up with RMS after upgrading from Quicksell 2000. When I take a sales report it obviously gives me each item sold, but if we've sold multiple quantities of the exact same item, it lists that item multiple times (example: if we've sold 6 of a certain t-shirt in black large, it lists it 6 times). I would like it to only show that item once with a quantity sold beside it. Is this possible? This was the default method of our old reporting system, and it makes the reports less detailed, but much easier to read when I just want to know how many of that specific item we've sold.

Thanks in Advance, Jamie 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    you will need to customiz the detailed report or get a new one. now you can use the grouping method by adding itemlookupcode in the first column then group by first column and you will have summitions for each item.

     

    Mohammed El-Qadi

    http://www.fact.fm/viewforum.php?f=30

  • Jamie Outdoors Profile Picture
    25 on at

     Thanks for the response, I changed the columns so the lookup code or description are first and then grouped them and that worked pretty well. The only thing it doesn't give me is the price of the item (I guess it can't because the items may have been sold at different prices, but it would be nice if it showed the regular price)

    Thanks again, Jamie 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans