|
To open the screen ITEM MASTER, click Maintain èè Inventory Control èè "Item master" from the menu bar.
Logic of Screen : By default the Screen is on Edit mode.
To Add ITEM MASTER Detail
Click on the Icon or Press Ctrl+ N to enter in New mode. The Labels marked in Red are mandatory. Fill in the necessary Information and click on save icon or Ctrl + S to save the information.
To Modify ITEM MASTER Detail
Click on the Icon or Press Ctrl+ O to enter in Edit mode. The Labels marked in Red are mandatory. Modify the necessary Information and click on save icon or Ctrl + S to save the information.
To Delete ITEM MASTER Detail
Click on the Icon or Press Ctrl+ D to Delete the Information.
Note:
1 System will delete the data only if there are no transactions associated with these data.
2. Link is provided on the entire Dropdown List box with which you can Add or Modify the existing records
The item master is used to store the details of all the items that Your Company deals with. All other documents that refer to items are dependent on the items being entered here.
The various fields in the screen are described below :
Item ID.
|
The item code is a field and is made up of a combination of Department code, Section code and an auto- generated serial number.
|
Ref No.
|
The number given by the manufacturer to the item. If the manufacturer does not have a no. for the item, then APPLICATIONwill give a no. for it.
|
Description
|
The description of the item. Built up from the short descriptions of brand, line, subsection and class.
|
Short description
|
Short description of item
|
Measure
|
It is to measure the unit of an item
|
Unit
|
It gives the terms in which items are measured
|
Allow Batch
|
If marked item can contain item size or item lot(manufacturing and expiry date)
|
Category
|
If allow batch is marked then u can select category for item
|
Sales Vat A/C
|
To enter the sales vat no.
|
Source
|
To enter the source of unit price
|
Purchase Vat A/C
|
To enter the purchase vat a/c
|
No.of Pieces
|
Number of pieces
|
Complete/Loose
|
To specify whether item is composite or divided into subparts.
|
Location
|
The location under the Department to which the item belongs. Section Name is also displayed.
|
Stock card
|
To enter the position of stock from t
|
Max.Level
|
To enter the maximum level of item ordered from the stock
|
Min.Level
|
To enter the minimum level of stock required & position of stock at the time of order
|
Order Level
|
To enter & maintain the particular order level that is predefined
|
Order qty
|
To enter the quantity of goods required & ordered for the same
|
Sale Price
|
Retail price of the item. Change is possible only through a Price change note.
|
Manufacturer
|
To enter the name of the manufacturer or the point of production of the product or item ordered for purchase
|
Vendor Stk No.
|
To enter the details of vendor stock number
|
Alternatelno.
|
To enter other alternate number of the vendor
|
Returnable
|
To enter the condition wither the goods are returnable or not
|
Status
|
The status of the item. This can be one of the following :
Active items are those which are dealt with by APPLICATION.
Purchase Inactive items are being phased out by APPLICATION and will not be purchased.
Non-Active items are those which APPLICATION has stopped dealing with. An item can be made non-active only if stock in all locations is 0.
|
Item Category
|
The different categories are Stock, Consignment, Direct Cost, and Collateral & Samples. Change of category is possible only if stock is 0 in all locations.
|
Item Group
|
To enter the main group of the item that it belongs to.
|
Item SubGroup
|
Subgroup of item
|
Average Cost
|
Displays the average cost
|
Stock On Hand
|
Displays The Stock on Hand
|
The Item Vendor button :
When clicked, this will pop up the screen shown below. The creditors who supply the item to Your Company are listed here. One creditor is marked as default. Your Company normally purchases this item from the default creditor. The user can insert a new creditor to the existing list by clicking the New button. The user can now browse and choose a creditor by clicking the search button in the first column of the grid. The default field and the special discount field are editable. An existing row can be deleted using the Delete button. No validations are done against this. This popup screen can be closed using the Exit button.
The columns in the grid in this popup screen are the following
Sr#
|
Autogenerated serial no
|
Vendorid
|
The unique identifier for the creditor. When this column gets the focus, a search button is available to search the Creditor master for creditors.
|
Vendor Itemcode
|
The name corresponding to the selected creditor no.
|
UOM
|
Unit of measurement
|
Currency ID
|
The currency as in the Creditor master.
|
Cost Price
|
Cost Price for the item supplied by the creditor in the creditor currency.
|
Disc per
|
The standard discount percentage offered by the creditor in the discount matrix.
|
Default
|
If this checkbox is checked it means that this creditor is the preferred creditor for this item.
|
The Bar Code Details button :
When clicked, this will pop up the screen shown below. This screen is meant for entering and displaying the bar code details of the item. The local bar code is always generated when the item is created and cannot be changed. The international bar code is entered here. The user can enter new International Bar Codes for the item by clicking the New button. An item may have more than one international bar code. This code entered is checked to see whether it follows the standard EAN-13 / UPC-E and is saved if it conforms to it. In the edit mode of the item (this is the default mode), existing international bar codes may be modified. No validations are there for deleting the international bar codes of an item. An existing row can be deleted using the Delete button. This popup screen can be closed using the Exit button.
If the user enters less than 13 digits, zeros are padded to the start of the code until total no of digits are 13.
Functionality:
Ø The Tab key can be used to navigate from the current column to the next in order.
| Ø | The Underline hyperlinked labels are used to Add/Modify/Delete respective masters. |
| Ø | The Exit button can be used to exit from current screen /form. |
| v | Edit Mode-:In this mode user can type key value to retrieve the record. |
| v | New Mode-:In this mode user can make new entry. |
List View for Item Master
To open the screen LISTVIEW OF ITEM MASTER, click the List View èè Inventory Control èè Item Master from the menu bar.
List View will enable you to view all the data of Item Master with which you can Search, Filter and export the data in XML, EXCEL, WORD, PDF, HTML, ETC. You can also Edit details of Item Master by ‘Double Clicking’ on desired data.
|