Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

RMS Sales report for a month by Day and Department

Posted on by Microsoft Employee

Looking for an RMS report as shown below for a month:

Sale for each day of the month by Department and/or Category.

Department     1             2        3      ...... 31   Total Sales

Clothing      $1200     1000    500  ......              $2700

Shoes        $ 500        300    200 .......               $ 1000

Any help would be appreciated.

Danny

  • Suggested answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: RMS Sales report for a month by Day and Department

    Run Store Operations Manager, Reports, Sales, Details Sales.
    Select default date filter and change to Last Month then OK to run report.
    Right-click on report and select Show/Hide.
    Scroll down and enable Date Sold and click OK.
    Drag Date Sold column to leftmost position.
    Select Grouping icon in top toolbar and select 'Group 1st two columns'.
    Select 'Collapse grouped rows' in toolbar.
    Now you should see days of the month with dept totals by day.
    You can right-click, select Show/Hide and remove Category, Item, Description, Qty Sold, and Sold Price.
    Select Memorize in toolbar and save as "Sales by Dept by Day of Month".
    If you want to change how this data is displayed in a table you could click Export icon in toolbar, uncheck 'Export hidden rows', export as tab-delimited text file and open the file in Excel for editing.

  • mcons Profile Picture
    mcons 390 on at
    RE: RMS Sales report for a month by Day and Department

    I dont think one exists in that format, or even if the RMS report language is smart enough to do it.  I could create something for you if you want to reach out to me.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans