Jump to content


KatyCR

Member Since 15 Jan 2007
Offline Last Active Apr 09 2007 10:41 AM
-----

Topics I've Started

Report on # of Gifts

15 January 2007 - 12:51 PM

We ship many gifts from our comany, using the "Gift Order-One or More Address". Some of our customers send something to themself, some send as many as 25 gifts out. We mail catalogs and each catalog is marked with a Source Key. I can easily run a report based on the Source Key that tells me how many "orders" we entered for each Source Key. What I want to know though is how many ACTUAL ORDERS (includes gifts and non-gifts) were placed based on the Source Key...i.e., how many gifts and non-gifts were sent based on the Source Key.

Currently, when I run the report it would tell me that 1 order was placed using Source Key "XXXX". Let's say that that one order actually had 6 gift recipients on it. I want my report to tell me that there 6 orders using that Source Key and not just 1.

Any help with this would be greatly appreciated. Report thru MOM, Report thru Report Writer? Help Please!

Thanks!
Katy