MANDATORY: The name of the inventory item as it appears in QuickBooks, name must be unique unless it has a Parent Ref. For example if the Item Full Name is Widgit:Green:Small then the Name = Small and the ParentFullName = Widgit:Green

IsActive

true or false

Whether the item is currently enabled for use by QuickBooks. The default is true

ParentFullName

str

The parent name of the inventory item name, referred to as Sub-item in QuickBooks item list, For example if the Item Full Name is Widgit:Green:Small then the parent name is Widgit:Green

Manufacturer Part Number

str 31

The part number used by the manufacturer of the item

Unit of Measure Set Name

str 31

The unit of measure set consists of a base unit and a number of related units

Is Tax Included

true or false

Whether Prices includes tax or not. Only supported in CA, UK and AU versions of QuickBooks

Sales Tax Code

str 3

Tax code for the item used when selling

Sales Desc

str 4095

Description used when the item is sold

Sales Price

price

Price charged for the item

Income Account

str 159

MANDATORY: Refers to the Income account used when the item is sold

Purchase Desc

str 4095

Description used for the item when bought

Purchase Price

price

Price of the item when bought

Purchase Tax Code

str 3

Tax code used when the item is bought

COGS Account

str 159

MANDATORY: Refers to the account that QuickBooks uses to track the original cost of the goods when bought

Pref Vendor

str 41

Name of the vendor as appear in QuickBooks where the item is usually purchased from

Asset Account

str 159

MANDATORY: Asset account for the inventory item

Reorder Point

quan

Minimum quantity that stock falls to before item needs to be reordered

Quantity On Hand

quan

Quantity held in available stock

Total Value

amt

Total value of stock held

Inventory Date

date

Date of valuation

Troubleshooting Common Errors

The COGS account cannot be changed - This error occurs when trying to modify an Inventory Item that has been used on a historical transaction in QuickBooks, due to the Inventory valuation calculations and the impact on balance sheet and on Closed Periods, restrictions are imposed by QuickBooks on modifying the COGS Account. As a workaround you could modify the name of the item make inactive and then create a new Item with the required COGS Account