Item Maintenance / Item Inquiry

 Show/Hide All

Item Code

Enter an item code for the item to add or maintain, or click the Lookup button to locate a specific item or group of items.

Alternately, start typing an item description to locate an item. As you type, a list of records matching your entry appears. You can then select an item from the list, and the item code will appear in the field.

You can also click the Alias Item Lookup button to display all alias item codes.

Do not use wildcard characters (*) when creating item codes. If the eBusiness Manager module is activated, do not use special characters in your item codes.

Click the Memo button to view, create, or maintain memos. The Memo button is available only if the appropriate memo type has been set up in Memo Manager Maintenance for this task. If a memo already exists for this task, the Memo button appears yellow. If a memo does not exist, the Memo button appears blue. For more information, see Memo Maintenance.

 

Description

Type a description for the item. If the description exceeds 30 characters, including spaces, the Item Text Maintenance window automatically appears if you have the appropriate security setup.

Click the Extended Item Description button to view and maintain extended item descriptions in Item Text Maintenance.

• If there is no extended description entered for an item, the Extended Item Description button appears blue.

• If an extended description is entered for the line item, the Extended Item Description button appears yellow.

If the Bill of Materials module is set up, an update to this field may update the Description 1 field in Bill of Materials Maintenance, depending on the selection made in the Sync Bill Description and Item Description field in Bill of Materials Options. If the Require Bill Revisions check box is selected in Bill of Materials Options, changes will update the current revision of the bill only.

 

1. Main

 

Product Line

Enter a product line code to use for this item, or click the Lookup button to list all product line codes. If your company does not have multiple product line codes, enter the default product line code. Product lines are defined in Product Line Maintenance.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Product Type

Select the product type to use for this item.

• Select Finished Good for an item that is normally kept in stock and sold to a customer (default).
• Select Raw Material for an item that is used to make another item or kit, and is generally not sold directly to a customer.
• Select Kit for an item made up of one or more components that is assembled before being sold. Each kit can consist of component items and comment lines. Components are relieved when the kit is built. The kit can have an associated lot/serial number. A kit can be purchased pre-assembled. The component list of an individual kit can be modified by substituting, adding, or deleting an item, or by changing the quantity of an item. Kits can be disassembled and their parts returned to inventory in one operation.
• Select Discontinued for an item that is no longer available. If a discontinued item is entered in a data entry task, a message appears stating that the item is discontinued and asking whether or not to continue. If you click Continue, the item will be accepted. Alternately, inactive items cannot be entered at fields where the system checks the selection in the Inactive Item check box.

 

Valuation

Select the method for calculating the value of this item. After any activity is posted to the item, this field is not available.

 

Procurement

Select the procurement method for this item.

 

Weight

Type the weight of this item to calculate freight allocation. If using actual weight to calculate freight, the weight unit of measure entered in this field must be the same for all inventory items.

Note The Weight fields in the Sales Order module are defined as numeric only so that freight can be calculated on weight. The Weight field in this window allows you to use alpha characters so that informational notations can be made; however, to reflect the actual weight on an order or invoice, you must enter only numeric characters.

 

Volume

Type the volume of this item to calculate freight or landed cost allocation.

 

Inventory Cycle

Type a code representing the cycle associated with this item. Inventory cycles are used to group items for reporting and for physical inventory processing.

 

Price Code

Enter a price code for this item, or click the Lookup button to list all price codes. Price codes are defined in Price Code Maintenance.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Default Whse

Enter a default warehouse code representing the location of this item, or click the Lookup button to list all warehouse codes. This field is available only if the Require Multiple Warehouses check box is selected in Inventory Management Options.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Primary Vendor

Enter the vendor identification of the primary supplier of this item, or click the Lookup button to list all primary vendor numbers.

Alternately, start typing a vendor name to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list, and the vendor number will appear in the field.

Click the Multiple Vendor Lookup button to list all vendors for the item.

• If the Accounts Payable module is integrated with Inventory Management, this field can be used as a sort field for reports.

