> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/admin/item/custom-price-formula-profile/creating-custom-price-formulas.md).

# Creating Custom Price Formulas

Creating a custom price formula includes entering the name and currency of the formula, then defining the formula price details, such as price level, markup or markdown percentage, price level, and decimal rounding. By doing so, you can meticulously define the formula for each custom price.

{% hint style="info" %}
To create a custom price formula, go to **Menu > Admin > Item > Custom Price Formula Profile**
{% endhint %}

### Entering Custom Price Formulas

To create the custom price formula, you will begin by entering basic details of the formula, such as the name and currency for the formula that will act as an identifier. 

<figure><img src="/files/aFYDh6903kSa1ALwU6HC" alt=""><figcaption></figcaption></figure>

You can enable the “***Use the same formula for all Currency Prices***” toggle option located at the top-right corner of the page to enable the use of same formula for all currencies. If it is set to false, then multiple formulas can be defined for different currencies.

<figure><img src="/files/ZMN2Q8up4KSyj9GEW3VN" alt=""><figcaption></figcaption></figure>

### Defining Custom Price Formula Details

Once the basic information is set, the next step is to define the formula. This includes defining the pricing level, base price level, markup or markdown percentage, and decimal rounding.&#x20;

#### &#x20;Custom Price Formula Details Fields

<table><thead><tr><th width="188">Field</th><th>Description</th></tr></thead><tbody><tr><td>Price Level</td><td>This field specifies the type of price being calculated. This could be Standard Unit Price, Wholesale Price, Retail Price, or any custom price.</td></tr><tr><td>Markup%</td><td>This field indicates the percentage markup or markdown to be applied to the Standard Cost of an item. Use (-) sign for markdown percentages. For example, 10 for markup by 10% and -10 for markdown by 10%.</td></tr><tr><td>Of Price Level</td><td>This field specifies the base price level from which the custom price is calculated.</td></tr><tr><td>Decimal Rounding</td><td>This field determines the rounding rule applied to the calculated price, ensuring the final price adheres to a specific decimal precision. The rounding options include no rounding, 0.00, 0.50, 0.95, 0.99, upto 2 decimal places, and upto 4 decimal places.</td></tr></tbody></table>

After defining the formula, click "Save" to create the custom price formula.

<figure><img src="/files/neaD1PwfsOv9sj7oVqkL" alt=""><figcaption></figcaption></figure>

### Custom Price Calculation

The custom price is calculated based on the following formula:

**Price Level = Of Price Level/100 \* (100+markup%) + Decimal Rounding**

Let’s see an example of how the calculation will work. Let's suppose we have the following parameters:

* **Price level**=Standard Unit Price
* **Markup %**= 10, (Use minus(-) sign for markdown percentages)
* **Of Price level**=Standard Cost ( $50)
* **Decimal Rounding**= 0.50

As the selected price level is “Standard Unit Price”, this is a formula for creating the unit price of an item. Based on the formula Standard Unit price will be calculated from Standard Unit Cost with 10% Markup and after calculations, 0.50 Decimal Rounding will be added to the Calculated Standard Unit Price.

**Standard Unit Price**= **{50/100+(100+10)*****}+0.5 = 55.5***

### **Adding the Custom Price Formula** <a href="#adding-the-custom-price-formula" id="adding-the-custom-price-formula"></a>

After the custom price formula is saved, you can add the directly to the item. To do that, follow the steps below:

* Navigate to the Item Centre and open the item in which you want to assign the custom price formula.
* Go to Item > Advance Pricing > Formula.
* In the Custom Price Formula screen, select the formula from the “Custom Price Formula Price” dropdown and click on “Apply Changes” to add it to the Item.

### Custom Price Formulas

#### **Precision Pricing with “No Rounding” Option**

When you select the “No Rounding” option in the Decimal Rounding dropdown, the resulting custom price is not rounded off and can capture up to six decimal places.

<figure><img src="/files/w4jQT8L8XL29T9VuVHxT" alt=""><figcaption></figcaption></figure>

For example, let’s say the Standard Cost of an Item is $12.69. If you create a custom price formula for 10% markup in the standard cost with no rounding, the calculated standard unit price will be 13.958888.

#### **“Re-calculate” option to keep the prices updated**

If there is a change in the base price level, you can use the “Re-calculate” option to update the Custom Prices based on the formula. This ensures that your prices are always current and accurate.

<figure><img src="/files/2NP1uyOxRxKqYgptZeID" alt=""><figcaption></figcaption></figure>

#### **Batch update the Custom Price Formula**

We have also provided the ability to batch update the custom price formula. You can do this either from the Item Centre or via an upload.

**Item Centre**

* Go to Item Centre and select the Items. Then, go to Options > Batch Update.

  <figure><img src="/files/ekyOAioK14hw9y3H4qqc" alt=""><figcaption></figcaption></figure>
* Select “Custom Price Formula Profile” under the Column Name.
* From the Value dropdown, choose the custom price formula you want to add to the items.

  <div align="left"><figure><img src="/files/JKZRPaHwfHF8Pb7XBylq" alt=""><figcaption></figcaption></figure></div>
* Click on “Update” to apply the changes.

  <div align="left"><figure><img src="/files/MNXs57lJkAAy7NGfACSY" alt=""><figcaption></figcaption></figure></div>

&#x20;**Product Upload**

You can utilize the “CustomPriceFormulaProfile” column in the Product upload file. In this column, you can include the custom price formula profile created in the system. Upload the file to batch update the custom price formula for multiple items simultaneously.

<figure><img src="/files/5BYFfmNTgcYIRj8tzDTR" alt=""><figcaption></figcaption></figure>


---

# 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://docs.xorosoft.com/xoroerp-1/admin/item/custom-price-formula-profile/creating-custom-price-formulas.md?ask=<question>&goal=<endgoal>
```

`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.