Maintain Stock Item: Difference between revisions

From eStream Software
 
(35 intermediate revisions by 2 users not shown)
Line 3: Line 3:
==Introduction==
==Introduction==
:To setup the stock item list.
:To setup the stock item list.
::[[File:Stock-Maintain Stock Item-01.jpg |700px]]
[[File:Stock-Maintain Stock Item-01.jpg |700px|center]]
<br />
<br />
<div style="float: right;">  [[#top|[top]]]</div>


==Maintain Stock Item==
==Maintain Stock Item==
::[[File:Stock-Maintain Stock Item-02.jpg |700px]]
===Main Header===
===Main Header===
: Maintain Stock Item entry form as shown the screenshot below.
: Maintain Stock Item entry form as shown the screenshot below.
::[[File:Stock-Maintain Stock Item-02b.jpg |700px]]
[[File:Stock-Maintain Stock Item-02b1.jpg |700px|center]]


::{| class="wikitable"
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
|-
! Field Name !! Explanation & Properties
! Field Name !! Explanation & Properties
Line 83: Line 82:
| Barcode ||  
| Barcode ||  
* Enter a barcode (represent '''base UOM''').
* Enter a barcode (represent '''base UOM''').
|-
| Tariff ||
* Assigned a tariff code.
* Lookup from [[Maintain Tax]]
* Related Topic [[Maintain_Customer#Tax]] , [[Maintain_Supplier#Tax]]
|-
|-
| Bal Qty ||  
| Bal Qty ||  
Line 90: Line 94:


===UOM===
===UOM===
:Allow to set multiple UOM. See the screenshot below.
:1. Allow to set multiple UOM, eg. 1 carton = 12 units.
::[[File:Stock-Maintain Stock Item-02c.jpg |700px]]
:2. Beside that, you can set the default UOM for Sales, Purchase and Stock entry form.
:3. See the screenshot below.
[[File:Stock-Maintain Stock Item-02c.jpg |600px|center]]
<br />
 
===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.
[[File:Stock-Maintain Stock Item-02d.jpg |600px|center]]
<br />
 
===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.
[[File:Stock-Maintain Stock Item-02e.jpg |600px|center]]
<br />
 
* Related Topic : [https://sites.google.com/site/sqlestream/sql-financial-accounting/7-system-setting/7-20-how-is-the-price-tag-work How is the Price Tag work?]
 
===BOM===
:1. Allow to setup '''recipes/ingredients''' for a manufactured product.
:2. It is required '''Bill of Materials''' module.
:3. See the screenshot below.
[[File:Stock-Maintain Stock Item-02f.jpg |600px|center]]
<br />
 
===More Desc.===
:1. Enter the product details or specifications.
:2. See the screenshot below.
[[File:Stock-Maintain Stock Item-02g.jpg |600px|center]]
<br />
'''Tips:'''
Example view from Sales Tax Invoice:
[[File:Stock-Maintain Stock Item-02o.jpg |700px|center]]
 
<br />
 
===Opn Bal.===
:To enter the Opening Stock qty and value balances.
[[File:Stock-Maintain Stock Item-02h.jpg |600px|center]]
<br />
 
===Category===
:1. To set the multiple stock category for reporting purpose, eg. country origins, brands, etc.
:2. See the screenshot below.
[[File:Stock-Maintain Stock Item-02i.jpg |600px|center]]
<br />
 
===Alternative===
:Enable to identify the alternative items to replace.
[[File:Stock-Maintain Stock Item-02j.jpg |600px|center]]
<br />
 
===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.
[[File:Stock-Maintain Stock Item-02k.jpg |600px|center]]
<br />
 
===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.
[[File:Stock-Maintain Stock Item-02l.jpg |600px|center]]
<br />
 
===Barcode===
:1. To enter the barcode for different UOM.
:2. See the screenshot below.
[[File:Stock-Maintain Stock Item-02m.jpg |600px|center]]
<br />
 
===Note===
:1. Others stock information.
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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. <br />
Recommend to load the picture size (jpg or jpeg) '''less than 16kb'''.
|-
| Note || Rich Text || Enter the product additional information for internal view.
|}<br />
:2. See the screenshot below.
[[File:Stock-Maintain Stock Item-02n.jpg |600px|center]]
<br />
'''Note: '''
Do not load the picture size more than 16kb. This is to avoid the database size growth bigger.
 
<div style="float: right;">  [[#top|[top]]]</div>
 
==See also==
* [[Maintain Stock Group]]
* [[Maintain Tariff]]
* [[Maintain Tax]]
* [[Maintain Supplier]]
* [[Maintain Customer]]

Latest revision as of 03:55, 14 September 2018

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