Units per Transaction by sales rep report

I was wondering if anyone had a report that gave you units per transaction by SalesRep instead of by Cashier.

Reply to
Scott S
Loading thread data ...

Don't have this report but, if you give us a call we can discuss creating this report for you.

Daniel Westbrook NuRol Point of Sale and Barcoding

formatting link
snipped-for-privacy@nurol.com

404-352-3587

"Scott S" wrote:

Reply to
DW

memorize a copy of the Report - Sales - Top Performers - Top Sales Reps and then edit in notepad (file is in directory c:\Program Files\Microsoft Retail Management System\Headquarters\Reports) to add this column to the bottom.

Begin Column FieldName = "[Transaction].TransactionNumber" DrillDownFieldName = "[Transaction].TransactionNumber" DrillDownReportName = "" StoreIDFieldName = "" Title = "Transaction" VBDataType = vbLong Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1245 GroupMethod = groupmethodNone ColFormat = "" End Column

Then change the GroupBy line at the top of the report to say:

GroupBy = "Store.ID, SalesRep.Number, [transaction].transactionnumber"

This will give you the columns you need, then you can sort, group, and customize as needed.

"Scott S" wrote:

Reply to
Matt Hurst

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.