Item Maintenance / Item Inquiry

 

Window Details

 

How Do I...

Navigation

 

Create Alias Part Numbers to Print on Sales Orders and Purchase Orders

Overview

 

Fields

     

 

Related Topics

   

Lot/Serial Order Detail

Warranty Code Maintenance (On the Fly)

Deleting Inactive or Discontinued Items

Inventory Valuation Report by Period

Standard Cost Adjustments

Standard Cost Adjustment Entry

Item Maintenance (On The Fly)

Using Sales Tax in Job Cost

Inventory Work Order Search

 

Navigation

To access Item Maintenance, select Inventory Management Main menu > Item Maintenance.

To access Item Inquiry, select Inventory Management Main menu > Item Inquiry.

Note Item Inquiry fields can only be viewed.

Overview

Use Item Maintenance to create and maintain detailed information for each of your inventory items. Use Item Inquiry to view detailed information for your items.

This task provides several major functions that allow you to set up, maintain, and inquire about inventory items, including:

Warning You must retain at least two years of item history in Common Information Options to print accurate information on the Inventory Valuation Report by Period and to be able to use the drill-down features.

Item records can be deleted only if there are no outstanding transactions for that item. If there are outstanding transactions, you must use the Delete and Change Items utility.

Note For average cost items, if the quantity on hand is negative, the average cost will be an estimate because the actual cost is not yet known. If an item's quantity is expected to perpetually remain negative, use the FIFO, LIFO, or standard cost valuation method instead.

Note In Item Inquiry, vendor information and/or the drop-down menu is available only with the appropriate security setup.

Fields

 

Item Code

Description

   

1. Main

 

Product Line

Last Sold

Product Type

Standard Cost

Valuation

Average Cost

Procurement

Last Receipt

Weight

Standard

Volume

Purchases

Inventory Cycle

(Purchases) No. of

Price Code

Sales

Default Whse

(Sales) No. of

Primary Vendor

Item

Warranty Code

Allocated

Retail Price

Total

Standard Price

Quantities Grid

   

2. Additional

 

Note In Item Inquiry, this tab is available only with the appropriate security setup.

Confirm Cost Increase in Receipt of Goods

Print Receipt Labels

Explode Kit Items

Next Lot/Serial Number

Commission Method

Commission Rate

Base Commission

Allow Returns

Restocking Charge Method

Restocking Charge Amount/Rate

User-Defined Categories

Sales Tax Class

Purchases Tax Class

Routing No.

Buyer Code

Planner Code

Commodity Code

Image

Inactive Item

Allow Back Orders

Allow Trade Discount

Allocate Landed Cost

Internet Enabled

Last Physical Count

   

3. Quantity

 

Standard Unit of Measure

Totals Grid

Quantity Grid

 
   

4. History

 

Note In Item Inquiry, this tab is available only with the appropriate security setup.

Warehouse

Receipts

Quantities

Year

Sales

History Grid

   

5. Transactions

 

Note In Item Inquiry, this tab is available only with the appropriate security setup.

Warehouse

Totals Grid

Transactions Grid

 
   

6. Orders

 

Note In Item Inquiry, this tab is available only with the appropriate security setup.

Purchase Order

Sales Order

Work Order

Orders Grid

Ordered

Received

Shipped

Completed

Back Ordered

Quoted

   

7. Cost Detail

 

Note In Item Inquiry, this tab is available only with the appropriate security setup.

Warehouse

Cost Detail Grid

Valuation