Inventory

Appendix > Appendix > QuickBooks® Import File Requirements > Inventory

Inventory

These are the master account fields that are imported from QuickBooks® and the corresponding field names in Denali. Required fields are noted with an asterisk.

There are several values that might appear in the Type column of the QuickBooks import file. Only rows with the following values will be imported:

• Sales Tax Item is imported into the Tax Codes table

• Non-Inventory Part is imported into the Non-Inventory Codes table

• Service is imported into the Non-Inventory Codes table

• Inventory Part is imported into the Stock Items table

An IN Code called I1 will be generated during the import and attached to your stock items. If more IN Codes are needed based on the stock item requirements, additional IN Codes will be created with the naming scheme I2, I3, etc. All of these Codes will default to FIFO as the valuation method. You will need to define these Codes in the IN Inventory Codes window. Although you can change the valuation method on an IN Code, it is not recommended when a stock item has quantity on hand.

QuickBooks Export	Denali Field	Notes
*Type		The value in this column determines which Denali table the data is imported into. See the list above.
*Item	Based on the Type field, Sales Tax Item Type = Sales Tax Code, Non-Inventory Part Type = Non-Inventory Code, or Inventory Part Type = Number	6 character limit for Tax Codes and Non-Inventory Codes; 50 character limit for Stock Items; uppercase, unique
Description	Description	50 character limit for Tax Codes and Non-Inventory Codes;120 character limit for Stock Items; if blank, Denali gets value from Item field
Account	Based on the Type field, Sales Tax Item Type = Account Number, Non-Inventory Part Type = General Ledger Sales, or Inventory Part Type = GL Sales Income	50 character limit; only appears if there is no integration to Accounts Payable
Taxing Agency	Vendor	50 characters, only when integrated to Accounts Payable
Price	Based on the Type field, Sales Tax Item Type = Tax Percent, Non-Inventory Part Type = Unit Price, or Inventory Part Type = List	Numeric, up to 4 decimal places; for stock items, defaults to list pricing, line 1
Cost	Based on the Type field, Non-Inventory Part Type = Unit Cost or Inventory Part Type = Last Cost	Numeric; for stock items, Last Cost will also appear in the IN Stock window on the Vendor tab
Sales Tax Code	Taxable (check box)	Checked if value is not “Non”
*Asset Account	GL Control Acct	50 character limit
COGS Account	GL Cost of Goods Sold Acct	50 character limit
Preferred Vendor	Primary Vendor	Primary Vendor will also appear in the IN Stock window on the Vendor tab
MPN	Vendor Stock	50 character limit
U/M	Unit Package	10 character limit
Reorder Pt (min)	Minimum and Maximum	Numeric
Quantity On Hand	On Hand	Numeric
Purchase Description	Notes	If not blank, prefixed with “Purchase Description”

* Required Field

Published date: 12/03/2021