Report Columns Don't Ad Up

Tom,

If I'm thinking the same report, the Detailed Sales report profit column only displays the profit per item, and not the extended profit. I think the same goes for costs, too. The columns need to have their formulas changed in the QRP file to account for the quantities sold.

Good luck, Matt

So I looked closer at the individual line items. Here's what I found:

1. Returned items show as negatives in the Total Sales column but as positives in the Cost & Profit columns.

1. Cost & Profit aren't Extended by Qty Sold. (Just like Matt said)

It appears as though the Total Sales = Qty Sold * Sold Price (which is accurate due to the negative quantities on returned items). Cost is correct, but doesn't get a negative in the case of a return. Profit is calculated by subtracting Cost from Sold Price, neither of which is negative in the case of a return.

The problem is definitely the returned items not calcualting properly.

I will be posting a Suggestion for MS regarding this problem. This is definitely a bug report worthy topic. I know that MS doesn't like to admit to bugs in their product, but calling a bug a butterfly doesn't make it so.

In the interim, I think I'll try to create two reports: Sales (Detailed Sales where Qty Sold >0) and Returns (Detailed Sales where Qty Sold < 0) I can manually deduct the returns from the sales for a fairly accurate number--though the lack of Extended Cost & Profit data is disappointing to say the least.

Tom

"Matt" wrote:

This is a known issue and there is a fixed Detailed Sales report that shows the correct values for returns in the Reports Library on Customer Source.

My CustomerSource expired. Would it be possible for you to send this report to my email? nr0338@ hotmail.com Is the return quantity calculated correctly in the Item Movement History report?

Thank you > This is a known issue and there is a fixed Detailed Sales report that shows