supplier cost on report

Like (0) Share

Report

Posted on 3 Feb 2011 17:36:33 by DEVON LEROUX

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

All responses (1)

Answers (0)

Suggested answer

Community Member on 03 Feb 2011 at 18:10:21

Like (0)

Report

Re: supplier cost on report

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