Consolidating Items Sold in RMS Reports

(0) Share

Report

Posted on by Jamie Outdoors

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

All responses (2)

Answers (0)

Jamie Outdoors 25 on at

Like (0)

Report

Re: Consolidating Items Sold in RMS Reports

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
Community Member on at

Like (0)

Report

Re: Consolidating Items Sold in RMS Reports

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