Sales Analysis Reports

For the discussion of reporting issues, and ideas, tips, tricks for writing reports
Forum rules
This forum is not the official Cognito Software support channel for MoneyWorks. If you need help from Cognito, then please contact us (or your local regional support representative) directly using the contact information on the Support page of the web site.

Please try the search facility before posting a new topic to see if your topic has already been covered.

If you do post a new topic, it's a good idea to choose a Topic Subject that it a bit more informative than "Help!" or "A problem". If your topic is actually recognisable by people scanning the forum, you'll have a much better chance of getting a response. Thanks and have fun.
Post Reply
Posts: 6
Joined: 25 Apr 2013 14:22
Product: Gold
Region: New Zealand

Sales Analysis Reports

Post by BarbNZP » 26 Aug 2013 16:57

I have noted that the Unit Price field in sales analysis reports relates to the average of the number of orders and not the quantities, even credit notes get added as orders. e.g 1st order 100items @ $10.00 2nd order 10 items @ $12.00 gives a $11.00 Unit Price. Actual average is $10.18. Does anyone else have a problem with this field not showing a true average.

Posts: 166
Joined: 25 Aug 2004 16:00
Region: New Zealand
Location: Auckland

Re: Sales Analysis Reports

Post by Simon » 26 Aug 2013 17:38

It is showing the average cost of the items sold at the time they were sold, not the current average.

So you may have sold 99 items at a cost of $10 (ie out of the first batch purchased) and then purchased 10 more at $12, giving an avg cost now of $11.82. Then if you sold another 1 at avg cost 0f $11.82 the otal average cost for all items sold would then be $11.009

Post Reply