Can somebody tell me how to custom my price list report in SO and HQ so that i can turn on the Re-order number column? Its the re-order number that is in the supplier tab that i need to be availalbe on my reports. Thanks v much!
SQL help!
Mar 26, 2007
1 Replies
Hi Philip, it is possible but make sure the following: ONe item attached to one supplier else report will repeat the same item twice/trice if the same item is purchase from mulitple supplier and you different kind of re-order no.
However if one item is attached to one supplier then following query you can add in Items - Item Price List.qrp file to accomplish the resultset.
TablesQueried = "FROM Item WITH(NOLOCK) LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentID = Department.ID LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID = Category.ID
LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID = Supplier.ID LEFT JOIN SupplierList WITH(NOLOCK) ON Item.ID=SupplierList.ItemID AND Supplier.ID=SupplierList.SupplierID"
Also need to add the column to the report add anywhere in the report:
Begin Column FieldName = "SupplierList.ReorderNumber" DrillDownFieldName = "SupplierList.ReorderNumber" DrillDownReportName = "" Title = "Reorder Number" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1665 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
"Philip Gass" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required