1. Home
  2. Point-Of-Sale Software
  3. Report help

Report help

I have a report ?Detailed Sales Report with Total Discount? from the customer source page. Is it possible to ad ?sale rep? to filter options. We leave the pos lanes open to a default cashier and each person (sale rep) logs-in for each transaction. I would like to show detail/totals for the discounts given by sale rep not cashier. Any help would be appreciated.

Reply to
Tom
Loading thread data ...

Yes you can accomplished this.

  1. GO to %installpath%:\Program Files\Microsoft Retail Management System\Store Operations\Reports
  2. Open the Custom - Detailed Sales Report with Total Discount.qrp
  3. Add the following line before the LEFT JOIN SalesRep WITH(NOLOCK) on [TransactionEntry].SalesRepID SalesRep.ID
  4. Add anywhere in report 2 new columns name: Begin Column FieldName = "SalesRep.Name" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sales Rep" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1515 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Begin Column FieldName = "SalesRep.Number" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Sales Rep #" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1515 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Save the file and re-start the Store Manager Program.

Please rate this.

"Tom" wrote:

Reply to
Akber Alwani

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.