• If the Accounts Payable module is not integrated with Inventory Management, this field is for reference only.

• If you enter a vendor whose status is set to Inactive in Vendor Maintenance, a message appears warning that the vendor is inactive and cannot be used.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

A Sales Order inventory line item can be transferred to a drop ship purchase order only if the Vendor No. field on the purchase order matches either the primary vendor in Item Maintenance, or any of the vendor numbers entered using Item Vendors Maintenance.

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

 

Warranty Code

Enter a warranty code for this item, or click the Lookup button to list all warranty codes. Warranty codes are defined in Warranty Code Maintenance.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

A new warranty code can be added on the fly. The Warranty Code Maintenance (On the Fly) window appears; some nonessential fields are omitted to speed data entry. You can access Warranty Code Maintenance at a later time to complete the remaining entries for a new warranty code.

Note This field appears only if the Enable Warranty Tracking check box is selected in Inventory Management Options.

 

Retail Price

Enter the suggested retail price for this item, or click the Calculator button to enter an amount using the calculator. This price is used to produce price lists and other inventory listings but is not used for actual pricing in Sales Order Entry or Sales Order Invoice Data Entry.

 

Standard Price

Enter the standard price for this item, or click the Calculator button to enter an amount using the calculator. This price is used as a base for all sales order and invoice entries.

 

Last Sold

Enter the last date this item was sold, or click the Calendar button to select a date from the calendar. This field is updated automatically as inventory is processed.

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

 

Standard Cost

Enter the standard cost for this item, or click the Calculator button to enter an amount using the calculator. Standard cost is used for pricing and for calculating commission for standard cost items. This cost is not used to value the inventory unless the valuation method for this item is Standard Cost.

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

 

Average Cost

This field displays the calculated actual average cost of goods processed and can only be viewed.

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

 

Last Receipt

Enter the date of the last receipt of this item, or click the Calendar button to select a date from the calendar. This field is updated automatically as inventory is received.

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

 

Standard

Enter a standard unit of measure for this item, or click the Lookup button to list all units of measure. The default unit of measure should be the smallest (basic) unit of measure for this item. It is used to report all on-hand quantity information for this item. The standard unit of measure must be smaller than or equal to the purchase unit of measure and sales unit of measure.

Note If you enter a conversion unit of measure in Unit of Measure Conversion Maintenance in the Standard field and enter a unit of measure in the Purchases or Sales fields, the appropriate factor is entered automatically in the No. of fields. You can also manually enter these units of measure and quantities.

 

Purchases

Enter a purchases unit of measure to use a different unit of measure when this item is purchased, or click the Lookup button to list all units of measure. After the unit of measure is entered, enter a conversion factor to use in the No. of field.

Note If you enter a conversion unit of measure in Unit of Measure Conversion Maintenance in the Standard field and enter a unit of measure in the Purchases or Sales fields, the appropriate factor is entered automatically in the No. of fields. You can also manually enter these units of measure and quantities.

 

(Purchases) No. of

After the unit of measure is entered in the Purchases field, enter a conversion factor to use for the purchases' unit of measure. This field is available only if a unit of measure other than EACH is entered in the Purchases field.

Note If you enter a conversion unit of measure in Unit of Measure Conversion Maintenance in the Standard unit of measure field and enter a unit of measure in the Purchases unit of measure or Sales unit of measure fields, the appropriate factor is automatically entered in the field.

 

 

Sales

Enter a sales unit of measure to use a different unit of measure when this item is sold, or click the Lookup button to list all units of measure. After the unit of measure is entered, enter a conversion factor to use in the No. of field.

Note If you enter a conversion unit of measure in Unit of Measure Conversion Maintenance in the Standard field and enter a unit of measure in the Purchases or Sales fields, the appropriate factor is entered automatically in the No. of fields. You can also manually enter these units of measure and quantities.

 

(Sales) No. of

After the unit of measure is entered in the Sales field, enter a conversion factor to use for the sales unit of measure. This field is available only if a unit of measure other than EACH is entered in the Sales field.

Note If you enter a conversion unit of measure defined in Unit of Measure Conversion Maintenance in the Standard field and enter a unit of measure in the Purchases or Sales fields, the appropriate factor is automatically entered in the No. of fields. You can also manually enter these units of measure and quantities.

 

Item

This field displays the last cost item amount for this item and can only be viewed. This field is updated automatically as inventory is updated. This field is also automatically updated when new amounts are entered at either the Total or Allocated field. The last cost item amount plus the last cost allocated amount always equals the last cost total amount.

 

Allocated

Enter the last cost allocated amount for this item, or click the Calculator button to enter an amount using the calculator. The Item field amount is automatically updated when new amounts are entered at either the Total or Allocated field. The last cost item amount plus the last cost allocated amount always equals the last cost total amount.

 

Total

Enter the last cost total amount for this item, or click the Calculator button to enter an amount using the calculator. The Item field amount is automatically updated when new amounts are entered at either the Total or Allocated field. The last cost item amount plus the last cost allocated amount always equals the last cost total amount.

 

Quantities Grid

Use this grid to view detailed quantity information for the selected item and all warehouses, including future data entry transactions.

Click the Quantity Recap button located to the right of the grid to view the quantity received, adjusted, sold, issued, transferred, and on hand for the current period. The beginning and current average costs also appear. To view a recap for all warehouses or the selected warehouse, click the Switch to All Warehouses button in the Quantity Recap window.

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.

Select a row and click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.

Note Information on this grid is not available when creating items on the fly.

 

2. Additional

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

Confirm Cost Increase in Receipt of Goods

Select this check box to display a warning if, during receipt of goods entry for a purchase order, the unit cost is increased for this inventory item. If this check box is cleared, no warning appears. In either case, with the appropriate security setup, the unit cost can be increased.

This check box is available only if the Purchase Order module is integrated with Inventory Management.

 

Print Receipt Labels

Select a receipt label option.

• Select Yes to print one receipt label for all quantities of this item.
• Select No if you do not want to print receipt labels.
• Select By Item to print separate receipt labels for each individual item.

 Example

If item XYZ has a quantity of 50 and Yes is selected, one label is printed for the item. If By Item is selected, 50 labels are printed. 

Note If the item is a serial item, selecting Yes or By Item prints separate receipt labels for each item.

 

Explode Kit Items

Select an option to determine how kit items are handled when creating sales orders or invoices.

• Select Prompt to display a message during data entry prompting whether or not you want to order items from stock. Clicking Yes at the message does not explode kits; it orders the kit from stock. If a sales kit is exploded on a cross-ship line in the Return Merchandise Authorization module, the components do not explode on the sales order until the line is accessed and the sales order is accepted.
• Select Always to automatically explode the component lines for the kit item without being prompted with a message. This also explodes the kit on both the RMA and the sales order and relieves inventory of the component items.
• Select Never to order the kit line item from stock without being prompted with a message. The component lines will not automatically be exploded. If Never is selected, the kit item rather than the components are relieved from inventory.

Note This field is available only if a kit item type is selected.

 

Next Lot/Serial Number

Enter the lot or serial number to be automatically assigned when creating a new item using the Bill of Materials or Work Order modules, or when clicking the Add Serial Numbers button or the Next Lot Number button in Lot/Serial Number Distribution. This field is available only for lot or serial items.

 

Commission Method

Select the commission method to use for calculating commission on this item. The Percent of Cost, Percent of Gross Profit, and Percent of Price methods are available only if the Calculate Commission by Inventory Item check box is selected in Inventory Management Options.

 

Commission Rate

Type the percentage to use to calculate commission for this item. This field is available only if the Calculate Commission by Inventory Item check box is selected in Inventory Management Options, and Percent of Cost, Percent of Gross Profit, or Percent of Price is selected in the Commission Method field.

The rate entered in this field can be overridden by rates and amounts entered in the Commission Rate / Amount field in Line Item Commission Maintenance; whether this rate is overridden depends on the effective date, customer, and salesperson entered in Line Item Commission Maintenance.

 

Base Commission

Type the base commission amount for this item. The total commission amount equals the total of the base commission plus the commission rate amount. This field is available only if the Calculate Commission by Inventory Item check box is selected in Inventory Management Options, and Percent of Cost, Percent of Gross Profit, or Percent of Price is selected in the Commission Method field.

The amount entered in this field can be overridden by the amount entered in the Commission Amount field in Line Item Commission Maintenance; whether this rate is overridden depends on the effective date, customer, and salesperson entered in Line Item Commission Maintenance.

 

Allow Returns

Select this check box to allow returns for this item using the Return Merchandise Authorization module. Clear this check box if you do not want to allow returns for this item. This check box is available only if the Allow Back Orders check box is selected.

Note This check box appears only if the Return Merchandise Authorization module is activated.

 

Restocking Charge Method

Select a restocking charge method for this item. Restocking charges are administrative charges that may be charged to the customer to return merchandise.

Note This field appears only if the Allow Returns check box is selected and the Return Merchandise Authorization module is activated.

 

Restocking Charge Amount/Rate

Type a restocking charge or rate for this item.

Note This field appears only if the Return Merchandise Authorization module is activated and the Allow Returns check box is selected. If Fixed is selected in the Restocking Charge Method field, this field appears as Restocking Charge Amount. If % Item Cost or % Item Price is selected, this field appears as Restocking Charge Rate.

 

User-Defined Categories

If descriptions for user-defined sort fields (categories) are entered in Inventory Management Options, those descriptions are displayed here. Enter the appropriate sorting information for each category.

 

Sales Tax Class

Enter a sales tax class for this item, or click the Lookup button to list all sales tax classes.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Purchases Tax Class

Enter a purchases tax class for this item, or click the Lookup button to list all purchases tax classes.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Routing No.

Enter a routing number to use to produce this item. If the Work Order module is installed, click the Lookup button to list all routing numbers. If the Work Order module is not installed, this field is used for reference only.

This field is available if the Production Management module is not activated.

 

Template No.

Enter a work ticket template number to use to produce this item. Click the Lookup button to list all template numbers.

This field is available if the Production Management module is activated.

 

Buyer Code

Enter a buyer code, or click the Lookup button to list all buyer codes.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Planner Code

Enter a planner code, or click the Lookup button to list all planner codes.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

 

Commodity Code

Enter a commodity code for this item or click the Lookup button to list all commodity codes. This will be the default commodity code used in Sales Order data entry tasks. Commodity codes are included with the Level 3 data transmitted when processing Level 3 credit card transactions.

 

Image

Enter an image file to associate with this item, or click the Browse File button to browse for an image file. Click the Show Image button to preview the image file. Inventory item images are stored in the MAS90\Images\xxx folder (where xxx is the company code) on the server and published to the Internet Information Services (IIS). Because all image files reside at the same Internet Information Services location, image file names must be unique system wide.

Warning When .bmp images are used on a Web page, performance is extremely slow.

If you are using Sage 100 Advanced, to use the Image feature, you must have entered a UNC path in the Sage 100 Advanced Server field during Workstation Setup.

 

Inactive Item

Select this check box to make the item inactive. If an item is inactive, it cannot be entered when adding a line in Sales Order Entry, Sales Order Invoice Data Entry, Purchase Order Entry, Receipt of Goods Entry, Receipt of Invoice Entry, and Material Requisition Issue Entry. An inactive item can be entered when adding a line in Return of Goods Entry and Inventory Management Transaction Entry only if the appropriate security is set up. Alternately, if Discontinued is selected at the Product Type field and the item is entered in a data entry task, a message appears stating that the item is discontinued and asking whether or not to continue. If you click Continue, the item is accepted.

Note If an active kit containing inactive components is exploded in one of the data entry tasks listed above, the components will be treated as active.

Note Internet-enabled items cannot be inactive. When this check box is selected for an item, the Internet Enabled check box is cleared and disabled.

Clear this check box to make the item active.

 

Allow Back Orders

Select this check box to allow back orders for this item. Clear this check box if back orders are not allowed for this item.

Note You must select this check box to enable the Allow Returns check box. After the Allow Returns check box is selected, this check box will become disabled.

 

Allow Trade Discount

Select this check box to allow a trade discount on this item. Clear this check box if a trade discount is not allowed.

 

Allocate Landed Cost

Select this check box to allocate landed cost for this item. Clear this check box if allocating landed cost is not allowed.

 

Internet Enabled

Select this check box to enable Internet access for the current item. Clear this check box to disable Internet access. This field is available only if the eBusiness Manager module is installed and the Inactive Item check box is cleared. If this check box is selected and the Inactive Item check box is then selected, this check box will be cleared and disabled.

Note This field is not available for Sage 100 Premium.

 

Last Physical Count

This field displays the posting date from the last Physical Count Variance Register update for this item, and it can only be viewed. To view the last physical count date by warehouse, see the Quantities grid on the Main tab or the Quantity tab.

 

3. Quantity

 

Standard Unit of Measure

This field displays the unit of measure for the item and can only be viewed.

 

Quantity Grid

Use this grid to view detailed quantity information for the selected item and all warehouses, including future data entry transactions.

The buttons located to the right of the grid allow you to see details for the selected warehouse and view reorder information.

• Click the Quantity Recap button to view the quantity received, adjusted, sold, issued, transferred, and on hand for the current period. The beginning and current average costs also appear.

• Click the Delete Item Warehouse button to remove the warehouse. This button is available only for warehouses with zero quantities.

• Click the Reorder button to view the reorder data for the item. You can determine which amount is used to calculate the recommended order quantity when the available quantity falls below the reorder point.

• Click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.

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.

 

Totals Grid

Use this grid to view a total for all warehouses.

 

4. History

Note In Item Inquiry, this tab is available only with the appropriate security setup. Additionally, some fields will be hidden and disabled depending on the security setup.

Warehouse

Enter a warehouse code to view detailed quantity, sales, and receipt history information, or click the Lookup button to list all warehouse codes. This field displays the warehouse entered at the Default Whse field for the selected item, but it can be changed. Click the Switch to All Warehouses button to view information for all warehouses. The Switch to All Warehouses button is available only if the Require Multiple Warehouses check box is selected in Inventory Management Options.

If you change the default warehouse, you can use the Browse buttons in the Item Code field to scroll through the items, and the warehouse will remain constant. If you do not change the warehouse, you can use the Browse buttons to scroll through items, and the default warehouse for the item appears.

 

Quantities

Select this option to view quantity in the grid by warehouse. Information shown for each item includes the beginning quantity, quantity sold, received, adjusted, and issued, and the ending quantity in the same period.

Click Compare PY to display the quantity sold, prior year quantity sold, variance percentage, quantity received, and prior year quantity received information. For more information, see Information Displayed in the Item Maintenance History Grid.

Note The Var % field displays the variance percentage based on the current year quantity sold compared to the prior year quantity sold.

 

Sales

Select this option to view sales history in the grid for the item by warehouse. Information shown for each item includes the quantity, dollars sold, cost of sales, and quantity returned in the same period.

Click Compare PY to display the dollars sold, prior year dollars sold, cost of sales, prior year cost of sales, profit percentage, and prior year profit percentage information. For more information, see Information Displayed in the Item Maintenance History Grid.

 

Receipts

Select this option to view receipt history in the grid for the item by warehouse. Information shown for each item includes the quantity received, quantity produced, cost of goods, and quantity returned in the same period.

Click Compare PY to display the quantity received, prior year quantity received, quantity produced, prior year quantity produced, cost of goods sold, and prior year cost of goods sold information. For more information, see Information Displayed in the Item Maintenance History Grid.

 

Year

Select the year to view detailed quantity, sales, and receipts history information. This field defaults to the current year.

Note If Fiscal Periods is selected in the Base Inventory Periods On field in Inventory Management Options, the year defaults to the value set in the Current Fiscal Year field in Inventory Management Options. If Calendar Months is selected in the Base Inventory Periods On field, the year defaults to the value set in the Current Calendar Year field in Inventory Management Options.

 

History Grid

Use this grid to view information for a selected warehouse or all warehouses for all periods by year. You can view the information on the grid by quantity, sales, or receipts by selecting the Quantities, Sales, or Receipts option.

The buttons located to the right of the grid allow you to switch views to see details for all warehouses and view additional information with prior year comparisons.

• Click the Zoom button to drill into transaction history.

• Click CustSales to view detailed sales history by customer.

• Click VendRcpt to view detailed receipt history by vendor.

For more information, see Customer Sales History / Vendor Receipt History.

 

5. Transactions

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

Warehouse

Enter a warehouse code to view transaction information for that warehouse, or click the Lookup button to list all warehouse codes. Click the Switch to All Warehouses button to view transactions for all warehouses. The Switch to All Warehouses button is available only if the Require Multiple Warehouses check box is selected in Inventory Management Options.

By default this field displays the warehouse entered in the Default Whse field for the selected item, but it can be changed.

If you change the default warehouse, you can use the Browse buttons in the Item Code field to scroll through the items, and the warehouse will remain constant. If you do not change the warehouse, you can use the Browse buttons to scroll through items, and the default warehouse for the item appears.

 

Transactions Grid

Use this grid to view transaction detail for the current item.

This grid shows transactions for the default warehouse and the date range determined by the Default Selection field in Inventory Management Options.

Use the buttons located to the right of the grid to refine the list.

• Click the Search button to search transaction history for a different date range or to limit the types of transactions displayed.

• Click the Zoom button to drill into transaction history.

• Click the Lot/Serial Inquiry button to drill into lot and serial detail for the selected line if the item uses the lot or serial number valuation method.

• Click the Journal Zoom button to view detailed source journal information associated with the selected transaction.

• Click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.

The transaction detail displayed includes the warehouse, description, transaction date, type, reference number, quantity, unit cost, allocated cost, extension, and source journal for each transaction.

If the Purchase Order module is integrated with Inventory Management and the Allow Entry of Landed Cost check box is selected, the Item Cost and Allocated Cost fields also appear.

A total of all transactions also appears, providing you with the beginning and ending quantities for the selected date range.

 

Totals Grid

Use this grid to view a total of all transactions including the beginning and ending quantities for the current period.

 

6. Orders

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

Purchase Order

Select this option to view the open purchase orders for the current item. The purchase order number, type, vendor number, name, required date, warehouse, ordered amount, quantity received, and quantity backordered are displayed for each open order.

All open purchase orders for the current item are displayed sequentially by order number.

Click the Search button to search for purchase order types, order numbers, vendor numbers, required dates, or warehouses if the Require Multiple Warehouses check box is selected in Inventory Management Options.

Click the Zoom button to open the Purchase Order Inquiry window. This option is available only if the Purchase Order module is integrated with Inventory Management.

Note In Item Inquiry, the Vendor No. and Vendor Name columns are available only with the appropriate security setup.

 

Sales Order

Select this option to view all open sales orders for the current item. This option is available only if the Sales Order module is integrated with Inventory Management. If the Enable Lot/Serial Distribution check box is selected in Sales Order Options, you can view the sales orders by lot/serial number in addition to the standard sales order number. The View Lot/Serial button allows you to toggle between the two views.

• The default sales order view displays the sales order number, type, customer number, name, order date, warehouse, ordered quantity, quantity shipped, quantity backordered, and promise date for each open sales order. All open sales orders for the current item are displayed sequentially by order number.

• The View Lot/Serial view displays the lot/serial number, customer number and name, order number and date, warehouse, quantity ordered, promise date, and customer purchase order number for all sales order lot/serial distributions.

Click the Search button to search for sales order types, order numbers, customer numbers, order dates, and promise dates. You can also search for warehouses if the Require Multiple Warehouses check box is selected in Inventory Management Options. Click the Zoom button or double-click any line to open the Sales Order Inquiry window for the selected line.

 

Work Order

Select this option to view all open work orders for the current item. The work order number, make for, customer number, step number, due date, warehouse, ordered quantity, and completed quantity are displayed for each work order.

All open work orders for the current item are displayed sequentially by work order number.

Click the Search button to search for work orders made for, work order numbers, customer numbers, due dates, or warehouses if the Require Multiple Warehouses check box is selected in Inventory Management Options.

Click the Zoom button to open the Work Order Inquiry window. This option is available only if the Work Order module is integrated with Inventory Management.

 

Work Ticket

Select this option to view all open work tickets for the current item. The work ticket number, description, status, type, make for, warehouse code, step number, due date, and ordered, completed, required, issues, and allocated quantities are displayed for each work ticket.

Click the Search button to search for a work ticket. Select a work ticket and then click the Zoom button to open the Work Ticket Inquiry window.

This field is available if the Production Management module is activated.

 

Orders Grid

Use this grid to view information based on the option selected. Options are displayed only for modules integrated with Inventory Management.

The buttons located to the right of the grid allow you to switch views to view additional information.

• Click the Search button to perform a search for transactions.

• Click the Zoom button to drill into transaction inquiry, such as Purchase Order Inquiry.

 

Ordered

This field displays the total quantity ordered for the selected item and can only be viewed.

 

Received

This field displays the total quantity received for the selected item and can only be viewed. This field is available only if the Purchase Order module is integrated with Inventory Management.

 

Shipped

This field displays the total quantity shipped for the selected item and can only be viewed. This field is available only if the Sales Order module is integrated with Inventory Management.

 

Completed

This field displays the total quantity completed for the selected item and can only be viewed. This field is available only if the Production Management module or the Work Order module is integrated with Inventory Management.

 

Required

This field displays the total required quantity for all work tickets associated with this item and can only be viewed.

This field is available if the Production Management module is integrated with Inventory Management.

 

Issued

This field displays the total issued quantity for all work tickets associated with this item and can only be viewed.

This field is available if the Production Management module is integrated with Inventory Management.

 

Allocated

This field displays the total allocated quantity for all work tickets associated with this item and can only be viewed.

This field is available if the Production Management module is integrated with Inventory Management.

 

Back Ordered

This field displays the total quantity back ordered for the selected item and can only be viewed.

 

Quoted

This field displays the total quantity included in Sales Order quotes for the selected item and can only be viewed.

 

7. Cost Detail

Note This tab is not available for items that use the Standard Cost or Average Cost valuation method.

Warehouse

Enter a warehouse code to view cost detail information, or click the Lookup button to list all warehouse codes. This field displays the warehouse entered in the Default Whse field for the selected item, but it can be changed. Click the Switch to All Warehouses button to view information for all warehouses. The Switch to All Warehouses button is available only if the Require Multiple Warehouses check box is selected in Inventory Management Options.

If you change the default warehouse, you can use the Browse buttons in the Item Code field to scroll through the items, and the warehouse will remain constant. If you do not change the warehouse, you can click the Browse buttons to scroll through items, and the default warehouse for the item appears.

 

Valuation

This field displays the valuation method for the selected item and can only be viewed.

 

Cost Detail Grid

Use this grid to view cost tier information for LIFO, FIFO, Lot, or Serial valuation methods for selected warehouse or all warehouses. The cost detail displayed includes the warehouse, description, receipt date, receipt number, quantity, unit cost, committed, available, and extension amount. If the Purchase Order module is integrated with Inventory Management and the Allow Entry of Landed Cost check box is selected in Purchase Order Options, the Item Cost and Allocated Cost fields also display.

If the Sales Order module is integrated with Inventory Management and the Enable Lot/Serial Distribution check box is selected in Sales Order Options, the Committed field is replaced with SO Committed and Other Committed fields.

Click the Search button to search transaction history.

Select a row and click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.