SBFM2000: Sales By Customer Report Does Not Include Credit Memos (234124)
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 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.
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 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.
REFERENCES
OFF2000 SBFM2000
| Modification Type: | Major | Last Reviewed: | 10/6/2003 |
|---|
| Keywords: | kbbug kbpending kbsbt KB234124 |
|---|
|