web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Create a new filter fo...
Microsoft Dynamics RMS (Archived)

Create a new filter for Sales Reports?

(0) ShareShare
ReportReport
Posted on by laureno 35

Hello.  I use RMS.  I'd like to add new filters to the Sales Report and the Inventory Report, specifically so I can filter these reports by an item's "sub-descriptions."  For example, right now I can filter by "on hand" "category" and "department" and so on, but not by the "subdescriptions" which I set up in an item's properties.  One sub description I use and would like to filter with is the sub description season (e.g.  "F11" is Fall 2011).  How do I do this?  Thank you!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Create a new filter for Sales Reports?

    You could memorize your current report as needed, then open in Notepad from the reports directory, usually "c:\Program Files\Microsoft Retail Management System\Store Operations\Reports" then append this column to the end of the report.  Append with appropriate fieldname and title for other database fields like subdescription 2 and 3.

    Begin Column
       FieldName = "Item.SubDescription1"
       DrillDownFieldName = ""
       DrillDownReportName = ""
       StoreIDFieldName = ""
       Title = "SubDescription1"
       VBDataType = vbString
       Formula = ""
       ColHidden = False
       ColNotDisplayable = False
       FilterDisabled = False
       ColWidth = 2115
       GroupMethod = groupmethodNone
       ColFormat = ""
       ColAlignment = flexAlignLeftCenter
    End Column

  • Mike Haugen Profile Picture
    Mike Haugen 265 on at
    Re: Create a new filter for Sales Reports?

    You cannot add a filter to the reports, but any field that is in RMS can be reported on with Custom reports. We have a library of hundreds of these, like "Detailed Sales Report with Description 1, 2, and 3" that we can just drop into the Reports folder in RMS and they will show up for you to run, and then you can sort by them.

    mikeh@retailtechnologyexperts.com

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans