Inventory File

The IC Inventory File contains all the information required to define an item in your store's inventory.
 
Inventory File
1

Grid

1. Grid
This opens the POS Grid, from which you can select an item for viewing in the inventory file.
For more information on the Grid, see POS Grid.
2

Item ID

2. Item ID
The Item ID is an alphanumeric relationship to a specific SKU within the inventory system.  
The Item ID can be changed, and the system retains all historic information.  The system prompts the user to retain the "old" Item ID that is stored within the Lookup By listing.
3

Description

3. Description
The item description field allows up to 70 characters to describe the product.  Further information can be placed within item notes.
4

Type and Matrix

4. Type and Matrix

Item Type

Item Type describes different types of inventory (i.e. stock vs non-stock).  Further details are available within "Types of Inventory".  Comment Item Type will print a comment without any quantity or price on the invoice.
 
Item Type can not be edited if there is stock on hand for an item.
 
Matrix
An item can be defined as Serial (Serialized numbers), Cut pieces, Board foot, Weight, or Distinct. The CPM must be set to Mxt Qty.  Once an item is defined to be Serial with items in inventory, it can not be changed back to None.  If Serial is selected, the Decimals field is dropped.  Cut Pcs items will be prompted for the dimensions to calculate the price when sold.  Board Ft will add the Bd Ft field to the item screen.  The total board feet of the item can then be entered.  The MBF, thousand board feet, for the item will then be displayed and printed on the invoice.  For Weight items, the Gross and Tare weights will be entered to calculate the Net weight for the retail price. Distinct item types will not be combined or summarized with like items on an invoice. If the Item Type is "Coupon," you can change the Matrix to the type of coupon you want (Percent off or Dollar off).
Note: Matrix can not be edited if there is stock on hand for an item.
5

Clone

5. Clone
creates a duplicate of the item under a new item ID 
 
For more information on cloning an item, see Clone.
6

TA ID

6. TA ID
The TA ID field contains the cost of the currently selected item.  If you reverse the sequence of the item's cost,  the digits to the left of the two alpha characters indicate the cents portion of the cost reversed.  The digits to the right of the alpha characters indicate the reversed dollar value of the item.
  
TA ID
Actual Cost
71LD0
$0.17
83KH01
$10.38
 
Why, you say?  From the main menu, select the Inventory (F4) button within the Shortcut area of the screen.  Inventory information will appear, but it will not include cost information.  This will allow a sales clerk to freely review the inventory module with a customer without disclosing cost information.
7

No Refunds

7. No Refunds
Select this option to not allow refunds for the selected item.
8

Quantities

8. Quantities
This area shows item quantities related to Service Tickets (WIP), Sales Orders (Allocated), Purchase Orders (On Order), shelf quantity (On-hand) and shelf quantity - allocated (Available).
 
WIP Qty
WIP (Work in Process) is the quantity of the item used in a service ticket that has not yet been invoiced.  When an item is placed on a service ticket, the on-hand quantity is reduced, and the item is added to the WIP quantity.  When the service ticket is invoiced, the item is removed from inventory, and the WIP quantity is adjusted.  You can view the service tickets containing this item by double-clicking on the WIP Qty field.
 
Allocated
Allocated is the quantity of the item placed on open sales orders.  You can view the sales orders containing this item by double-clicking the Allocated field.
 
On Order
The quantity s represented in this field at the current stocking unit. You can view the purchase orders on which this item is placed by double-clicking the On Order field.
 
Red Font in the On Order Field
If the On Order field shows a red zero, the system contains two or more purchase orders which net total of zero.
 
In the example below, PO number 75 contains an order for 50 units while PO number 82 - a Return PO - contains a return of 50 units.  The net total of the current purchase order activity will be zero.  When the total of purchase orders and return purchase orders equal zero, the system will display a red zero in the On Order field.  Double clicking on the field will display the list of purchase orders.
 
A more detailed list of open purchase orders is available within the Reports | On POs.
 
On Hand
On Hand is the total quantity from the shelf and warehouse locations.
 
Available
The Available quantity is the current On-hand less the Allocated (Sales Order) quantity. 
9

Print Label

9. Print Label
You can print a label for the current item.
 
For more information on printing a label, see Print Label.
10

Sales History

10. Sales History
The Sales History button presents a sales summary for the current year of the selected item.
For more information on Sales History, see Sales History.
11

Quick
Sales

11. Quick
Sales
This opens the Item Sales report from the first of the previous month to the current date.
Upon closing the report, you can reenter the starting date and rerun the report if desired.
12

Display Unit

12. Display Unit
The Display Unit allows for the selection of the desired unit of measure as it relates to the on-hand quantity.
13

Q-ECat

13. Q-ECat
Lists the E-Catalog information for this item, if it is available.
14

Location

14. Location
The location field indicates the physical location within the store.  Typically, aisles are assigned a location code (A1,A2, B1, B2, etc...), and the inventory is assigned to this location by entering the location code in this field.
15

Catalog
Page

15. Catalog
Page
The Catalog Page field is used to indicate the page number where the current item is located in the manufacturer’s product catalog.
16

Country

16. Country
This field is used to designate the country in which the item was manufactured.
17

Price Book and Sequence

17. Price Book and Sequence
If the item belongs to a price book, you can select it from the dropdown menu and enter the sequence number.
For more information on using price books, see Price Book Maintenance.
18

IC Tabs

18. IC Tabs
The IC tabs contain detailed information and settings regarding specifications, pricing, and available vendors for each item.  For detailed information on the IC tabs, see IC Tabs.
19

Order Item

19. Order Item
This opens a "quick order" screen.  The oldest open pre-PO for the primary vendor is automatically selected as the PO on which to place the item.  Clicking New PO places the item on a new pre-PO for the primary vendor.
20

Associated

20. Associated
Associated items are additional items included on the invoice when the primary item is entered into an invoice
21

Adjust Cost

21. Adjust Cost
The Adjust Cost button allows the user to change the various types of cost of the current item
22

Adjust Quantity

22. Adjust Quantity
The Adjust Qty (quantity) allows the used to adjust the quantity of the item by posting either a receipt, issue or physical count of the item thus altering the on-hand level of the current item.