You’re offline. This is a read only version of the page.
I would like a Summary Sales Report that includes "Company" field. We participated in a homeschool fair last year, where we added "IDEA" to the Company name for each customer we sold to. We are doing the fair again this year and I would like to see a summary of all items sold to "IDEA" customers.
I cannot find any stock reports where "company" is a field.
Thanks, Ed
*This post is locked for comments
Thank you for the additional work to reveal the best solution. I appreciate your effort.
Glad you resolved your report issue.
The reports I suggested only show total sales, but another DRS report appears to meet your needs. It is called Sales Commission Report. You'll have to enable the columns you want and rearrange them. You can filter by Company IDEA and Date sold. The report will list sales by customers including line item details and summary sales totals.
Hi TheNeos.
Thank you for your effort. I have been able to generate a report containing the information I am looking for. I appreciate you taking the time to help me solve my problem.
Ed
Thank you RMS Wizard.
I currently own the customized reports from DRS, but was unable to generate any reports containing both "Company" and "summary sales". Specifically, I am wanting to know the description and quantity of all items sold to IDEA customers during the event. I reviewed both reports, but neither gives me the results I am needing.
I have created a rather obvious (now) solution by simply filtering to the POS we used at the Fair over the 2 day event.
I appreciate you taking the time and your suggestions. They got me to the right area and helped me with my solution.
Ed
Hello,
I have 2 reports that may be of help to you.
Memorized-IDEA by Item Detailed Sales R.qrp, groups by Item includes Company & Account #, all filters as per Sales Detail report.
Memorized-IDEA by Company Detailed Sales.qrp, groups by Company as above.
if interested please email me to send you these as attachments. theos.sif727@gmail.com
Cheers
If you don't have a lot of IDEA entries to modify one way to accomplish your goal would be to edit those accounts and add -IDEA to the end of the account number. For example, change account 1000202 to 1000202-IDEA.
Then you can run any sales report with Account# filter set to Contains IDEA.
Another option would be to purchase this custom reports bundle ($19USD): https://goo.gl/d5hDyM
I found two reports that list sales totals and include a Company filter. The Top Customers Report includes a Date Sold filter while the Customer List Detail report shows total sales to date.
You will find custom reports under Store Operations Manager, Reports, Custom after installation. Close Manager and start it again if you don't see them.
Hi Danny,
Thanks for sticking with me here. How can I find the information you are asking? I never use Crystal reports (willing to try if the solution lies there).
Thanks,Ed
Hi Ed
What version of Crystal Reports do you need for RMS 2.0.2007?
Thanks
Danny
Hi Danny,
I am currently using RMS 2.0 version 2.0.2007
Thanks, Ed
Ed
What version of Crystal Reports do you need for RMS 1.3/2.0?
Danny
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (