Item Centre Fields

The Item Centre allows you to search and navigate through item details with precision. Whether you're in search of a particular item number, exploring item descriptions, or filtering through attributes such as base part, title, or alternate item numbers, the Item Centre houses comprehensive information about items. Each column within the centre provides valuable insights into items, facilitating improved inventory planning, analysis, and decision-making.

Item Centre Search Fields

The Item Centre offers a set of search fields to streamline the process of locating specific items.

Field
Description

Item#

Use this field to search for specific items by their unique identification numbers assigned within the inventory system.

Description

Use this search field to locate items based on their descriptive attributes or keywords.

Base Part

This field allows you to search for items using their designated base part numbers.

Title

This field allows you to search for items using the product title.

Alternate Item#

This field allows you to search for items using the alternative item numbers.

All References

This field offers a comprehensive search option, allowing you to search for items using various reference numbers associated with them.

Item Centre Columns

Field
Description

Base Part

This field displays the product associated with the item.

Title

This field shows the title of the product associated with the item.

Option 1 Name

This field shows the name of the first option variant of the product.

Option 1 Value

This field shows the value of the first option variant of the product.

Option 1 Code

This field shows the code of the first option variant of the product.

Option 2 Name

This field shows the name of the first second variant of the product.

Option 2 Value

This field shows the value of the second option variant of the product.

Option 2 Code

This field shows the code of the second option variant of the product.

Option 3 Name

This field shows the name of the third option variant of the product.

Option 3 Value

This field shows the value of the third option variant of the product.

Option 3 Code

This field shows the code of the third option variant of the product.

Option Sort

This field serves as a systematized method for arranging and categorizing items within the item center based on their attributes and variations. For instance, if the option sort is "BP123-001-002-003", "BP123" identifies the item's base part number, while "001", "002", and "003" detail the specific variations of this item. This method enhances user experience by simplifying how items and their variants are found and selected.

Use Image for Product Preview

This field indicates whether the image chosen for the item is used for the product.

Id

This field shows the unique identification code assigned to the item.

Image

The item image is captured in this field.

Type

This field displays the inventory type (inventory, non-inventory, etc.)

Item#

This field shows the item number.

Description

This field shows the description of the item.

UOM

This field captures the unit of measurement for the item.

Standard Price

This field shows the standard price of the item.

Asset Account

This field shows the asset account added for the item.

COGS Account

This field shows the COGS account added for the item.

Adjustment Account

This field shows the adjustment account added for the item.

Income Account

This field shows the income account added for the item.

Expense Account

This field shows the expense account added for the item.

Income Return Account

This field shows the income return account added for the item.

Size UOM

This field shows the unit of measure for the item’s size.

Weight UOM

This field shows the unit of measure for the item’s weight.

Default Vendor

This field captures the default vendor associated with the item.

Barcode

This field shows the item’s barcode.

UPC

This field shows the item's UPC.

GTIN

This field shows the item's GTIN.

Length

This field shows the item's length.

Width

This field shows the item's width.

Height

This field shows the item's height.

Weight

This field shows the item's weight.

Sales Tax Code

This field shows the default sales tax code associated with the item.

Purchase Tax Code

This field shows the default purchase tax code associated with the item.

Brand

This field shows the item's brand.

Group

This field shows the item's group.

Web Url

This field shows the URL to the item’s page.

Alert Note

This field shows the alert note added to the item.

Sales Notes

This field shows the sales note added to the item.

Purchase Notes

This field shows the purchase note added to the item.

Re-Stocking Fee

This field displays the fee applicable for re-stocking the item.

Item Category

This field displays the category associated with the item.

Returnable

This field indicates if the item is returnable or not.

Force Sales Tax

This field indicates whether the option to force the default sales tax is enabled for the item.

Is Active?

This field indicates whether the item is active or inactive.

Is Manufacturable?

This field indicates if an item is manufacturable.

Is Raw Material?

This field indicates if an item is used as a raw material.

Is Auto Producible?

This field indicates if the item can be auto produced in case of insufficient inventory.

Wip Account Name

This field captures the WIP account associated with the item.

Is Purchaseable?

This field indicates if the item can be purchased.

Country of Origin

This field displays the country of origin for the item.

Material

This field displays the primary material or composition of the item.

HS Code

