MPQ on a Store or HQ Report

I need to be able to make up order sheets for staff to use on the shop floor when doing orders, i cant find any reports which have MPQ availalbe which i really need.... any ideas?

A price list would be ideal... I need the following info on one report... Dept, Catagory, ILC, Reoder number, Description, Price, and if it i was possible, stock on hand at that store. It would be ideal if i could run this report from an HQ Db and a SO Db!

Thanks for you help! (aga> Philip,

Philip,

Here's one for a store. You will need to turn on the MPQ column.

Find the section below and change the line ColHidden to False

Begin Column FieldName = "SupplierList.MasterPackQuantity" DrillDownFieldName = "" DrillDownReportName = "" Title = "MPQ" VBDataType = vbLong Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 700 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignCenterCenter End Column

Items will be repeated if you have more than one Supplier per item.

Thanks so much for that Jeff, there were loads of usefull parts to that report that i could turn on and make good use of!

:o)

"Jeff" wrote: