Navigation:  Master Data Management > Inventory >

Product Management

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

Main Menu > Master Data Management > Inventory > Product Management

Creating a Product:

Fields in the Product Master:

Fields in the Product Master are as follows:

Product

Product Name

Enter the Product name. This name will be shown in all screens, lists and reports.

Print Name

Enter the Name that will be printed in the Invoice. It may be short name if the stationery size is narrow.

UPC EAN

Enter the UPC/EAN Code printed on products. You can enter up to FIVE different UPC / EAN codes for the same product.

UPC EAN 1

Enter the UPC/EAN Code printed on products.

UPC EAN 2

Enter the UPC/EAN Code printed on products.

UPC EAN 3

Enter the UPC/EAN Code printed on products.

UPC EAN 4

Enter the UPC/EAN Code printed on products.

User Defined Code

Enter the User Defined Code. This code is defined by the user.

Item Type

Inventory-Raw = Select Inventory-Raw if you don’t want to enter sale details during the stock in entries like Opening Stock, Purchase Order, Purchase Challan (Receipt Note), Purchase Invoice, Stock Journal (Only Production entry).
Inventory-Finished = Select Inventory-Finished if you want to enter sale details during the stock in entries.
Service = This type of products will not be shown in the Stock Statement, but will work exactly same in other modules as other products.

Generate production from Sale

Set Yes if you want to generate auto production consumption entry for the sold items else set no. For raw materials you don’t need to set Yes, but for finished items it must be Yes.

Weigh Scale Export

Set Yes to export data to the Weigh Scale else set No.

Weighing Scale Conversion

Default is 1000.

Brand & Grouping

Brand

Select the Brand. To create a new Brand, press Ctrl + N to get Brand Entry screen. To modify existing Brand, press Alt + Enter.

Sub Group

Select the Sub Group. To create a new Group, press Ctrl + N to get Group Entry screen. To modify existing Sub Group, press Alt + Enter

On selection of Sub Group, the Group Name & Department is displayed.

Group

Displayed on selection of Sub Group.

Department

Displayed on selection of Sub Group.

Bin Location

Enter the Bin Location number (alphanumeric). You may leave blank.

Tax

Tax at Purchase

Select the Purchase Tax Account Name for the Item. This is carried to the Item at Purchase Entry, which the user may change, if required.

To create a new Tax Account, press Ctrl + N to get Tax Account entry screen.

Tax at Sale

Select the Sales Tax Account Name for the Item. This is carried to the Item at Sales Entry, which the user may change, if required.

To create a new Tax Account, press Ctrl + N to get Tax Account entry screen.

Unit Name

Select the Unit Name from the list. To create a new Unit, press Ctrl + N to get Unit Master entry screen.

Matrix Name

Select the Matrix Name from the list. To create a new Matrix, press Ctrl + N to get Matrix entry screen.

Related Faqs:

Generate Product Child

New : The option “New” will always generate a new product child even the other information remains the same. This helps you to clearly identify the each child.
Yes : To generate new codes for each different combination of data entered during stock-in entry viz, Size, Color, Design, Mfg Date, Exp Date, etc during Item Receipts.
Unique : To generate unique barcode for each quantity entered during the transaction. If quantity entered in decimal then it will create only one barcode for all products. Import will not be affected by this functionality.
No : If you do not want the new child's to be generates.

Print Bar Code

Set Yes to print bar Code of the Item to use as Item sticker after each Stock receipt entries, else set No (where Bar Code is not be used or Bar Code is company printed on the product packing).

Print Bar Code Ratio (Qty/X)

Enter number of barcode to be printed for 1qty entered in the transaction.

For more detail please visit:

How to print 10 barcodes for 35 purchased items in RanceLab® FusionRetail™ 6?

Other Information

Set Yes to allow enter Other information (reorder level, safety level, re-order quantity and minimum order quantity), else set No.

Reorder Info

Quantity on Hand

Set the Quantity in Hand to be shown in th report.

Reorder Level

Set the Reorder Level to be shown in the report.

Safety Level

Set the Safety Level to be shown in the report.

Reorder Quantity

Set the Reorder Quantity to be shown in the report.

Minimum Order Quantity

Set the Minimum Order Quantity to be shown in the report.

Other Info

Product Coupon File

Press Alt+L to select coupon file.

Print Name (Other)

Type a different name to be printed in the bill.

For more detail please visit:

How to print different product name in bill receipt for an item?

SP Comm%

Set Sales Person commission in %.

SP Comm Value

Set Sales Person's commission in value.

Calculate Net Weight

Set Yes / No.

For more detail please visit:

How to use Container Management System in FusionRetail6?

Subscription

Service Item

Press ALT+L to select the service / product that is to be offered at below rate throughout the subscription period.

 

For Instance:

If a member wants to buy a monthly subscription for badminton then you need to create a product for subscription named “Badminton Monthly Subscription” and a service item for daily sale named “Badminton”.

Here, you have to set the service item for daily sale e.g. “Badminton”.

The service item Badminton will be offered on daily sale rate basis to the casual Guests.

For the club members same will be offered on below rate throughout the subscription period.

And beyond the subscription period if the subscription amount is not deposited by the member then it will be offered on daily sale rate as other casual guests.

 

Sample Product Master:

 

Note:

As per above Product Master if:

A customer buys the product Badminton Half Yearly Subscription on dated 1st Jan 2013 then he will be entitled to have the service item Badminton totally free throughout the period from 1st Jan 2013 to 29th June 2013.
A customer buys the product Gym/Health & Spa Monthly Subscription on dated 1st Jan 2013 then he will be entitled to have the service item Gym/Health & Spa totally free throughout the period from 1st Jan 2013 to 30th Jan 2013.
A customer buys the product Rowing Quarterly Subscription on dated 1st Jan 2013 then he will be entitled to have the service item Rowing totally free throughout the period from 1st Jan 2013 to 31st Mar 2013.
A customer buys the product Badminton Yearly Subscription on dated 1st Jan 2013 then he will be entitled to have the service item Badminton totally free throughout the period from 1st Jan 2013 to 26th Dec 2013.

Rate

Set the rate of the product / service to be offered at a discounted rate to the members throughout the subscription period. Set ZERO if you are offering products / services in ZERO rate throughout the subscription period.

Periodicity

Set the period Monthly / Quarterly / Half Yearly / Yearly throughout which the Service Item selected above will be offered at above rate. System will count 30 days as a standard month.

POS : Ask Quantity

Set Yes to allow entry of Quantity during Sale entry, set No to auto fill Quantity as 1.

POS : Ask Rate

Set Yes to ask Sale Price in Sale Bill during entry. Set No to carry it from the master.

POS: Use FIFO

Set Yes to apply First-in-First-out method of inventory for Sales.

 

FIFO and Child Relation:

If you are using ‘Generate Product Child = No’ and ‘POS:Use FIFO = Yes’ in M I P for your raw materials, whatever you are consuming, against a production entry then the last purchase rate will be selected as consumption cost/rate during the transaction and in stock statement report the stock valuation will be shown as per the last purchase rate.
If you are using ‘Generate Product Child = Yes’ and ‘POS:Use FIFO = Yes’ in M I P for your raw materials, whatever you are consuming, against a production entry then the last purchase rate will be selected as consumption cost/rate during the transaction and in stock statement the stock valuation will be shown as per actual transaction rate as per product child.
If you are using ‘Generate Product Child = Yes’ and ‘POS:Use FIFO = No’ in M I P for your raw materials, whatever you are consuming, against a production entry then the exact amount will be selected as per item child rate for consumption cost/rate during transaction and same will be reflected in reports.

POS: Message

Enter Message specific to this product to be displayed at POS on scan or selection.

Related Faqs:

How to give/show notifications during product selection in Scan POS?

POS: Remarks

Item specific remarks to be printed on bill / invoice.

Discount & Pricing

Standard Sales Price

Enter the Standard Sales price which is carried in sales bill entry. During sale transactions this will be the first priority over purchase rate.

Standard Cost Price

Enter the Standard Purchase price which is carried in purchase bill entry.

Substitute

Select the names of substitute Items from the list if Items. This is mostly used in restaurants and medicine shops.

Allow Operator Discount

Set Yes to enter or change the Product Discount in sales bill. Set No to disallow.

Picture 1

Picture 2

You may set 2 pictures (image files of any popular format like jpg, gif, bmp etc) of the Product.  Press <enter> on the field to get mage selection box. Now select the image file from list.

Related Faqs:

Is it possible to attach images with Product Child?

I want to view Product’s image in register reports, is it possible?

Brand Master Entry

You get Brand Master Entry screen when you press Ctrl+N at Brand field in Product Master Entry screen.

Brand

Enter the Brand (e.g Louis Phillipe).

Principal Co

Select the Company Name who owns / uses the Brand (e.g Madura Coats) from the list (you may select NONE also).

To enter a new company name, press Ctrl+N and enter the name of the company.

Commission (%)

Enter the rate of Commission offered by the Brand. This rate is used to calculate the brand commission at Sales Entry.

Area Allotted

Enter the floor space (in sq ft)  allotted to each brand (used in Planogram management).

Product Sub Group Master Entry

