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

   

Inventory Work Order Search

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

Lot/Serial Order Detail

 

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

Purchases Tax Class

Print Receipt Labels

Routing No.

Explode Kit Items

Buyer Code

Next Lot/Serial Number

Planner Code

Commission Method

Commodity Code

Commission Rate

Image

Base Commission

Inactive Item

Allow Returns

Allow Back Orders

Restocking Charge Method

Allow Trade Discount

Restocking Charge Amount/Rate

Allocate Landed Cost

User-Defined Categories

Internet Enabled

Sales Tax Class

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

Received

Sales Order

Shipped

Work Order

Completed

Orders Grid

Back Ordered

Ordered

 
   

7. Cost Detail

 

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

Warehouse

Cost Detail Grid

Valuation

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks