Global Update of Prices via Price Books (tdpcg0231m000)

Use this session to update prices in price books, independent of information in the price matrices.

For example, in a price book for chairs the price for armchairs is increased with 3% independent of prices (and discounts) for the sold-to business partner and the ordered quantity.

Create a report to update the (ranges of) price book elements. If you only want to simulate an update report, select the Simulation Only check box.

 

Update Price

Use this field to update the price. You can update the price with a percentage or with a value.

  • Select the By Percentage check box if you want to update the price with a percentage. As a result, the Percentage to Change By field is available.
  • Select the By Value check box if you want to update the price with a value. As a result, the Value to Change By field is available.
Percentage to Change By

The percentage by which the price must be increased.

Note

The price can either be updated by a percentage or by a value.

Rounding Code

Set of up to six ranges of values and their rounding values. Rounding codes can be linked to quantities and amounts. They are used when you calculate, for example, purchase prices and discounts, sales prices and discounts, and warehousing rates.

Example

A rounding code can define the following ranges with their rounding values:

  • Up to 100: round to whole numbers
  • From 100 to 100,000: round to a multiple of 5
  • From 100,000 onward: round to a multiple of 100.
Value to Change By

The value by which the price must be increased.

Note

The price can either be updated by a percentage or by a value.

Currency

A generally accepted medium of exchange such as coins, treasury notes, and banknotes.

The following currency types are available in LN:

  • Home currency, which is used internally by companies to calculate costs, record budgets, and register tax amounts
  • Transaction currency, which is used in transactions with business partners, such as orders and invoices
Note

If you select a specific currency in the currency range, enter that currency in this field. Otherwise, the home currency is used in this field.

New Effective Date

The date and time as from which the updated prices are valid.

New Expiry Date

The date and time by which the updated prices expire.

Simulation Only

If this check box is selected, a report simulating the update of prices is displayed. The data update is only displayed, not processed.

Print Changes

If this check box is selected, a report can be displayed or printed.