This field displays the HS code of the item.

Is Sellable?

This field indicates if the item can be sold.

Is Transferable?

This field indicates if the item can be transferred from one location or warehouse.

Season

This field shows any season associated with the item.

Custom Prices

These fields capture any additional custom prices added for the item.

Create Datetime

This field captures the data and time when the item is created.

Created By

This field displays the username of the individual who created the item.

Modified Datetime

This field captures the data and time when the item was last modified.

Modified By

This field displays the username of the individual who last modified the item.

Last Activity Datetime

This field captures the date and time of the most recent action or activity performed on a specific item.

Tags

This field captures any tags added to the item.

Project/Class Name

This field displays any project/class associated with the item.

Gender

This field displays the gender associated with the item.

Warranty Time

This field displays the duration of the warranty provided for the item.

Warranty UOM

This field displays the unit of measure for the warranty time, such as days, months, or years.

Shelf Life

This field displays the shelf life of the item.

Expiration Date

This field displays the expiration date of the item.

CARB

This field displays the CARB value of the item.

Default Store

This field shows the store that will most often sell or house this item.

Default Location

This field shows the default physical location within a warehouse/store for this item.

Alternative Item Number1

This field shows the alternative item number1 for the item, providing additional identification.

Alternative Item Number2

This field shows the alternative item number2 for the item, providing additional identification.

Alternative Item Number3

This field shows the alternative item number3 for the item, providing additional identification.

Is Pre Sell?

This field indicates if the item is eligible for pre-selling.

Sell Package Qty

This field shows the sell package quantity of the item.

Stock Value

The stock value of an item refers to the financial worth of the inventory of that specific item as recorded within the system.

Total Qty

This field displays the total "Available" quantity of the item in all the stores combined.

Average Unit Cost

This field captures the average unit cost of the item.

Last Landed Cost

This field displays the landed cost of the item in the latest item receipt containing the item.

Last Landed Cost (Home Currency)

This field displays the landed cost in the home currency of the item in the latest item receipt containing the item.

Last Unit Cost

This field displays the unit cost of the item in the latest item receipt containing the item.

Last Purchased Qty

This field displays the quantity of the item that was last purchased.

Standard Cost

This field captures the standard cost of the item.

Last Invoice Date

This field records the date on which the last invoice related to the item was issued.

Last Invoice Days Since

This field shows the number of days that have passed since the last invoice was issued for the item.

Last Invoice Months Since

This field indicates the number of months that have elapsed since the item's last invoice date.

Last Qty Sold

This field displays the quantity of the item sold during the last transaction.

Last Receipt Date

This field captures the date when the item was last received into inventory.

Last Receipt Currency

This field displays the currency used for the transaction corresponding to the last receipt of the item.

Last Receipt Reconciled?

This field indicates whether the last receipt transaction for the item has been reconciled in the accounting records.

Vendor Part Number

This field captures the vendor part number associated with the item.

Is Taxable On Sale?

This field determines whether the item is taxable when sold to customers.

Is Taxable On Purchase?

This field indicates whether the item is subjected to taxes when purchased.

Discontinued Date

This field shows the date when the item was or will be discontinued.

BOM Exists?

This field indicates whether a bill of material exists for the item.

Third Party Ref No

This field shows the third party reference number associated with the item.

Restricted Purchasing?

This field shows whether restricted purchasing is enabled for the item.

This field indicated whether the item is dropship item or not.

CBM

This field captures the CBM value associated with the item.

Search Keywords

This field shows the keywords added to the item that help in searching for this item within the system.

Custom Price Formula Profile

This field shows the custom price formula profile added to the item.

Inner Case Qty

This field shows the quantity of items contained in an inner case packaging.

Inner Case UPC

This field shows the UPC code for an inner case.

Master Case Qty

This field shows the quantity of items contained in a master case.

Master Case UPC

This field shows the UPC code for an master case.

Last Counted Datetime

This field displays the date and time when the inventory was last counted.

Last Counted By

This field displays the user name of the individual who last conducted the cycle count.

Custom Description

This field displays any custom description added to the item.

MID

This field displays the Merchant Identifier (MID) for the item.

Manufacturer

This field displays the item's manufacturer.

Custom Fields

The custom field displays any additional data fields defined for the item.

Last updated

Was this helpful?