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

How to Create Lock MRP Master According to DPCO's New Issued Restricted MRP in Unisolve & Cross

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


The DPCO (Drug Price Control Order) declared a new ceiling price for essential and life saving medicines (as per a prescribed formula).  According to the government's new guidelines, MRP is restricted on some drugs. In Unisolve & Cross Software, a new feature is available to lock the MRP of product. The pharmacist can't sell the products above the restricted MRP. To do this process in software, you must create a lock MRP master of the product. Also, users can return the locked products from collect locked data option in purchase return/ debit note form.

For example, you lock the MRP greater than(>) 120 rupees on product. Then you can't sell the same product at above Rs 120.

Note: Firstly, install the latest patch of Unisolve & Cross to implement the Lock MRP Process.

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.
Reference image:
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.
Reference image:
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.
Reference image:
Invoice Lock Window

Step:2 Import Bulk Lock Entry by MRP in Unisolve

If the user wants to import bulk entries in software without doing manual entries. Then you can do it from the import lock entry by MRP option. Also, you have to create an Excel file that includes product information. Import a CSV file option is also available in the software. Follow the easy steps below to know the process of importing an excel file.
  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.
Reference image:
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.
Reference image:
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.
Reference image:
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.
Note: You can see imported masters in Lock Sales Entry window.

Reference image:
Product Added Window

Step:3 Delete Bulk Lock Entries in Unisolve

In Unisolve Software, users can also delete the imported bulk lock entries.
  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.
Reference image:
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

After creating lock master, now if you create sales invoice for the same product. Then, while saving the window, if your product's MRP is greater than 120 as you entered in lock master, an error notification will appear on the screen. Or, if your product's MRP is less than 100, your sales invoice will be saved.
  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.
Reference image:
Sales Invoice Window

Step:5 How to Return Locked Products

Suppose the user wants to return all the products which are locked in Unisolve/Cross software. Then they can return them by creating purchase return/ debit note entries.
  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.
Reference Image:
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.
  1. For more details, please make a ticket on swildesk.com.

Thanks
SWIL Team



      • Related Articles

      • New features in Unisolve_Cross 16.2.10 (Seedhi Baat)

        We keep on introducing new features in new versions and release a document 'SeedhiBaat' to outline most of them. More patches come afterwards and these new features are mentioned in what's new option in help menu. Please see attached PDF file to know ...
      • How to Create Lock Shelf Master Under Sales Transaction in Unisolve Software

        How to Create Lock Shelf Master Under Sales Transaction in Unisolve Software Users can create lock shelf master in Unisolve software if they want to lock a particular shelf of products. For example, if users don't want to sell products of certain ...
      • How to Set Discount Master in Cross for Customers/Patients

        How to Set Discount Master in Cross Software for Customers/Patients In Cross software, a new feature has been added of discount master. This option allows users to set the sale discount(%) on a particular Category, Patient, Group or Product by ...
      • How to Create Purchase Return Bulk Entries in Unisolve/Cross

        How to Create Purchase Return Bulk Entries in Unisolve/Cross Unisolve/Cross software added a new feature for creating purchase return bulk entries. With this option, users can create purchase entries for multiple suppliers, which means users can ...
      • How to Implement AWACS-DDP in Unisolve

        How to Implement AWACS-DDP in Unisolve In this article, we explain the integration process of AWACS-DDP with Unisolve software. We can implement both Auto & Manual processes in Unisolve, which helps you to upload the data. Note: Firstly, install the ...