Home › Forums › Users › General User's Discussion ›

Report for Top Product by Sales $ WITH MARGIN

Submitted by Jimvet on Wed, 13/08/2014 - 11:01
in

The existing Reports for Top Product Sales by $ and Top Product Sales by Volume (number sold) are excellent reports. Even better would be a Top Product by Sales PLUS MARGIN (and group). This would give a much better indication of the profitability of products. At the moment the Top Products by Sales are often dominated 14kg dog food bags which have a low margin and occupy a large volume / area.

The data should already be in OpenVPMS as the list price and sale price (or mark up) are present. Bear in mind some products sale price is based on mark up, and others on Recommended Retail Price.

The most important figure is the actual profit / margin not the $ value. This would allow us to choose which products to stock more efficently.

I would be happy to contibute to this project, if there is no report of this nature as yet.

 

‹ At cost discount type - proposal editing jrxml documents using Ubuntu ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Report for Top Product by Sales $ WITH MARGIN

Submitted by tgething (not verified) on Mon, 18/08/2014 - 09:28.

Jim - I cannot find the reports you refer to.  I can find the reference to these at http://www.openvpms.org/forum/top-sales-report-and-volume - but you do not appear to have lodged these in the community collection.

Regards, Tim G

Syndicate content