| Author |
Message |
Terrible Tom
Guest
|
 Posted:
Sat Nov 12, 2005 1:03 am Post subject:
Report Columns Don't Ad Up |
|
|
When I run a detailed sales report, the Total Sales, Cost & Profit columns
don't add up. In theory, Total Sales - Cost = Profit. In this instance, the
numbers don't add up. Not even close.
What gives?
Tom
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.
|
|
| Back to top |
|
 |
Matt
Guest
|
| Posted:
Sat Nov 12, 2005 1:03 am Post subject:
Re: 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
"Terrible Tom" <tomg@GO_FISHrobysfurniture.com> wrote in message
news:3B8C3989-08C2-408D-83DB-51799325E7A7@microsoft.com...
| Quote: | When I run a detailed sales report, the Total Sales, Cost & Profit columns
don't add up. In theory, Total Sales - Cost = Profit. In this instance,
the
numbers don't add up. Not even close.
What gives?
Tom
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail. |
|
|
| Back to top |
|
|
Terrible Tom
Guest
|
| Posted:
Sat Nov 12, 2005 1:03 am Post subject:
Re: Report Columns Don't Ad Up |
|
|
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.
2. 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:
| Quote: | 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
"Terrible Tom" <tomg@GO_FISHrobysfurniture.com> wrote in message
news:3B8C3989-08C2-408D-83DB-51799325E7A7@microsoft.com...
When I run a detailed sales report, the Total Sales, Cost & Profit columns
don't add up. In theory, Total Sales - Cost = Profit. In this instance,
the
numbers don't add up. Not even close.
What gives?
Tom
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.
|
|
|
| Back to top |
|
|
Rob
Guest
|
| Posted:
Sat Nov 12, 2005 11:32 pm Post subject:
Re: Report Columns Don't Ad Up |
|
|
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.
https://mbs.microsoft.com/downloads/customer/Custom_-_Detailed_Sales_Report_with_Return_Values.zip
Rob
"Terrible Tom" <tomg@GO_FISHrobysfurniture.com> wrote in message
news:5D3FAC36-1CF5-4A5E-92AB-BBB8D2D46DC0@microsoft.com...
| Quote: | 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.
2. 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:
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
"Terrible Tom" <tomg@GO_FISHrobysfurniture.com> wrote in message
news:3B8C3989-08C2-408D-83DB-51799325E7A7@microsoft.com...
When I run a detailed sales report, the Total Sales, Cost & Profit
columns
don't add up. In theory, Total Sales - Cost = Profit. In this
instance,
the
numbers don't add up. Not even close.
What gives?
Tom
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in