|
Posted by Terrible TomúÚ&€c…!!롼¬~êçŠÛ« on November 11, 2005, 5:07 pm
Please log in for more thread options
On my Detailed Sales reports, when showing the columns: Qty Sold, Sold Price,
Total Sales, Cost and Profit; the Cost & Profit columns do not calculate
properly.
It appears that the Cost and Profit columns are not Extended by Qty Sold,
resulting in inaccuracies wherever Qty Sold <>1. This applies to both
returns (negative Qty Sold) and sales where Qty Sold is 2 or more.
Total Sales does calculate properly (Qty Sold * Sold Price).
The end result is a report that has practically no value other than showing
Total Sales.
Yes, the Department Cost/Sales report does provide an accurate picture of
similar data, but with no detail--cannot be sorted by Supplier, for example,
and doesn't show line item detail like the Detailed Sales Report does.
Tom
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=48bd1dd1-fdd2-49f9-a308-d4355cd8b56c&dg=microsoft.public.pos
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap