Open PO report w/ departments &/or categories

hi Jackson, if you talking about Custom - Purchase Order List.grp file open it and add the following lines in TableQueried section below the LEFT Join Item

LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentIDÞpartment.ID LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryIDÊtegory.ID

Then go anywhere in report and add the following code:(recommended to add before the Begin Column of Item.ItemLookupcode Begin Column FieldName = "Department.Name" DrillDownFieldName = "Department.Name" DrillDownReportName = "" Title = "Department" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2205 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Begin Column FieldName = "Category.Name" DrillDownFieldName = "Category.Name" DrillDownReportName = "" Title = "Category" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1065 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Save the file and run it again. don't forget to rate this please.

"jacks> Hi- wondered if there is a open PO report out there that can show department

Thank you- that's just what I needed!