Hi all- Extensive heavy-duty user of RMS and regular custom-creator of reports, but can't seem to find a way to manage this one.
I have item XYZ and I've identified it as not a highly profitable item, but possibly an item that my customers purchase alongside other higher margin products. The item has hundreds of movements in the Movement History report. How can I run a report to show either:
a.) The total sales ticket value of all transactions which include XYZ item.
-or- b.) A list of other items (along with cost and sold price) which were purchased over a set period along with this item on the same ticket.
Any possibility of this?