Can I generate a report to show what items in my inventory do not have tax applied?
*This post is locked for comments
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
baxtersamazon@gmail.com
Thanks!
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.
Unless it is under a different heading, I do not see it.
Thanks though!
What report are you saying is the one I would need? I see a list of 40+ different options?
Thanks!
I failed to state the actual report's name:
Custom - Store Items Tax Assignment
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
Don't know if there is a report but Click on wizards, Inventory wizards, select task 170. You can then export to Excel.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,782 Super User 2024 Season 2
Martin Dráb 229,067 Most Valuable Professional
nmaenpaa 101,150