Master Data Management > Inventory

Main Menu > Master Data Management > Inventory > Product Management

Creating a Product

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 Code

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

Select Inventory as Raw if you don’t want to enter sale details else set Inventory as Finished.

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.

For more details please visit;

Separation of Fresh Goods from Finished Goods

Generate Product Child

1.	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.

2.	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.

3.	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?

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

For more detail please visit;

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

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.

For more detail please visit;

Is it possible to attach images with Product Child?

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

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)

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

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. Mens 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

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. Mens)
Area Allotted	Enter the Floor Area (in sq ft ) allotted to each department (Used in Planogram management)

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

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)

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 Oder level.
Minimum Order Quantity	Minimum Order Quantity to be ordered when the smallest order quantity that can be placed in a Purchase Order.

-M Matrix Rel

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

For more detail please visit;

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

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.