Merging Reports

Feb 08, 2006 2 Replies
A

I hope someone can help me out... I'm looking to create a single report that will essentially merge the results from the following RMS reports: Items - Inventory Movement Report Items - Item Quantity List



I want to see items that have had movement (either received or sold) during the past season OR are still on hand from previous seasons. Currently I have to generate two separate reports, export them to excel, and then manually sort them and remove duplicate information.


Thanks in advance to anyone who can help!


Vote
Twitter Facebook LinkedIn
J

Al,

Here's a report attached that I posted a while back. See if it works for you.

You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. If you are not using a reader, follow the link below to setup Outlook Express. Click on "Open with newsreader" under the M$ Retail Management System on the right.

formatting link

Vote
Twitter Facebook LinkedIn
A

Jeff,

I appreciate the help that is exactly what I am looking for!

The only question I have is there a way to get the department and category lists to "drop down" like they do in other reports? Some of our guys (including myself) are not the best at remembering the exact department and category names.

Thanks again!

"Jeff" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required