ID #1471

Separation of Fresh Goods from Finished Goods

I have products that are freshly purchased and products that have been processed to make finished items. I want to maintain stock of both the kind of products. How to do it through RanceLab® FusionRetail™ 6?


You can maintain stock of both the above mentioned kind of products by the help of RanceLab® FusionRetail™ 6. Please follow the steps given below to accomplish the task. 

Step1: Creating a new Matrix

  1. Go to Main Menu > Master Data Management > Inventory > Product Management  (M> I> P)
  2. Alt + L
  3. Select a Product from the list.
  4. Go to Matrix Name.
  5. Ctrl + N to create a new Matrix.
  6. In ‘Matrix Name’ type “Status”.
  7. In ‘Field1’ type “Product Type”.
  8. 8.     Set ‘Field List =Size’
  9. Save.


Step2: Attaching the new matrix with products

  1. Go to Main Menu > Master Data Management > Inventory > Product Management  (M> I> P)
  2. Go to ‘Product Name’.
  3. Alt + L
  4. Select the Product from the list.
  5. Set “Matrix Name =Status”
  6. Save.
  7. Repeat Step 1 to 7 as per your need.


Step3: Creating list for “Status” Matrix

  1. Go to Main Menu>Master Data Management>Inventory>Matrix List (M> I> M)
  2. Type “Fresh” in ‘Name’ field
  3. Go to ‘List Name’ field
  4. Alt + L
  5. Select ‘Size’ from the list
  6. Save
  7. Repeat step 2 to 6 to create a list item as “Finished”.

 Step4: Purchasing products as ‘Fresh’

  1. Go to Main Menu > Purchase Management > Transaction > Purchase Invoice (P> T> P)
  2. Select Supplier from the list
  3. Select product from the list
  4. Enter other details as ‘Reqd. Qty’, ‘Purchase Rate’, ‘MRP’ etc.
  5. Go to “Product Type” column
  6. Alt + L
  7. Select “Fresh” from the list.
  8. Enter
  9. Provide other details
  10. Save and print barcode (if required)

Step5: Converting the Fresh product into Finished

  1. Go to Main Menu > Warehouse Management > Transaction > Rate Change (W> T> E)
  2. Select the product from list
  3. Change “Status” from “Fresh” to “Finished”

Use the following link to find more details

Step6: Viewing the report

  1. Go to Warehouse Management > Reports > Stock Statement (W>R>S)
  2. Ctrl+D.
  3. Alt+F3.
  4. Drag and Drop Field1 from the column chooser.
  5. Apply filter on Field1 to separate “Fresh” and “Finished” products.
  6. You can also save these layouts for future use.


For more information please click on the links given below:

Tags: Matrix List, Product Management, Purchase Invoice, Rate Change, Setup, Stock Statement

Related entries:

You cannot comment on this entry