Key

ItemKey

N/A

Empty

The item key object that uniquely identifies the item.

Description

string

100

Empty

The description of the item.

ShortDescription

string

15

Empty

The short description of the item.

GenericDescription

string

10

Empty

The generic description of the item.

ClassKey

ItemClassKey

N/A

Empty

The item class key object that uniquely identifies the item class associated with the item.

Type

ItemType

N/A

Defaults from Item Class if provided. Otherwise will be set to Sales.

Describe the type of item or the status of the item. Also determines which posting accounts are updated when an item is used in transactions.

SalesTaxBasis

SalesTaxBasis

N/A

Defaults from Item Class if provided. Otherwise will be set to Taxable.

Determines whether the item will be taxed, and if so, on what basis.

SalesTaxScheduleKey

TaxScheduleKey

N/A

Defaults from Item Class if provided. Otherwise will be set to Empty.

The tax schedule key object that uniquely identifies the sales tax schedule associated with the item. Only used when the sales tax basis is taxable.

UofMScheduleKey

UofMScheduleKey

N/A

Defaults from Item Class if provided. Otherwise will be set to Empty.

The UofM schedule key object that uniquely identifies the unit of measure schedule associated with the item.

ShippingWeight

decimal

N/A

0

The shipping weight of the item.

QuantityDecimalPlaces

QuantityDecimalPlaces

N/A

Defaults from Item Class if provided. Otherwise will be set to 0.

The number of decimal places that will be used to track accurate quantities for the item.

CurrencyDecimalPlaces

CurrencyDecimalPlaces

N/A

0

The default number of decimal places to use for currency amounts for an item.

PurchaseTaxBasis

PurchasingTaxBasis

N/A

Defaults from Item Class if provided. Otherwise will be set to Taxable.

Determines whether taxes will need to be paid when the item is purchased, and if so, on what basis.

PurchaseTaxScheduleKey

TaxScheduleKey

N/A

Defaults from Item Class if provided. Otherwise will be set to Empty.

The tax schedule key object that uniquely identifies the purchase tax schedule associated with the item. Only used when the purchase tax basis is taxable.

StandardCost

MoneyAmount

N/A

0

The standard cost of the item.

CurrentCost

MoneyAmount

N/A

0

The current cost of the item.

SubstituteItem1Key

ItemKey

N/A

Empty

The item key object that uniquely identifies the item assigned as a substitute item number that will be suggested if the selected item number is out of stock at the time of sale.

SubstituteItem2Key

ItemKey

N/A

Empty

The item key object that uniquely identifies the item assigned as a second substitute item number that will be suggested if the selected item number is out of stock at the time of sale.

IncludeInDemand
Planning

boolean

N/A

False

Specifies whether to include the item in demand planning. True indicates the item will be included. False indicates it will not.

AllowBackOrder

boolean

N/A

Defaults from Item Class if provided. Otherwise will be set to False.

Indicates whether back orders can be be entered for an item.

WarrantyDays

short

N/A

0

The number of days the item will be covered by a warranty after it's sold.

ABCCode

ABCCode

N/A

None

Identifies the ABC code to assign to an item.

UserCategoryList1

string

10

Defaults from Item Class if provided. Otherwise will be set to Empty.

The value for the first user definable category used to group similar items on Inventory Control reports.

UserCategoryList2

string

10

Defaults from Item Class if provided. Otherwise will be set to Empty.

The value for the second user definable category used to group similar items on Inventory Control reports.

UserCategoryList3

string

10

Defaults from Item Class if provided. Otherwise will be set to Empty.

The value for the third user definable category used to group similar items on Inventory Control reports.

UserCategoryList4

string

10

Defaults from Item Class if provided. Otherwise will be set to Empty.

The value for the fourth user definable category used to group similar items on Inventory Control reports.

UserCategoryList5

string

10

Defaults from Item Class if provided. Otherwise will be set to Empty.

The value for the fifth user definable category used to group similar items on Inventory Control reports.

UserCategoryList6

string

10

Defaults from Item Class if provided. Otherwise will be set to Empty.

The value for the sixth user definable category used to group similar items on Inventory Control reports.

KeepCalendarYearHistory

boolean

N/A

Defaults from Item Class if provided. Otherwise will be set to False.

Specifies whether to maintain calendar-year history for this item. Calendar-year history includes quantity sold, total amount in sales and total amount in costs for the item, by month.

KeepFiscalYearHistory

boolean

N/A

Defaults from Item Class if provided. Otherwise will be set to False.

Specifies whether to maintain fiscal-year history for this item. Fiscal-year history includes quantity sold, total amount in sales and total amount in costs for the item, by period.

KeepTransactionHistory

boolean

N/A

Defaults from Item Class if provided. Otherwise will be set to False.

Specifies whether to maintain transaction history for this item. Transaction history is the detailed line-by-line history of posted documents. Transaction history is required to print the Transaction History Report or the Historical Stock Status Report.

KeepDistributionHistory

boolean

N/A

Defaults from Item Class if provided. Otherwise will be set to False.

Specifies whether to maintain distribution history for this item. Distribution history is the General Ledger posting distribution history; if you use this type of history, distribution breakdown registers and transaction posting journals may be reprinted.

InventoryGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item, based on the valuation method you've selected, will be posted to when you enter a variance or adjustment transaction. An increase adjustment will debit the Inventory account; a decrease adjustment will credit the Inventory account. This account also will be used in Sales Order Processing and Invoicing when you enter a return to the On Hand or Returned quantity types.

InventoryOffsetGL
AccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item, based on the valuation method you've selected, will be posted to when you enter a decrease adjustment. Typically, this will be a cost of goods sold account. This account will be used only when increase or decrease transactions are entered directly in Inventory Control. It is the offset amount for the Inventory account.

CostofGoodsSoldGL
AccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of this item, based on the valuation method you've selected, will be posted to when an invoice is entered in Microsoft Dynamics GP Invoicing or Sales Order Processing. This account also will be used as the default account that the cost of the item, based on the valuation method you've selected, will be posted to when a correction to a purchase receipt is entered for items that have already been sold.

SalesGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the extended price of an item, based on the valuation method and price method you've selected, will be posted to when an invoice is posted in Microsoft Dynamics GP Sales Order Processing or Invoicing. This account will be posted to if you've chosen to use posting accounts for the item rather than the customer.

MarkdownGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the discount (markdown) amount will be posted to when a transaction is entered in Microsoft Dynamics GP Invoicing or Sales Order Processing to reduce the price of an item. The discount amount is the difference between the unit cost of the item in Invoicing and the reduced price. For example, if the unit cost of an item is $100 and you mark it down 10%, $10 will be posted to the Discount account. This account will be posted to if you've chosen to use posting accounts for the item rather than the customer in the Invoicing or Sales Order Processing modules.

SalesReturnGLAccount
Key

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the price of an item will be posted to when a transaction is entered to return an item in Microsoft Dynamics GP Invoicing or Sales Order Processing. This account will be posted to if you've chosen to use posting accounts for the item rather than the customer in Invoicing or Sales Order Processing.

InUseGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item, based on the valuation method you've selected, will be posted to when a transaction is posted to transfer the quantity type of an item to In Use or for return documents entered in either Sales Order Processing or Invoicing.

InServiceGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item, based on the valuation method you've selected, will be posted to when a transaction is posted to transfer the quantity type of an item to In Service or for return documents entered in either Sales Order Processing or Invoicing.

DamagedGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item, based on the valuation method you've selected, will be posted to when a transaction is posted to transfer the quantity type of an item to Damaged or for return documents entered in either Sales Order Processing or Invoicing.

VarianceGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which cost amounts for the item will be posted.

DropShipGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item will be posted when an invoice receipt for a drop-ship purchase order is posted. Since the goods on a drop-ship purchase order aren't received into your inventory, the drop-ship items account is a purchasing clearing account.

PurchasePriceVarianceGL
AccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the variance when the shipment unit cost of an item and the invoice unit cost are different when posting an invoice receipt in the Purchasing Invoice Entry window.

UnrealizedPurchasePrice
VarianceGLAccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the variance when the item's standard cost and the cost when the item is received are different when posting a shipment receipt in the Receivings Transaction Entry window.

InventoryReturnGL
AccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which the cost of an item, based on the valuation method you've selected, will be posted to when a transaction is posted to transfer the quantity type of an item to Return. This account will be used for documents entered in Sales Order Processing and Invoicing if you've selected to use posting accounts from the item. This account also is used for return documents entered in either Sales Order Processing or Invoicing.

AssemblyVarianceGL
AccountKey

GLAccountNumberKey

N/A

Defaults from Item Class if provided. Otherwise set to Empty.

The GL account number key object that specifies the account to which assembly variance of this item, based on the valuation method you've selected, will be posted to when the actual costs are different than the standard or average costs when building a subassembly.

PurchaseUofM

string

10

Empty

The unit of measure used most often when purchasing the item.

DefaultWarehouseKey

WarehouseKey

N/A

Empty

The warehouse key object that uniquely identifies the default warehouse associated with the item.

PriceMethod

PriceMethod

N/A

Defaults from Item Class if provided. Otherwise set to Currency Amount.

Used to calculate prices in the price list. The price method you select also will control which values-either percentages or amounts-can be provided to determine pricing for an item.

FunctionalCurrency
DecimalPlaces

CurrencyDecimalPlaces

N/A

N/A

The default number of decimal places to use for local (functional) currency amounts for an item.

ModifiedDate

dateTime

N/A

System Date

The date the item was last modified. The value is in Coordinated Universal Time (UTC). This property is read-only.

LastModifiedDate

dateTime

N/A

System Date

The date the item was last modified. The value is in Coordinated Universal Time (UTC). This property is read-only.

CreatedDate

dateTime

N/A

Empty

The date the item was created. This property is read-only.

IsDiscontinued

boolean

N/A

Empty

Identifies items that have been discontinued. This property is read-only.

DefaultPriceLevelKey

PriceLevelKey

N/A

Empty

Specifies the default price level for the item.

DefaultSellingUofM

string

10

Empty

Specifies the default unit of measure for the item.

InternetAddresses

InternetAddresses

N/A

Empty

The set of Internet address information for the item.