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: 06/04/2021