Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Creating a Customer Li...
Microsoft Dynamics RMS (Archived)

Creating a Customer List which includes Total Sales, Total Visits, Their Zip Code, and has an adjustable Date Range

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are getting ready to open our second hobby store (Yay for us!) and I want to create a sales projection model based on current customers.  Many of our current customers travel 20-25 minutes, from the direction where the new store will be. 

We currently use Microsoft Dynamics RMS 2.0.2000 in the store.  We want to be able to run a report that gives me their First Name, Last Name, Account Number, Total Sales within a Specified Date Range, Total Number of Visits within that same Date Range, the Customer's Zip Code, and their E-mail Address.

I do not know how to "create" my own query in RMS Administrator, but I have had others create the code for me, at which time I can get it into Administrator and run it from there.

Is someone willing to lend a small business a hand?  We are VERY excited at this future opportunity, but want to make sure we have a reasonable sales projection model.

Thanks in advance,

Rob Placer - Owner

Family Fun Hobbies

www.familyfunhobbies.com

sales@familyfunhobbies.com

*This post is locked for comments

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Creating a Customer List which includes Total Sales, Total Visits, Their Zip Code, and has an adjustable Date Range

    Hi Robert.

    The Customer list report has a "static" info on Total Sales or Total visits. Meaning is reading only the Customer table, where You only have Customer generic data and accumulated sales data...

    If You want to achieve this info within a specific range dates, You (or a RMS Partner) will need to modify a Sales report, probably the Detailed sales report, extend it with Customer data and keep an filter based on Transaction Date, to sum the totals and visits… It is not hard, but few hours of work is needed for sure. I would also recommend You talk to an RMS Partner to do this for you, if You are not familiar with SQL and the RMS tables...

    Best regards, A.

  • Suggested answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Creating a Customer List which includes Total Sales, Total Visits, Their Zip Code, and has an adjustable Date Range

    Run Store Operations Manager > Reports > Customer > List.

    Click OK to run report then select Show/Hide Columns icon in report toolbar to enable the columns you'd like shown. You can also filter by date range of Last Visit.

    To further manipulate the data in Excel select the Export icon in the toolbar.

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,645 on at
    RE: Creating a Customer List which includes Total Sales, Total Visits, Their Zip Code, and has an adjustable Date Range

    Hi Rob and congrats on opening the 2nd location!  Do you have access to Crystal Reports (or someone who knows how to create custom/memorized reports in SQL)?  The report that you need can be created using Crystal Reports or a similar database tool very easily. This is something that your Microsoft Dynamics RMS Partner should be able to do for you as well for a nominal charge. If you do not have a Microsoft Dynamics RMS Partner, then our tech team at RITE would be happy to assist you: 888-267-7483. Please let me know if I can be of furether assistance. Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans