I would like to have a report that shows me all items that have an on hand quantity that is higher than the restock level. i have been playing with the active reports but can't find a way to have it use both field as a filter. does anyone know how to do this?
Thank,
Matt
2) Check back in this newsgroup, Report editing is discussed frequently.
3) Here's the simple instructions to add an Overstock column - you need to do the calculation in a column, not in a filter.Open the ...\Store Operations\Reports folder make a backup copy of "Items - Item Quantity List.qrp" right click "Items - Item Quantity List.qrp" and select properties, then uncheck "Read - Only" Open the Item Quantity List in a text editor (Notepad)
go all the way to the bottom of the file and paste this block:
Begin Column FieldName = "OverStock" DrillDownFieldName = "" DrillDownReportName = "" Title = "Overstock" VBDataType = vbDouble Formula = "(Item.Quantity - Item.QuantityCommitted) - Item.RestockLevel" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1215 GroupMethod = groupmethodNone ColFormat = "" End Column
Have something to add? Share your thoughts — no account required.
Ask the community — no account required