SBFM2000: Sales By Customer Report Does Not Include Credit Memos

• Microsoft Small Business Financial Manager, included with:
  • Microsoft Office 2000 Small Business Tools
• Microsoft Excel 2000

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 this to be a problem in the Microsoft products 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 discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

REFERENCES

OFF2000 SBFM2000

Additional query words:

Keywords : xlsbfm kbsbt
Version : :; WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug