|
| | | Forum Newbie
Group: Forum Members
Last Login: 11/11/2008 3:04:34 PM
Posts: 6, Visits: 12 |
| | We're using Retail Pro 8 and I can't figure out a way to create a report that will show give me a summary of items per transaction. I can get items per receipt in journals, and in the merchandise reports (I think that's what qty is referring to in sales transaction?) but no way to get both total # of receipts, and total items sold, in such a way I can calculate items per receipt. There's got to be a way to do this -- I see it in sales charts, and it's such a basic performance metric. But I'm pulling my hair out trying to find it. Hlep. |
| |
| | | 
Forum Member
Group: OSRS Employee
Last Login: Yesterday @ 4:33:04 PM
Posts: 572, Visits: 2,786 |
| Try a receipt journal with Qty added and grand totaled. run the report, export to excel. #of rows in excel/Qty grand total would give you you avg per receipt.
Brett ReedTechnical Support
www.OneStepRetail.com
|
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 11/11/2008 3:04:34 PM
Posts: 6, Visits: 12 |
| | That's the way I'm doing it now, but it's a huge report, and a lot of busywork. It's a lot of extraneous data, takes forever to run when looking at historical data, and is pretty cumbersome especially as what I really want to do is look at variations by department code. Is that seriously the only way? It seems strange that it will calculate so easily in sales charts but is not an available field in any report. |
| |
| | |
Forum Member
Group: OSRS Employee
Last Login: Yesterday @ 4:33:04 PM
Posts: 572, Visits: 2,786 |
| There is another option. You can run an Xout. That does list # of sales.
Brett ReedTechnical Support
www.OneStepRetail.com
|
| |
|
|