Import Prices from Item Data to Price Book (tdpcg0231m200)

Use this session to import prices from one of the following sessions into a price book:

  • Items - Sales (tdisa0501m000)
  • Items - Purchase (tdipu0101m000)
  • Item - Costing (ticpr0107m000)
  • Items - Service (tsmdm2100m000)

 

Price Book

The price book to which the prices must be copied.

From Item

The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold.

An item can also represent a set of items handled as one kit, or which exist in multiple product variants.

You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
To Item

The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold.

An item can also represent a set of items handled as one kit, or which exist in multiple product variants.

You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
Source Price

The type of price that must be imported.

  • If this field is set to Sales Price, or Suggested Retail Price, prices are imported from the Items - Sales (tdisa0501m000) session.
  • If this field is set to Purchase Price, Operation Subcontracting Purchase Price, Item Subcontracting Purchase Price, or Service Subcontracting Purchase Price, prices are imported from the Items - Purchase (tdipu0101m000) session.
  • If this field is set to Cost Price, prices are imported from the Item - Costing (ticpr0107m000) session.
  • If this field is set to Service Price, prices are imported from the Items - Service (tsmdm2100m000) session.
Price Factor

The factor by which the prices that are imported must be multiplied. A price factor is used to increase or decrease the price book's base price to calculate the unit price. The value entered for the price factor must be positive.

For example, a price factor for a 10% increase is 1.10 and a 15% decrease has a price factor of 0.85.

Effective Date

The date on which the prices that must be imported are valid.

Expiry Date

The date until which the prices that must be imported are valid.

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
Type

This field display whether the price book is a sales price book or a purchase price book.

Used for Contracts

If this check box is selected, the price book is allocated to a sales contract or a purchase contract and is usually linked to a contract price revision.

Used for RFQs

If this check box is selected, the price book is allocated to a request-for-quotation (RFQ).

These price books are used only to store prices, not to retrieve prices.