Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : KepviPIvFUa1TTPXiaFVDo
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / item list report?
Microsoft Dynamics RMS (Archived)

item list report?

Like (0) ShareShare
ReportReport
Posted on 10 Jun 2014 17:36:46 by Goloknath

Can I generate a report to show what items in my inventory do not have tax applied? 

*This post is locked for comments

  • Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on 13 Jun 2014 at 18:57:15
    RE: item list report?

    Just in case the report is not listed here is the actual report that I have. For those interested, you will need to copy this into a file and extend the file as a .qrp file.

    //--- Report Summary --- //

    Begin ReportSummary

     ReportType = reporttypeItems

     ReportTitle = "Store Operations Item Tax Assignment"

     PageOrientation = pageorientationLandscape

     OutLineMode = True

     Groups = 1

     GroupDescription = ""

     DisplayLogo = True

     LogoFileName = "MyLogo.bmp"

     ProcedureCall = ""

     TablesQueried = <BEGIN>

        FROM  Item WITH(NOLOCK)

        LEFT JOIN   ItemTax WITH(NOLOCK)

                    ON Item.TaxID = ItemTax.ID

        LEFT JOIN Tax WITH(NOLOCK)

    ON ItemTax.TaxID01 = Tax.ID

        LEFT JOIN Department WITH(NOLOCK)

    ON Item.DepartmentID = Department.ID

        LEFT JOIN Category WITH(NOLOCK)

    ON Item.CategoryID = Category.ID

    <END>

     SelCriteria = ""

     GroupBy = ""

     SortOrder = ""

    End ReportSummary

    //--- Title Rows ---//

    Begin TitleRow

     Text = "<Store Name>"

     Font = "Arial"

     FontBold = True

     FontSize = 16

     Color = "Blue"

    End TitleRow

    Begin TitleRow

     Text = "<Report Title>"

     Font = "Arial"

     FontBold = True

     FontSize = 12

     Color = "Black"

    End TitleRow

    Begin TitleRow

     Text = "As Of: <Report Date>"

     Font = "Arial"

     FontBold = True

     FontSize = 10

     Color = "Black"

    End TitleRow

    //--- Filters ---//

    //--- Columns ---//

    Begin Column

     FieldName = "ItemTax.Description"

     DrillDownFieldName = "ItemTax.Description"

     DrillDownReportName = ""

     Title = "Item Tax"

     VBDataType = vbString

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1365

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "ItemTax.Code"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Item Tax Code"

     VBDataType = vbString

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1365

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Tax.Description"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Sales Tax Desc"

     VBDataType = vbString

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1365

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Tax.Percentage"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Tax %"

     VBDataType = vbDouble

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1000

     GroupMethod = groupmethodNone

     ColFormat = "#.###"

    End Column

    Begin Column

     FieldName = "Department.Name"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Department"

     VBDataType = vbString

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1560

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Category.Name"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Category"

     VBDataType = vbString

     Formula = ""

     ColHidden = True

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1560

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.ItemLookUpCode"

     DrillDownFieldName = "Item.ItemLookUpCode"

     DrillDownReportName = ""

     Title = "LookUp Code"

     VBDataType = vbString

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1245

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.Description"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Description"

     VBDataType = vbString

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1600

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.Cost"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Cost"

     VBDataType = vbCurrency

     Formula = ""

     ColHidden = True

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1100

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.Price"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Price"

     VBDataType = vbCurrency

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1100

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.Quantity"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "On Hand"

     VBDataType = vbDouble

     Formula = ""

     ColHidden = False

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 800

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.DateCreated"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Date Created"

     VBDataType = vbDate

     Formula = ""

     ColHidden = True

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1000

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

    Begin Column

     FieldName = "Item.LastSold"

     DrillDownFieldName = ""

     DrillDownReportName = ""

     Title = "Last Sold"

     VBDataType = vbDate

     Formula = ""

     ColHidden = True

     ColNotDisplayable = False

     FilterDisabled = False

     ColWidth = 1000

     GroupMethod = groupmethodNone

     ColFormat = ""

    End Column

  • Verified answer
    Goloknath Profile Picture
    Goloknath on 13 Jun 2014 at 18:51:12
    RE: item list report?

    baxtersamazon@gmail.com

    Thanks!

  • Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on 13 Jun 2014 at 18:45:55
    RE: item list report?

    It is escaping me too. I know I found it somewhere in the downloads. I have the file and can send it to you as a quick solution. I will need your email account.

  • Goloknath Profile Picture
    Goloknath on 13 Jun 2014 at 18:30:56
    RE: item list report?

    Unless it is under a different heading, I do not see it.

    Thanks though!

  • Goloknath Profile Picture
    Goloknath on 13 Jun 2014 at 18:26:25
    RE: item list report?

    What report are you saying is the one I would need?  I see a list of 40+ different options?

    Thanks!

  • Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on 13 Jun 2014 at 18:13:42
    RE: item list report?

    I failed to state the actual report's name:

    Custom - Store Items Tax Assignment

  • Verified answer
    Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on 13 Jun 2014 at 18:11:35
    RE: item list report?

    Possible an easier solution that Task 170:

    Under the download section of customer source you will find numerous custom reports. There is a custom report that you can get. You will need to place this report into your "reports" folder which can be found typically via C:Programs/Microsoft Retail Management Systems/Store Operations/Reports. Then you will need to close Store Operations Manager (if opened) and reopen so that the manager will recognize the new custom reports.

    The downloads area for rms custom reports can be found here:

    mbs.microsoft.com/.../downloads

    Grier

  • Verified answer
    Goloknath Profile Picture
    Goloknath on 10 Jun 2014 at 17:53:24
    RE: item list report?

    Don't know if there is a report but Click on wizards, Inventory wizards, select task 170. You can then export to Excel.

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

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,709 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,679 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans