ITEM MASTER

Top  Previous  Next

To open the screen ITEM MASTER, click Maintain èè Inventory Control èè "Item master" from the menu bar.

item master

 

Logic of Screen :  By default the Screen is on Edit mode.

menubar

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
Purchase Inactive
Non-Active

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.

 

item vendor

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.
ØScreen has two modes
vEdit Mode-:In this mode user can type key value to retrieve the record.
vNew 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.

item master list

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.