Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Basic Reports - Where Can I find them?

Posted on by Microsoft Employee

I am finding myself extremely frustrated with this product. I need to run three basic reports and would prefer not to have to call and use my support hours every time I need the simplest, retail-necessary report. Here's what I need....

  • Daily Sales Year over Year - I basically want a report of my total daily sales for the same month last year
  • Customer Count by Day and historically
  • Average Ticket by Day and historically

I can find graphs with this info on my register, but no way to run a report on this basic info. Help!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Basic Reports - Where Can I find them?

    Do you still have a copy of this report and is it possible for you to share that?

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Basic Reports - Where Can I find them?

    Is store report or HQ? :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Basic Reports - Where Can I find them?

    Wonderful! What specific info do you need? Here is basically what I am looking for, and it is possible it could be achieved with one report. I would like to be able to look historically at each day and see my total daily sales, average ticket and customer count for that day. I'd like to be able to run it for a single day or for a month, year, etc. I need the report to compare my sales data to the previous year for any give day, month, etc. I don't need it to tell me the specific items sold, just the overall sales amount. Feel free to email me directly at mariah@northlandparty.com if that is easier!

    Thank you!

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Basic Reports - Where Can I find them?

    Hello i can help you with the reports you need, just send me the details :D

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Basic Reports - Where Can I find them?

    Thank you! I am baffled that these reports would not be standard. They are basics of retail. I have RMS SO (Store Operations?) I believe.

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Basic Reports - Where Can I find them?

    Hi there.

    Thanks for posting your question, for sure you will find the help You need.

    OK, about the reports: what are you after is not in the Standard Product, so You have to talk to your RMS Parner to build this reports for You (in Active Report, Excel or SSIS format...).

    Give me few days to see what I have done for some customers in the past, I may find something for You to use. Is this for RMS HQ or RMS SO You need?

    Kind regards, A.

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