Calculate M.R.P. from Basic Rate + Group

YouTube: How to Calculate Item MRP Using Basic Rate + Item Group Margins?

How to Calculate Item MRP Using Basic Rate + Item Group Margins?

This tutorial demonstrates how to automatically calculate MRP based on the basic rate plus margin group while creating an item. With this feature, you can streamline your pricing process, ensure consistency, and reduce manual errors.

Enable MRP Calculation Formula

• Navigate to: Setup and then expand Setup Items.

• Select "Setup Items Multiple Packs/Sizes".

• Click on “Configuration” to open the feature window.

• Locate the option labeled as:

“Calculate M.R.P. from Basic Rate + Group”.

• Activate this option.

• Select the group level (e.g., Category, Sub-Category, Brand) on which you want to apply the margin percentage.

• Optionally, enable Round Off MRP if required.

Define Margin Percentage

• Navigate to Setup/Setup Items and click to Setup Item Groups.

• Select the group you defined earlier (e.g., Category Group).

• Locate the Margin Percentage for MRP field.

• Enter the desired margin (e.g., 25% for Shirts Category).

• Save the changes.

Create an Item

• Return to the Setup Item window.

• Create a new item under the Shirt category.

• Enter the Basic Rate.

• The system will automatically calculate the MRP by adding the defined margin (e.g., Basic Rate + 25%).

Example: If Basic Rate = ₹1000 and Margin = 25%, the MRP is auto calculated as ₹1250.

Benefits

• Automation – Eliminates manual MRP calculation.

• Accuracy – Ensures correct and consistent pricing.

• Efficiency – Simplifies item creation process.

• Flexibility – Margin can be set at group level (Category, Brand, etc.).

With this feature, you can maintain a standardized pricing strategy across categories and save valuable time in data entry.