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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (