Merging Reports

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!

Reply to
AL
Loading thread data ...

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

Reply to
Jeff

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:

Reply to
AL

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.