Maintain Stock Item

From eStream Software

Menu: Stock | Maintain Stock Item...

Introduction

To setup the stock item list.
Stock-Maintain Stock Item-01.jpg


Maintain Stock Item

Main Header

Maintain Stock Item entry form as shown the screenshot below.
Stock-Maintain Stock Item-02b1.jpg
Field Name Explanation & Properties
Code
  • Input the new Stock Code
  • Field type : Alphanumerical
  • Length : 30
Description
  • Input the Stock Description (This usually will appear in most of the documents print-out, eg. invoice, purchase order, etc...)
  • Field type : Alphanumerical
  • Length : 200
2nd Description
  • Input the 2nd Description, eg. size, alternative product name.
  • Field type : Alphanumerical
  • Length : 200
Serial No.
  • Tick to enable serial control items. (It required Serial Number module.)
  • Field type : Checkbox
Stock Control
  • Tick to enable stock control. System will check on the availability stock balance not below zero or re-order level.
  • Field type : Checkbox
Active
  • Tick for the stock in use. Otherwise, untick for discontinue stock.
  • Field type : Checkbox
Item Group
  • Select an appropriate Stock Group.
Base UOM
  • Enter a base UOM for stock valuation, eg. UNIT.
Ref. Cost
  • Enter a standard cost.
Ref. Price
  • Enter a standard selling price.
Shelf
  • Enter a shelf/rank no., eg. A-01, A-02, A-03 in location A.
Reorder Level
  • Enter a stock reorder level to alert to place new order.
  • Refer to menu: Stock \ Print Stock Reorder Advice...
Reorder Qty
  • Enter a reorder qty (MOQ).
Lead Time
  • Enter a lead time to receive the goods.
Output Tax
  • Enter a default Output Tax.
Input Tax
  • Enter a default Input Tax.
Remark 1
  • Free field to enter extra info.
Remark 2
  • Free field to enter extra info.
Barcode
  • Enter a barcode (represent base UOM).
Tariff
Bal Qty
  • Display the latest qty balance.


UOM

1. Allow to set multiple UOM, eg. 1 carton = 12 units.
2. Beside that, you can set the default UOM for Sales, Purchase and Stock entry form.
3. See the screenshot below.
Stock-Maintain Stock Item-02c.jpg


Cust.Price

1. Allow to set multiple pricing/contract price for customer.
2. You can use price tag to tag the price for a customer.
3. It is required multiple pricing module.
4. See the screenshot below.
Stock-Maintain Stock Item-02d.jpg


Supp.Price

1. Allow to set multiple pricing/contract price for supplier.
2. You can use price tag to tag the price for a supplier.
3. It is required multiple pricing module.
4. See the screenshot below.
Stock-Maintain Stock Item-02e.jpg


BOM

1. Allow to setup recipes/ingredients for a manufactured product.
2. It is required Bill of Materials module.
3. See the screenshot below.
Stock-Maintain Stock Item-02f.jpg


More Desc.

1. Enter the product details or specifications.
2. See the screenshot below.
Stock-Maintain Stock Item-02g.jpg


Tips:
Example view from Sales Tax Invoice:
Stock-Maintain Stock Item-02o.jpg


Opn Bal.

To enter the Opening Stock qty and value balances.
Stock-Maintain Stock Item-02h.jpg


Category

1. To set the multiple stock category for reporting purpose, eg. country origins, brands, etc.
2. See the screenshot below.
Stock-Maintain Stock Item-02i.jpg


Alternative

Enable to identify the alternative items to replace.
Stock-Maintain Stock Item-02j.jpg


Cust. Item

1. To enter the customer item code and description.
2. Purpose is to search or print the customer item code and description in tax invoice instead of using the original item description.
Stock-Maintain Stock Item-02k.jpg


Supp. Item

1. To enter the supplier item code and description.
2. Purpose is to search or print the supplier item code and description in purchase invoice instead of using the original item description.
Stock-Maintain Stock Item-02l.jpg


Barcode

1. To enter the barcode for different UOM.
2. See the screenshot below.
Stock-Maintain Stock Item-02m.jpg


Note

1. Others stock information.
Field Name Type Explanation
Item Creation Date Date Item created date.
Item Matrix Lookup Required Stock Matrix module.
Min Qty Float Enter the minimum qty.
Max Qty Float Enter the maximum qty.
Picture Picture Load a product picture.

Recommend to load the picture size (jpg or jpeg) less than 16kb.

Note Rich Text Enter the product additional information for internal view.


2. See the screenshot below.
Stock-Maintain Stock Item-02n.jpg


Note: 
Do not load the picture size more than 16kb. This is to avoid the database size growth bigger.

See also