Wednesday, January 20, 2010

Wish # 6022 - CONSOLIDATED Sales by Line in Multi-Store


this note sent to Dane & Normand


Require a CONSOLIDATE report for multi-stores on sales by LINE.  See attached example that we were able to get from J-Con (upper image).  Can you tell me if this has been added to the pending v50 release?  Or if NOT - is it in the pipeline?  Appreciate a reply

I have looked at the existing REPORTS-Financial-Line Sales - and with just 3 stores it is a tedious job to space out the missing lines that any one store didn't sell ( also see image ) ... one easy fix might be to add a penny to all lines codes at the first of the year for a return ( or some such column ) - by adding a penny it forces the line to show on the report.   Or do what J-Con did --and have an option to PRINT ALL LINES ( even if no activity )

Once all lines match up - it is a simple matter for multi-store jobbers to join together the reports and 'play' with the data.


On the other hand  - if you might be so kind to CONSOLIDATE the data into one EXPORTABLE report - then you save us one repetitive step every month.

The benefits of looking at what ONE STORE sells yet another doesn't helps us look for holes and mis-information and boost sales overall.   Lower Image is first cut at Exploris data.   

Also note in the J-Con data we took the opportunity to group LINES by a product type so we could consolidate the data further down to the basics

No comments: