Item

Inventory > Maintenance > Item

Use this page to view current items setup in the system and to associate a Commodity code with the item.

Document Toolbar

Save

Entry Fields

Active

Indicates if item is active.

Item

Item ID.

Description

Item description.

Commodity Code

Identifies the commodity that this items is classified under.

The Item Maintenance page is where inventory items are set up and maintained within WorkPlace or viewed when synchronized through a supported ERP.  The Inventory Item information available is separated into the following four tabs:

Item

location

Vendor Item

Accounts

Manufacturer's Item

 

Item Tab

Document Toolbar

New

Duplicate

Save

Delete

More Information

Inventory Info

General Tab

Inter-Company

This field is only available when Intercompany is registered.  When left blank the Item is available for all companies, if a company is specified it belongs exclusively to that company.

Item

Type in up to 200 characters to indicate the Item number.

Active Checkbox

Check the box to make the Item active. Active Items will be available for selection on transaction pages.

Description

Type in up to 510 characters to further describe the Item number.

Posting Code

Optionally enter or select a valid Posting Code for Inventory Management transactions.

Miscellaneous (costs are not tracked) Checkbox

Check the box to indicate this is a miscellaneous Item and no cost details will be tracked or default within WorkPlace.  This setting cannot be checked if Qty Tracked, Lot or Serial are also checked.

Qty Tracked Checkbox

Check the box to indicate this Item will be quantity tracked within the Inventory Management subledger.

Lot Checkbox

Check the box for Items that are Lot tracked. When checked, increase and decreases to the Item's quantity will require entry of Lot information throughout the Inventory Management Solution.

Serial Checkbox

Check the box for Items that require Serial Number tracking. When checked, increase and decreases to the Item's quantity will require entry of Serial Number information throughout the Inventory Management Solution.

Valuation Method

Select the Valuation Method for the how the Item will be costed within the Inventory Management Solution.

Item Group

Type in or select a valid Item Group from the zoom window. Item Groups are setup in Item Group in Maintenance under the Inventory heading.  This field is optional unless the 'Require Item Group' Inventory System Setting is enabled under the Item Maintenance section.

Location

Type in or select a valid Location from the zoom window. Locations are setup in Location in Maintenance under the Inventory heading. The location selected on this tab will be the default location for the Item.

UOM Conversion Group

Type in or select a valid UOM Conversion Group from the zoom window. UOM Conversion Groups are setup in UOM Conversion Group in Maintenance under the Inventory heading.

UOM Base

This read-only field displays the base unit of measure for the Inventory Item as defined by the UOM Conversion Group selected above. The UOM selected for UOM Base will be the default UOM for the item for Inventory Management transactions.

UOM Purchasing

Type in or select a valid UOM from the zoom window. Valid UOM's are based on the selected UOM Conversion Group. A UOM Conversion Group must be selected before selecting a UOM Purchasing. The UOM selected for UOM Purchasing will be the default UOM for the item throughout the Requisition/Check Request and Purchase Order Workflows.

Stock Current Cost

The current cost of the inventory item based on the UOM Base.  If the item is Qty Tracked and has a valuation method of Average, this field will be read-only. The current cost will be updated by any increase to the item quantity within the Inventory Management solution unless the 'Update Item Stock Current Cost upon PO Release instead of Invoice' System Setting is enabled to update at the point of Purchase Order generation.

Commodity Code

Type in or select a commodity code for the item.

Quantity Precision

Enter the quantity precision for the inventory item to indicate the number of decimal places required for tracking the item quantities. The quantity precision must be set to zero (0) for quantity tracked items.

Unit Price Precision

Enter the unit price precision for the inventory item to indicate the number of decimal places required for tracking the item cost. The unit price precision can be set for multiple currencies by clicking the hyperlink label.

Tax Schedule

Type in or select a default Tax Schedule for the Item.  This Tax Schedule will default when the Item is selected on a line within Requisition/Check Request or Purchase Order Entry.

 

Replenishment Tab (used with Inventory Replenishment interface)

Order Policy

Select "Not Planned" or "Use PO Generator" to set the order policy.

Order Point Quantity

Enter the quantity at which to reorder.

Method

Select "Order to Independent Sites" or "Order to Master Site" for automatic generation of Purchase Requisitions.  Select "Transfer Stock from Master Location" for automatic generation of Transfer Request through the Requisition Workflow.

Order-Up-To Level

 Enter the quantity to order.

Master Location

 Type in or select the Master Location to use when ordering or replenishing locations through Transfer Requests.

Cost Selection

 Select from the list the item cost to use when ordering.

Vendor Selection

Select from the list the vendor to use when ordering.

Specified Cost

Enter a cost when choosing "Specified Cost" type from Cost Selection.

Replenishment Level

Select from the list a replenishment level to use when ordering.

 

Location Tab

Document Toolbar

Save

Assign Locations

Entry Fields

Delete Checkbox

Check the box to select, then press SAVE to remove the desired line.

Active Checkbox

Check the checkbox to make the location active for the Item selected.

Qty Tracked Checkbox

Check the box to indicate this Item will be quantity tracked at this Location within the Inventory Management subledger.  This option is only available if the Item has been selected for Qty tracking and will default to checked.  If the item is not quantity tracked, this field will be read only and set to unchecked.  The ability to enable quantity tracking at the location level provides organizations the flexibility to define stock and non-stock sites for their inventory items.

Company

This field is only available when Intercompany is registered and will be default read only if an Inter-Company has been assigned to the Item.  Items with a blank Inter-Company value on the General tab can be stocked at location across multiple companies by selecting a valid Company that owns the inventory at the location.

Location

Type in or select a valid location from the zoom window. Locations are created in Location in Maintenance under the Inventory heading.

Bin

Type in the Bin where the Item is stored at this location. This field can represent any portion of the physical location such as shelf, section, etc.

Stock Current Cost

The current cost of the inventory item based on the UOM Base for the specified Location.  If the item is Qty Tracked and has a valuation method of Average, this field will be read-only. The current cost will be updated by any increase to the item quantity within the Inventory Management solution unless the 'Update Item Stock Current Cost upon PO Release instead of Invoice' System Setting is enabled to update at the point of Purchase Order generation.

 

Replenishment tab (Available with Inventory Replenishment interface)

Entry Fields

Order Policy

Select "Not Planned" or "Use PO Generator" to set the order policy.

Replenishment Level

Select from the list a replenishment level to use when ordering.

Method

Select "Order to Independent Sites" or "Order to Master Site" for automatic generation of Purchase Requisitions.  Select "Transfer Stock from Master Location" for automatic generation of Transfer Request through the Requisition Workflow.

Order Point Quantity

Enter the quantity at which to reorder.

Master Location

Type in or select the Master Location to use when ordering or replenishing locations through Transfer Requests.

Order-Up-To Level

Enter the quantity to order.

Vendor Selection

Select from the list the vendor to use when ordering.

Cost Selection

Select from the list the item cost to use when ordering.

Primary Vendor

Select the Primary Vendor for this item, to be used when Vendor Selection is set to "Primary Vendor."

Specified Cost

Enter a cost when choosing "Specified Cost" type from Cost Selection.

 

Quantities tab (Available with Inventory Management)

informational Fields

Location Navigation

Allows the user to navigate to the first, previous, next and last location assigned to the Item.

On Hand

Displays the total quantity On Hand for the inventory item.

Allocated

Displays the total Allocated quantity for the inventory item.  Item quantities are automatically allocated upon save of a Release or Transfer Request or Requisition.  

In Transit

Displays the total quantity In Transit for the inventory item.  Item quantities are automatically placed In Transit when Transfer/Release Ship sessions are processed.  

Available

The quantity available for an inventory item is calculated based on the total On Hand quantities that have not been allocated or are In Transit (Available = On Hand - Allocated - In Transit).

Requisitioned

Displays the total quantity currently within the Requisition/Check Request Workflow for the inventory item.  Item quantities are automatically updated when Requisition/Check Requests are saved with a Fulfilment Type other than Transfer or Release.

Ordered Not Released

Displays the total quantity currently on Purchase Orders that have not yet been released for the inventory item.  Item quantities are automatically updated when Purchase Orders are created with a status of New or Change Order.  

Ordered Released

Displays the total quantity currently released on Purchase Orders for the inventory item.  Item quantities are automatically updated when Purchase Orders are released to Vendors.  

Qty Backordered

Displays the total quantity in Release and Transfer requests that have been back ordered.  This feature is available when the 'Enable Backorder for Transfer/Release Request' System Setting has been enabled.

 

Accounts Tab

This tab displays the posting accounts for the Item by assigned Location based on the Posting Codes setup within the Inventory Management Solution.

Document Toolbar

Save

Entry Fields

Location Navigation

Select from all locations assigned to the Item to display the associated Inventory accounts.

Manual Checkbox

Check the box to manually enter the GL Account.  When checked, the GL Account entered will be saved for that item and location and will not be overridden when updates are made throughout the Posting Code Hierarchy.

Description

Displays the description of the posting type for the GL Account.

G/L Account

By default, this field will be read-only and display the resulting GL Account for each posting type based on the setups made through the Posting Code Hierarchy for Inventory.  If the Manual Checkbox is marked, the user will be able to manually enter an account or select one through the GL Account zoom.  The accounts displayed in this section will be used during transaction entry based on the Item and Location.

 

Vendor Item Tab

Document Toolbar

Save

Entry Fields

Delete Checkbox

Check the box to select, then press SAVE to remove the desired line.

Active Checkbox

Check the checkbox to make the Vendor Item active for the Item selected.

Vendor Item

Type in up to 120 characters to indicate the Item number.

Description

Type in up to 510 characters to further describe the Item number.

Company

This field is available when Intercompany is registered to enter or select the company where Vendor exists.  The Company will determine the Vendors that are valid and available for selection.

Vendor

Type in or select a valid Vendor from the zoom window. Vendors are created in Vendor in Maintenance under the Account Payable heading.

Last Currency

Displays the Currency of the last invoice for the Item processed to the specified Vendor.

Last Invoice Price

Displays the cost of the last invoice processed to the Vendor based on the stocking UOM for the Item.  This price will default throughout the Requisition/Check Request and Purchase Order Workflow when the Vendor and Item are selected on session lines using the last currency.

 

Replenishment tab (Available with Inventory Replenishment interface)

Entry Fields

Economic Order Qty

Enter the amount to be used for the Economic Oder Quantity.

Planning Lead Time

Enter in days, the Planning Lead Time.  

Line Actions

Duplicate Line

 

Manufacturer's Item Tab

Document Toolbar

Save

Entry Fields

Delete Checkbox

Check the box to select, then press SAVE to remove the desired line.

Active Checkbox

Check the checkbox to make the Manufacturer's Item active for the Item selected.  

Manufacturer's Item

Type in up to 120 characters to indicate the Item number.

Description

Type in up to 120 characters to further describe the Item number.

Manufacturer

Type in up to 60 characters to describe the Manufacturer.

Tax Classes Tab

Document Toolbar

Save

Entry Fields

Delete Checkbox

Check the box to select, then press SAVE to remove the line.

Tax Detail

Enter or select a Tax ID for the selected Item.

Tax Class

Enter or select an available Item Tax Class based on the selected Tax ID.  This Tax Class will default for this Item when the Tax ID is included in the Tax Details for a transaction.

Line Actions

Duplicate Line