You’re offline. This is a read only version of the page.
2
I have an item that has had some bad activity (name and cost have been changed a couple times in error). Is there any way search or run a report in HQ on completed worksheets to find all occurrences of a particular item? I need to figure out what/who is propagating this mistake.
Running RMS 2.0.1004
*This post is locked for comments
Once again, Fernando, exactly what I was looking for! Thank you!
Rick - I've used this to check what worksheets newly created items were placed on - it may work for you, if you remove the date on the filter, and add into the filter the specific item you want to view - it will show you historical worksheets. Who created the worksheet, I don't know that that is captured as part of the WS data; if you run SQL command sp_columns worksheet it will show you what columns are in the table; it may be there. Hope this helps.
//--- Report Summary --- //
Begin ReportSummary
ReportType = reporttypeItems
ReportTitle = "Newly Created Items With Worksheet #"
PageOrientation = pageorientationLandscape
OutLineMode = True
Groups = 1
GroupDescription = ""
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall = ""
TablesQueried = "FROM Item WITH(NOLOCK) LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID = Supplier.ID LEFT JOIN Worksheet_ItemUpdate WITH(NOLOCK) ON Item.ID = Worksheet_ItemUpdate.ItemID LEFT JOIN Worksheet WITH(NOLOCK) ON Worksheet_ItemUpdate.WorksheetID = Worksheet.ID"
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 = "Generated On <Report Date>"
Font = "Arial"
FontBold = True
FontSize = 10
Color = "Black"
End TitleRow
//--- Filters ---//
Begin Filter
FieldName = "Item.DateCreated"
FilterOp = reportfilteropBetween
FilterLoLim = "<WeekStart>"
FilterHilim = "<Today>"
End Filter
//--- Columns ---//
Begin Column
FieldName = "Item.ItemLookupCode"
DrillDownFieldName = "Item.ItemLookupCode"
DrillDownReportName = ""
Title = "Lookup Code"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1665
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "Item.Description"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Description"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2330
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "Supplier.SupplierName"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Supplier"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1350
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "Item.DateCreated"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Date Created"
VBDataType = vbDate
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1650
GroupMethod = groupmethodNone
ColFormat = "mm/dd/yy hh:mm:ss"
ColAlignment = flexAlignCenterCenter
End Column
Begin Column
FieldName = "Worksheet.ID"
DrillDownFieldName = "Worksheet.ID"
DrillDownReportName = ""
Title = "Worksheet #"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1350
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column
Begin Column
FieldName = "WorksheetStyle"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Worksheet Style"
VBDataType = vbString
Formula = "'Style ' + cast(Worksheet.Style as varchar(3))+' '+Worksheet.Title"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2550
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column
Begin Column
FieldName = "Worksheet.EffectiveDate"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Worksheet Eff Dt"
VBDataType = vbDate
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1650
GroupMethod = groupmethodNone
ColFormat = "mm/dd/yy hh:mm:ss"
ColAlignment = flexAlignCenterCenter
End Column
Begin Column
FieldName = "WorksheetStatus"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Worksheet Status"
VBDataType = vbString
Formula = "isnull((case worksheet.status when 1 then 'Not Yet Approved' when 2 then 'Approved For Processing' when 3 then 'In Process' when 4 then 'Completed OK' when 5 then 'Completed With Errors' when 6 then 'Acknowledged' when 7 then 'Completed With Warnings' end),'No Worksheet')"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2450
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (