Stock Item Maintenance
Stock Item Maintenance
This is to maintain transaction items.
Go to Stock > Stock Item Maintenance
Stock item listing will be displayed..
Create A New Stock Item
Go to Stock > Stock Item Maintenance
Click on Create a New Stock Item,
Item Code: key in the item code of this item. OR click on the '+' sign to auto generate the item code according to the format set at Tools > Options > Stock > General Stock Setting.
Description: key in stock item description; the second row is called Description 2.
Total Balance Qty: display of total balance quantity for this item.
Lead Time: the estimated time of delivery by supplier once the PO is placed.
Duty Rate: the rate of custom duty for this item. (refer to module Landing Cost)
Supply/Purchase Tax Type: select the tax type for this item. Tax type is maintained at GST > Tax Code Maintenance (only when GST is enabled at Tools > Options > General > Goods and Service Tax)
Item Group: select the stock group (maintained at Stock Group Maintenance); for the purpose of report filtering and posting to G/L account.
Item Type: select the stock item type (maintained at Stock Item Type Maintenance); for the purpose of report filtering.
Item Brand: select the stock item brand (maintained at Stock Item Brand Maintenance); for the purpose of report filtering.
Item Category: select the stock item category (maintained at Stock Item Category Maintenance); for the purpose of report filtering.
Item Class: select the stock item class (maintained at Stock Item Type Maintenance); for the purpose of report filtering.
Apply in: to determine the item to be use in sales, purchase, POS, raw materials or finish goods.
Active: active item means still in transaction.
Has Promoter: this is to be used with AutoCount POS.
Discontinued: means no more new purchases of this item (this item will not appear for selection for PO and Request Quotation); however it is still allowed for Purchase Return, Purchase Invoice, Goods Receive Note and Cash Purchase if some orders were made before. Selling of this item is allowable.
Auto UOM Conversion: when this checkbox is checked, the item will auto convert to a smaller UOM whenever there is back order in the stock.
Back Order Control: when this checkbox is checked (by default, it is checked), the back order notification screen will be prompted when this item has reached the back order level (when issuing quantity is larger than on-hand balance quantity). This function subjects to the user's access rights of back order control (General Maintenance > User Maintenance > Access Rights, look into Invoicing > Sales > Back Order Action. )
When this checkbox is not checked, it means there is no control on negative stock of this item, the notification screen will not be prompted, and users are allowed to save.
Costing Method: select the costing method of this item. The default costing method is set at Tools > Options > Stock > Stock Costing.
This system supports different costing methods for different items.
Fixed Cost: the Standard Cost will be referred.
Weighted Average: average cost will be updated with each purchase.
FIFO: the sequence of First In First Out is referred.
LIFO: the sequence of Last In First Out is referred.
Most Recently: the last purchased cost is referred.
Main Supplier: the supplier will be auto captured in purchase request when you choose the item.
Stock Control: means stock control/physical item; if unchecked will mean for service item (not to appear in Stock Card reports).
Controlled By Batch No: to control the item by batch no
Controlled By Serial No: to control the item by serial no
Calculate Bonus Point: to calculate bonus point
Details: to show the base UOM, sales UOM, purchase UOM, report UOM
Item Batch: to show the batch number of the item
Replacement Item: to find an alternative item for replacement when the stock is in back order/negative
Image: to show the image of the stock
Further Description: to key in any additional info of the item for your reference.
Details - UOM Details
Real Cost: system generated cost, updated through Purchase Invoice, Cash Purchase and Stock Update Cost. (set the Update Item Cost Option at Tools > Options > Invoicing > Document Control.)
Standard Cost: a user-input reference cost; can be updated through Purchase Invoice, Cash Purchase and Stock Update Cost; this cost will be referred if no other costing value is available, or when costing method is Fixed Cost. (set the Update Item Cost Option at Tools > Options > Invoicing > Document Control.) The cost can be mark up or down by percentage as reference for the selling price.
Min. Purchase Price: -1.00 means no control; you may key in a price, and set the control at User Maintenance > Access Rights > System, Behavior.
Max. Purchase Price: -1.00 means no control; you may key in a price, and set the control at User Maintenance > Access Rights > System, Behavior
Standard Selling Price 1-6: Key in item price. Price 1 will be adopted in billing documents if no other pricing policy is in force. Alternatively, these prices (1-6) can set to follow the multi-pricing option set at Debtor Maintenance. The price can be mark up or down based on the percentage from the standard cost or user can direct key in the price manually.
Min. Selling Price: -1.00 means no control; you may key in a price, and set the control at User Maintenance > Access Rights > System, Behavior. (also refer to Tools > Options > Invoicing > Document Control, Use average Up To Date Cost to check for minimum Sale Price).
Max. Selling Price: -1.00 means no control; you may key in a price, and set the control at User Maintenance > Access Rights > System, Behavior. (you may also enable the colour indication for pricing at Tools > Options > Invoicing > Customize Invoicing)
Up To Date Cost: the latest cost value according to costing method; auto generate by the system. If the costing method is FIFO, up to date cost will be shown in costing sequence, including when it was Free (cost = 0.00).
Multi Pricing (6 Levels of Pricing)
You can maintain the pricing by each debtor. Each time when you do sales transactions, the system will capture the pricing options that you set at your debtor maintenance.
First of all, you must enable use Multi Pricing in your Sales Auto Price.
Go to Tools > Options > Invoicing > Auto Price > tick Use Multi Pricing