Skip to main content

Calculated Pricing for Products

How to set Calculated Pricing for a product

A
Written by Ashok P

You can set "Calculated Pricing" for products or fixed prices. Such products, referred to as "Calculated Products," can be used for shipping, per diems, or anything else you want to account for that is not a "piece of equipment."

  • Existing products in your catalog cannot be converted to use calculated pricing. Only new products can be set to use calculated pricing when they are being added.

  • Calculated products do not calculate from other items; i.e., the price of a calculated item (product, labor, or allowance) cannot be used to calculate a calculated product.

To use calculated pricing on a product, when creating the new product, click the Calculated radio button on the Price tab.

There are various options for setting the unit cost and unit price for the calculated product.

Source

First, you choose a Source field. You can select a Total field from the dropdown.

Or set the source to be Unit Price, Margin, or Markup.

The Recalculate Automatically option is checked by default.

  • When checked, this will automatically update the product's unit cost or unit price within a project when the source value changes.

  • If you do not have this box checked, you can still manually recalculate the price for a calculated product within a project.

Operation

Next, you choose an operation from the following list.

Value

Once you've chosen an operation, you can then set a value. The value will be either a percentage or a decimal number, depending on the operation chosen.

Filters

You can set one or more of the filters shown in the image below.

  • The "Current Parent Item" is pre-selected, as this is likely the behavior you want for calculated products, primarily to maintain the expected pricing when a quantity greater than one is split into multiple quantities.

  • The location and system options let you choose whether to include sublocations and subsystems.

  • The Manufacturers filter lets you choose specific manufacturers to derive the values from.

You can click "Copy Filters From" under Unit Cost or Unit Price to copy the filters between them.

If you do not choose a filter when using a "Total" Source, the project total for that source will be used.

Tax

The tax fields will vary depending on the Tax settings in the Control Panel. You can assign an Avalara tax code if needed.

Did this answer your question?