Microsoft KB Archive/234123

= SBFM2000: Sales Total Different in Sales By Customer Report =

Article ID: 234123

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Business Solutions Small Business Manager 7.5, 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.



STATUS
Microsoft 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.

Additional query words: OFF2000 SBFM2000

Keywords: kbbug kbsbt kbpending KB234123

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.