> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/setup-items/setup-items-multiple-pack-sizes/configuration-multiple-packs-sizes/configuration-options-1/mrp-formula.md). # MRP Formula **YouTube**: [How to Auto Calculate MRP via Formula in Item Creation?](https://www.youtube.com/watch?v=FZDMblrMXfI\&t=4s) ## How to Auto Calculate MRP via Formula in Item Creation?  In this tutorial, we will guide you through the process of **automatically generating MRP** while creating an item using a dynamic formula in **Logic ERP**. This feature eliminates manual calculations, ensuring **accuracy and efficiency** in pricing. ### **Accessing the Configuration Settings** * Navigate to the Setups/Setup Items and then click on "Setup Items Multiple Packs/Sizes". * Click on the Configuration. * Locate the option "MRP Formula" under the Configuration option-2 tab

As shown in the picture, click on "MRP Formula"

### **Creating a Custom MRP Formula** * Use the available fields to construct your **MRP formula** based on your business requirements. * In this example, we have defined a formula where: * **MRP = Sale Rate + 35% (Markup)** * The **ROUND function** is used to round the MRP to the nearest whole number, ensuring consistency. * The zero in the function ensures that **no decimal places** are included in the final MRP value. * Click **Save** to apply the formula.

Create the script exactly as explained and shown in the picture.

### **Testing the MRP Formula** * Create a new item and **enter the sale rate**. * The **MRP field does not require manual entry**; it will be automatically generated based on the predefined formula. * Save the item and re-open to verify the **auto-calculated MRP**.

This image illustrates that the MRP has been successfully generated using the MRP formula.

### **Key Benefits of Using an MRP Formula** * **Eliminates Manual Calculations** – Reduces errors and saves time. * **Ensures Pricing Accuracy** – MRP is consistently calculated across all items. * **Improves Efficiency** – Simplifies item creation and reduces manual intervention. * **Enhances Financial Records** – Helps maintain accurate pricing data for inventory and reporting. By leveraging the **MRP formula feature** in Logic ERP, businesses can optimize their pricing strategy, reduce manual effort, and enhance overall inventory management. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/setup-items/setup-items-multiple-pack-sizes/configuration-multiple-packs-sizes/configuration-options-1/mrp-formula.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.