You get Item Sub Group Master entry screen by pressing Ctrl+N at Sub Group field in Product Master Entry.

Sub Group

Enter the Sub Group Name (e.g. Mens Shirt Formal Full Sleeves).

Group Name

Select the parent Group Name (e.g. Mens Shirt) from the list (you may select NONE also).

To enter a new Group name, press Ctrl + N and enter the name of the Group.

Matrix Name

Enter the rate of Commission offered by the Brand. This Matrix is auto carried during Product Master entry, which you may change.

Tax at Purchase

Select the applicable Tax at Purchase. To create a new Tax, press Ctrl+N to get Tax entry screen.

Tax at Sale

Select the applicable Tax at Sales. To create a new Tax, press Ctrl+N to get Tax entry screen.

Commission

Enter the rate of Commission offered on the Sub Group. This rate is used to calculate commission at Sales entry.

Area Allotted

Enter the Floor Area (in sq ft ) allotted to each sub-group (used in Planogram management.

Product Group Master Entry

You get Item Product Group Master entry screen when you press Ctrl+N at Group Name field in Sub Group Master Entry screen.

Group

Enter the Group Name (e.g. Men's Shirt).

Department

Select the Department Name from the list (you may select NONE also).

To enter a new Department name, press Ctrl+N.

Area Allotted

Enter the Floor Area (in sq ft) allotted to each group. Used in Planogram management.

Department Master Entry

You get Department Master entry screen when you press Ctrl+N at Department field in Group Master Entry sub screen of Product Master Entry.

Department

Enter the Department Name (e.g. Men's).

Area Allotted

Enter the Floor Area (in sq ft ) allotted to each department (Used in Planogram management).

Unit Master Entry

You get Unit Master Entry screen when you press Ctrl+N at Unit Name field in Product Master Entry screen.

Unit Name

Enter the Unit Short Name to display & print in reports (e.g Kg).

Unit Formal Name

Enter the full Unit Name (e.g Kilogram). This is for reference and is not displayed or printed in any report.

Product Matrix Master

You get Matrix Master Entry screen when you press Ctrl+N at Matrix Name field in Sub Group or Product Master Entry screen.

 

The first 3 columns are specified for user defined attributes for which the user may create a list of such attributes to select from.

Matrix Name

Enter the name of the Matrix.

Field 1

Enter the name of the 1st  column of the matrix.

Select  List

Select List Name from the list of List Names for the 1st column of the matrix. Press Ctrl+N to create a new list name (E.g. Size).

Field 2

Enter the name of the 2nd  column of the matrix.

Select List

Select List Name from the list of List Names for the 2nd column. Press Ctrl+N to create a new list name (e.g. Color).

Field 3

Enter the name of the 3rd   column of the matrix.

Select List

Select List Name from the list of List Names for the 3rd column. Press Ctrl+N to create a new list name (e.g. Warranty).

Field 4

Enter the name of the 4th    column of the matrix.

Input Method

Select the mask of the input data type from the list. Available options are : Date, Number (Integer), Number with 1 decimal, Number with 2 decimals, Number with 3 decimals, String (Text).

Field 5

Enter the name of the 5th  column of the matrix.

Input Method

Select the mask of the input data type from the list. Available options are : Date, Number (Integer), Number with 1 decimal, Number with 2 decimals, Number with 3 decimals, String (Text).

Field 6

Enter the name of the 6th   column of the matrix.

Input Method

Select the mask of the input data type from the list. Available options are : Date, Number (Integer), Number with 1 decimal, Number with 2 decimals, Number with 3 decimals, String (Text).

Reorder Information

You get the following screen when you set Yes at Re-Order Quantity field during Product Master entry.

Reorder Information

For

The Product name is displayed.

Quantity on Hand

The stock in hand (Current stock quantity) of this item. is displayed.

Reorder Level

Enter the stock level at which Fresh Order should be placed for replenishment of stock.

Safety Level

Minimum stock level to be maintained. Immediate purchase should be made if stock goes below this level.

Reorder Quantity

Quantity to be ordered when the stock level reaches Re Order level.

Minimum Order Quantity

Minimum Order Quantity to be ordered when the smallest order quantity that can be placed in a Purchase Order.

Product Master Entry Buttons

Buttons in the Product Management are as follows:

-M Matrix Rel

Press ALT+M or click this button to set Matrix Relation of the Product.

Related Faqs:

I want to make the purchase entry according to predefined sizes for the garment items.

Product Master Display

You get this by using "-D Display Button" on the product master screen.

You can use the bulk update feature to correct the mistakes made during the data entry. For example if you forgot to enter the brand name in the above example and you have created many products, the bulk update function will help to rectify the mistake in one go.