How to Create Lock MRP Master According to DPCO's New Issued Restricted MRP

Step:1 Create Lock MRP Master Manually

1. Start with login in Unisolve or Cross dashboard to initiate the process.
   
2. Go to the System> Master Data> Product Information> Lock Sales Entry.
   

Unisolve Dashboard Image

1. After that, a Lock Sales Entry image will appear in the next slide.
   
2. Click on the Add option to create a new lock MRP master.
   

Lock Sales Entry Window

1. Now, in the Invoice Lock window, fill the followings details.
2. Suppose you want to lock billing of a particular Customer, Category, Generic name, Master Group/ Group, etc. Then select them in the respective column.
   
3. If you want to lock MRP on a particular product. Then select the Product from the drop-drop list.
4. Enter the Greater than (>) MRP amount in the column. (For example, you entered 120 rupees in the column)
   
5. Press OK to save the window.
   

Invoice Lock Window

1. Create an Excel file that includes product information.
   
2. As you can see in the below-given reference image the products' Code, Product Name, Packing, Group Name, and MRP details are visible in the excel file.
   
3. Products' Code, Name, and MRP column is Mandatory to enter in excel file.
   
4. Enter the Greater than (>) MRP amount in the MRP column.

Excel File Image

1. Go to the System> Import/ Export> Import Lock Entry By MRP option.
   
2. After that, a new window for selecting the details will appear on the next slide.

Import Export Option Window

1. Select the File Path from your system where your excel file is saved.
   
2. Here you will see two options to select the File Type i.e. CSV and XLS file.
   
3. Tick-Mark on the Map File and First Row Contains Heading options.
   
4. Now, select the following options to map the products.

1. In Product Code column select Prod. Code.
   
2. In Product Name column select Product Name.
   
3. In MRP column select MRP.

1. Press OK to save the window.
   

Import File Path Image

1. A notification window will appears which shows Updating Records message.
   
2. After that, If Product Codes are the same in an excel file and software, then all the products are automatically added to the software.
   
3. Otherwise, we have to Map the products in the software.
   
4. As you can see in the below-given reference image:
   
5. Press OK to continue.
   

Product Added Window

1. Go to the System Menu> Import/ Export> Delete Bulk Lock Entries.
   
2. After that, a new window of Delete Lock Details will appear in the next slide.
   
3. Click on the View option. After that, all imported lock entries show on the screen.
4. Select the product which you want to Delete.
   
5. Click on the Delete option.

Delete Lock Entries Window

Note: Import & Delete bulk entries option is only available in Unisolve software.

Step:4 How to View Lock MRP Detail in Sale Bill

1. Go to the Sales Menu> Sales Invoice.
   
2. Enter the Customer details and Other details.
   
3. Select the same Product whose master you created in the Lock Detail section.
   
4. Enter Batch No in the column.
5. After that, as you can see in the below-given reference image your product's MRP is greater than entered amount in lock master. An Error Notification appear on the screen.
   

Sales Invoice Window

Step:5 How to Return Locked Products

1. Go to the Adjustment Menu> Purchase Return option.
   
2. Select the Vendor Details for creating a purchase return entry.
   
3. Now, here you will see a new option of Get Locked Data.
   
4. If you want to return locked data to the vendor, select the Yes option in the column. Otherwise, you can select No option.
   
5. After selecting Yes option in Get Locked data column. You can generate the purchase return entry.
   

Purchase Return Window

1. If you require support, please read: How to get online support (Guide & Video)

1. To avail this facility, download our Latest Patch of Unisolve/Cross Software. Kindly read: How to Download Last Patch (Guide) to download the last patch.