Microsoft KB Archive/234124

= SBFM2000: Sales By Customer Report Does Not Include Credit Memos =

Article ID: 234124

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 Q234124



SYMPTOMS
The Sales by Customer report may show a different sales total for a customer than the QuickBooks Sales by Customer Detail Report shows. Additionally, the Microsoft Small Business Financial Manager adds a customer name of N/A if the sales report contains a negative sales amount.



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 a customer with a credit memo.

-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 allows you to create a credit memo for a customer. You can think of a credit memo as a sales return reducing the customer's sale. When you import your Quickbooks for Windows accounting data into Microsoft Excel using the Small Business Financial Manager (SBFM), sales amounts will not reflect customers who have credit memos. Instead, it creates a new customer name of N/A, with a negative amount reflecting the total credit memos for all customers.

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.

