SageForum for UK versions of Sage 50- Help and support.

It looks like we have misinterpreted the product record graph & have been using this as a graphical sales report, when in fact it's a movement graph..

The graph appears to correctly report monthly product sales if there has been no incoming stock received in the month, but subtracts incoming from outgoing when there is stock received in the month (if 6 units are sold & 6 units received, the graph total is zero for said month) - does that sound about right?

This is the first time I have ever heard of someone using those graphs!

It sounds about right.

Personally, I would use invoices as the source for any reporting about product sales.

Do it in excel, group it, consolidate it, use a pivot table, graph it, do what you like.

Thank you for your reply.

The product sales graph is ideal for quickly looking at sales & adjusting product order points to suit - already "in" the product & far quicker than running reports & saves quite a bit of back & forth.

I put together a report & used "Stock / Qty_Sold_MthX" data field for the monthly sale totals, but the reports appear to be identical to what that product graphs are reporting & not completely correct (sales that are shown in Product / Activity, but not in Product / Graph). Guess I'll have to have a closer look at what's going on to figure where the inaccuracies are coming from.

Cheers.

The devil is in the details.

There are cases where stock is adjusted, either because of damage or other losses, is this part of the requirement or are these one off issues that should not reoccur?

Personally, I would do this as an excel report, (based on either invoiced sales or stock movements depending on which is a better indicator) this would give me the product codes in a spreadsheet together with the usage over whatever period I was interested in. I could them build a formula to estimate my minimum stock levels, then run my eye over them all, alter the ones that are spurious, compare them to the current minimum stock and if needs be overwrite the computed value with what I wanted, then save the sheet and import it into the stock module to set the stock levels all in one go.