Update Prices and Rates in Estimate (tpest2203m000)

Use this session to update the standard cost/ cost rate and sales price/sales rate of estimate lines of a selected project and estimate version.

Note:

To update the prices and rates:

The status of the selected project must be either Free or Active.
The status of the version must be Free.

All the prices are updated in the estimate line cost currency only. If the currency of cost object is not the same as that of the currency of the estimate lines, currency conversion is done.

For each cost type selected, all the estimate lines that have the status Free and for which the Final Price (cost/sales) is 'No', are selected.

The standard cost can be retrieved from the cost object depending on the price policy. If the price policy is set to Standard Cost, the standard cost is retrieved. If the price policy is set to Purchase Price the standard cost is updated with purchase price.

For the cost type, Labor and the Sundry, only standard cost updation is possible.

The user can retain the results for the previously created estimates by first copying the estimate version then updating the prices and rates or by using the Simulate option. For example, at the beginning of the year, an estimate is created, however, the project is postponed. If the project is activated after six months, and if the estimate is valid, the user can first copy the old estimate version (created six months earlier) to a new version then update the prices and rates to the current version or can use the Simulate option to evaluate the results before updating the version.

Using the Update or Simulate option, you can generate a report that displays the totals and differences of the costs and sales amounts, before and after the price updates.

Field Information

Project

The code that identifies the project for which the estimate line price details are to be updated.

Version

The code that identifies the estimate version for which the estimate line price details are to be updated.

Selection of Cost Types

Material Lines

If this check box is selected, LN includes the lines of the cost type material cost, if applicable for the estimate lines.

Labor Lines

If this check box is selected, LN selects the estimate lines of the cost type labor.

Equipment Lines

If this check box is selected, LN selects the estimate lines of the cost type equipment.

Subcontracting Lines

If this check box is selected, LN selects the estimate lines of the cost type subcontracting.

Sundry Costs Lines

If this check box is selected, LN selects the estimate lines of the cost type Sundry.

Empty Cost Type Lines

If this check box is selected, LN selects all the estimate lines which do not have cost objects linked to them.

You cannot update the cost/sales price for estimate lines without cost objects. The prices are updated by:

Percentage
Amount
Markup percentage

Standard Costs/Rates

If this check box is selected, all the cost objects which have the price policy set to Standard Cost are selected. The standard cost is updated with the standard cost of the cost object.

Purchase Prices/Rates

If this check box is selected, all the cost objects with the price policy set to Purchase Price are selected. The standard cost is updated with the purchase price of the cost object.

Update with Percentage

If this check box is selected, the standard cost of the selected estimate lines gets updated by the percentage that is specified.

Update with Percentage

The percentage with which you want to update the standard cost of the estimate lines.

Update with Amount

If this check box is selected, the standard cost of the selected estimate lines gets updated with the amount that is specified.

Update with Amount

The amount with which you want to update the standard cost of the estimate lines having the specified currency.

Only for Currency

The currency selected for updation. The amount or percentage of all the lines with this currency only are updated.

Only for Currency

The description of the currency.

Sales Price

If this check box is selected, LN selects all the estimate lines with Pricing Method set to Target Pricing. The estimate line sales price is updated with the sales price of the cost object.

Update with Percentage

If this check box is selected, the sales price of the selected estimate lines gets updated by the percentage that is specified.

Note: LN selects only the estimate lines with Pricing Method set to Target Pricing.

Update with Percentage

The percentage with which you want to update the sales price of the estimate lines.

Update with Amount

If this check box is selected, the sales price of the selected estimate lines gets updated with the amount that is specified.

Note: LN selects only the estimate lines with Pricing Method set to Target Pricing.

Update with Amount

The amount with which you want to update the sales price of the estimate lines having the specified currency .

Only for Currency

The currency selected for updation. The amount or percentage of all the lines with this currency only are updated.

Only for Currency

The description of the currency.

Update Markup Percentage

If this check box is selected, the markup percentage defined in the Estimate Lines (tpest2100m000) session, gets updated by the percentage that is specified.

Note: LN selects only the estimate lines with Pricing Method set to Markup.

Update Markup Percentage

The percentage with which you want to update the markup percentage defined in the Estimate Lines (tpest2100m000) session.

Update Mode

Indicates the update mode.

Allowed values

Update: Infor LN updates the data.
Simulate: Infor LN runs the process in the simulation mode. The results are not saved in the database. This process enables you to preview the results.

Note: You can generate a report that displays the totals and differences of the costs and sales amounts, before and after the price updates.