I was wondering if anyone had a report that gave you units per transaction by SalesRep instead of by Cashier.
- posted
14 years ago
I was wondering if anyone had a report that gave you units per transaction by SalesRep instead of by Cashier.
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
"Scott S" wrote:
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:
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.