Skip to main content

Notifications

Microsoft Dynamics RMS forum

item list report?

Posted on by Microsoft Employee

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 780 on at
    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
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: item list report?

    baxtersamazon@gmail.com

    Thanks!

  • Grier Fleischhauer Profile Picture
    Grier Fleischhauer 780 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: item list report?

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

    Thanks though!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 780 on at
    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 780 on at
    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
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans