Search Bar: ICIP
Menu: Product > Inquiry> Product
Bookmark: ICIP – Product Inquiry
- Enter the product and the warehouse.
- Click <Search>
Details that can be found per View in ICIP:
General
Description: full item description that prints on all Sx.e documents
Status: Active or Inactive
Category: Sales Reporting reference
Control: Serial Product, if the item is set up as such
SERIAL: Option only seen if item is a Serial Product
Dates:
PO or WT: Latest Entry date for an inbound WT or PO
Invoice: Last date a Sales Order invoiced for this item
Price Change: Last system price update
Receipt: Last time this item was received
Count: Last time this item appeared on an Inventory Count
YTD Balances:
Issues: Units sold
Receipts: Units Received
Returns In: Units returned from customer
Returns Out: Units returned to Vendor
Balances:
On Hand: Current inventory
Reserved: Quantity on an Outbound WT or Sales order that has not yet printed
Committed: Quantity on an Outbound WT or Sales order that has printed – but not yet processed
Net Available = On-Hand – Reserved – Committed
Back Order: Quantity represented on sales orders that are waiting to be filled
On Order: Total inbound quantity
Received: there should never be a quantity in this field. We are set to update to OnHand.
Unavailable: inventory that is waiting for a management/vendor decision on next steps.
Warehouse Transfer In Transit: Shipped Quantities on transfer(s) that have not yet been received
Warehouse Transfer Ship Requests: Quantity on Transfer(s) that have not yet been approved
Warehouse Transfer Receipt Request: Not used
Demand: B/O Quantity represented on warehouse transfer(s) that are waiting to be filled
Balances:
Pricing
List Price is found here
Quantity Price Break
Transactions – History
Transactions will display all transactions that posted for the item.
The display can be limited by Transaction (Module type), Date, and Transaction type.
Click <Search> to view all records based on Criteria entered.
To View more details per transaction, click the <arrow> next to the transaction in question.
Posted Date: When the transaction updated the item
Module: Function that updated the item
Order #: Order # reference
Order Suffix: was it is backorder?
Line #: Line that the item appeared on the order
Name: Customer, Vendor or Warehouse associated with this Order
Inc/Dec: +/- Did the transaction add or releave inventory
Transaction: What was the Transaction type?
Unavailable
This screen lists the details regarding unavailable quantities of an item. This quantity still has value and it is part of the inventory valuation report for your branch. Action should be performed to get this inventory out.
This screen lists the details regarding unavailable quantities of an item. This quantity still has value and it is part of the inventory valuation report for your branch. Action should be performed to get this inventory out of your inventory.
Replenishment
Authorized Replenishment Path (ARP): The normal vendor the item is purchased.
Usage: How many of this item potentially will be sold (per month) based on historical data.
Click <USAGE> icon to view the following values from the previous year’s sales.
1+4-1+1+0+2/6 = 1.1666 per month.
Ordering Controls: Recommended stock quantities and ordering controls
Cross Reference
A listing of any cross-referenced values to this item
