SBFM2000: Sales Total Different in Sales By Customer Report (234123)
The information in this article applies to:
- Microsoft Small Business Financial Manager, when used with:
- Microsoft Office 2000 Small Business Tools
This article was previously published under Q234123 SYMPTOMS
The Sales by Customer report may show a different sales total than other sales analysis reports. For example, the grand total in the Sales by Totals report or the total revenue amount in the Income Statement may show a different total sales amount than the Sales by Customer report.
CAUSE
This problem occurs when you do all of the following:
- You import data from Quickbooks for Windows, version 7.0.
-and- - Your Quickbooks accounting file contains sales reps assigned to customers.
-and- - You run the Sales by Customer report.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
Quickbooks for Windows lets you assign sales reps to individual customer accounts when setting up the accounting file. When you import your Quickbooks for Windows accounting data into Microsoft Excel using the Small Business Financial Manager (SBFM), all the sales data may not be imported for customers who are assigned to a sales rep. If this problem occurs, the incorrect amount will appear on the Sales by Customer report for Sales Analysis.
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
| Modification Type: | Major | Last Reviewed: | 10/6/2003 |
|---|
| Keywords: | kbbug kbpending kbsbt KB234123 |
|---|
|