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?
Answer:
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
- Go to Main Menu > Master Data Management > Inventory > Product Management (M> I> P)
- Alt + L
- Select a Product from the list.
- Go to Matrix Name.
- Ctrl + N to create a new Matrix.
- In ‘Matrix Name’ type “Status”.
- In ‘Field1’ type “Product Type”.
- 8. Set ‘Field List =Size’
- Save.

Step2: Attaching the new matrix with products
- Go to Main Menu > Master Data Management > Inventory > Product Management (M> I> P)
- Go to ‘Product Name’.
- Alt + L
- Select the Product from the list.
- Set “Matrix Name =Status”
- Save.
- Repeat Step 1 to 7 as per your need.
Step3: Creating list for “Status” Matrix
- Go to Main Menu>Master Data Management>Inventory>Matrix List (M> I> M)
- Type “Fresh” in ‘Name’ field
- Go to ‘List Name’ field
- Alt + L
- Select ‘Size’ from the list
- Save
- Repeat step 2 to 6 to create a list item as “Finished”.

Step4: Purchasing products as ‘Fresh’
- Go to Main Menu > Purchase Management > Transaction > Purchase Invoice (P> T> P)
- Select Supplier from the list
- Select product from the list
- Enter other details as ‘Reqd. Qty’, ‘Purchase Rate’, ‘MRP’ etc.
- Go to “Product Type” column
- Alt + L
- Select “Fresh” from the list.
- Enter
- Provide other details
- Save and print barcode (if required)

Step5: Converting the Fresh product into Finished
- Go to Main Menu > Warehouse Management > Transaction > Rate Change (W> T> E)
- Select the product from list
- Change “Status” from “Fresh” to “Finished”
Use the following link to find more details

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


For more information please click on the links given below:
- http://www.rancelab.com/help/fr6_product_management.htm
- http://www.rancelab.com/help/fr6_purchase_invoice.htm
- http://www.rancelab.com/help/fr6_stock_statement.htm
- http://www.rancelab.com/help/fr6_rate_change.htm
- http://www.rancelab.com/help/fr6_stock_statement.htm
- http://www.rancelab.com/faq/solution_id_1387.html
- http://www.rancelab.com/help/fr6_using_filters__grouping.htm