Hello
Does anyone know how to add the vendor "ReorderNumber" to reports that show items sold and on-hand?
Thanks Carl
Email: snipped-for-privacy@telusplanet.net
Reports
May 02, 2008
2 Replies
Hi Carl - the report you are running must be joined to the SupplierList table. If its not, add the following to the Tables Queried Section
LEFT JOIN SupplierList WITH(NOLOCK) ON Item.ID = SupplierList.ItemID
Then add the following report column
Begin Column FieldName = "SupplierList.ReorderNumber" DrillDownFieldName = "" DrillDownReportName = "" Title = "Reorder Number" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1200 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
Restart store > Hello
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required