1,565
Hello, we are looking for the code to add Supplier Cost (cost to reorder an item as opposed to the actual cost of an item) to an item price list report.
Thanks,
Devon
*This post is locked for comments
Memorize the report and then open the .qrp file in notepad from c:\Program Files\Microsoft Retail Management System\Headquarters\Reports. If the supplierlist table hasn't already been added to the TablesQueried section, add it with:
LEFT JOIN supplierlist WITH(NOLOCK) ON Item.supplierid=supplierlist.supplierid and item.id=supplierlist.itemid
Then add the supplierlist.cost column:
Begin Column
FieldName = "supplierlist.cost"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Supplier cost"
VBDataType = vbCurrency
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 870
GroupMethod = groupmethodNone
ColFormat = ""
End Column
#1
André Arnaud de Cal...
292,575
Super User 2025 Season 1
#2
Martin Dráb
231,493
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
