Microsoft KB Archive/916270

= Error message when you import items into Accounting Professional 2007, into Accounting Express 2007, or into Small Business Accounting: &quot;InventoryItemAccount: 'ItemName': Cannot Import. COGS account is required&quot; =

Article ID: 916270

Article Last Modified on 2/8/2007

-

APPLIES TO


 * Microsoft Office Accounting Professional 2007
 * Microsoft Office Accounting Express 2007
 * Microsoft Office Small Business Accounting 2006
 * Microsoft Office Small Business Management Edition 2006

-





SYMPTOMS
When you import items into Microsoft Office Accounting Professional 2007, into Microsoft Office Accounting Express 2007, or into Microsoft Office Small Business Accounting, you may receive the following error message:

InventoryItemAccount: &quot;ItemName&quot;: Cannot Import. COGS account is required.



CAUSE
This problem occurs when any one of the following conditions is true:
 * The Account field in the header row contains a number.
 * The account name in the Account field differs from the account name in the Chart of Accounts.



RESOLUTION
To resolve this problem, change the account name in the file that you want to import so that the account name matches the account name in the Chart of Accounts. Also, row 1 must be a header row that contains fields that describe the data in the columns. The required fields in the header row include the following fields:
 * COGS Account
 * Income Account
 * Asset Account
 * Item Name



MORE INFORMATION
You can use a standard template to import a Microsoft Office Excel worksheet. The standard template is named ImportData.xls. For example, by default, the standard template for Small Business Accounting is installed in the following location:

C:\Program Files\Microsoft Small Business\Small Business Accounting\Templates\Excel

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

906096 How to import master records into Microsoft Office Small Business Accounting

Keywords: kbtshoot kbprb kbmbsmigrate KB916270

-

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

© Microsoft Corporation. All rights reserved.