Table of Contents

Map prices from vendor data

When you import product data from a vendor, you can also import their price information — such as list prices, customer prices, or sales prices — and store it in the Vendor Catalog. You can then use these prices during item activation to create Business Central purchase or sales price list entries.

Note

Price mapping is available for both XML import and Excel import.

How vendor prices are stored

Vendor prices are stored in the Vendor Price table. Each price record contains the following key fields:

Field Description
Type Classifies the price. See Price types below.
Price The price value.
Currency Code The currency of the price. Leave blank to use the local currency (LCY).
Minimum Quantity The minimum order quantity this price applies to.
Starting Date / Ending Date Optional validity period for the price.
Price Factor Used when one price unit represents multiple item units (e.g. price per 100 pcs).

Price types

The Type field determines the role of the price in purchasing and sales:

Type Used for
List price incl. VAT (Purchase) Gross purchase list price including VAT
List price excl. VAT (Purchase) Net purchase list price excluding VAT
Customer price (Purchase) Net customer-specific purchase price
Price for express delivery (Purchase) Purchase price for express orders
Price on request (Purchase) Purchase price available on request only
User-defined type (Purchase) Custom purchase price type
Nonbinding recommended price (Sales) Non-binding recommended retail price (RRP)
Unspecific Sales price General sales price without specific conditions

Map prices in XML import

To map a price field in an XML mapping, follow these steps:

  1. Select Search (Alt+Q), enter Import Data Mappings, and choose the related link.
  2. Open the mapping card and select XML > XML Mapping in the action bar.
  3. In the XML Mapping Lines, select the row that contains the price value from the XML.
  4. In the Destination Type field, select Related Table.
  5. In the Destination Table No. field, select Vendor Price.
  6. In the Destination Field No. field, select Price (or another field from the table, such as Currency Code or Minimum Quantity).
Tip

To import both the price value and the currency from separate XML elements, create two mapping lines pointing to the same Vendor Price table. Use Use Previous Record on the second line so both values go into the same price record.

Set the price type

The Type field on the Vendor Price record must be set correctly so that prices are transferred to the right price list during activation. Since the price type is usually not a separate XML element but a fixed value for the whole mapping, set it as a default value:

  1. In the mapping line for Vendor Price, go to Destination Relation Filter.
  2. Set a filter on the Type field with the appropriate value, for example List price excl. VAT (Purchase).

Map prices in Excel import

To map a price column in an Excel mapping:

  1. Select Search (Alt+Q), enter Import Data Mappings, and choose the related link.
  2. Open the mapping card and select Excel Workbook Mapping in the Excel Details FastTab.
  3. Select the column row that contains the price value.
  4. In the Destination Type field, select Another Related Table.
  5. In the Destination Relation field, select Prices.
  6. In the Destination Field No. field, select Price.

To import the currency code from a separate column, add another mapping line for the same source row with Destination Field No. set to Currency Code.

View imported prices

After importing, you can check the prices on the Vendor Item Card:

  • The Vendor Price FactBox on the right shows a summary of all prices for the item.
  • Select Prices in the action bar to open the full Vendor Price List for the item.

Transfer prices during activation

When you activate a vendor item to a Business Central item, imported prices can be transferred to BC price lists. Configure this in the Import Card and the Data Import Setup:

  • Sales Price List Header — Price list where sales prices (Unspecific Sales price) will be created.
  • Purchase Price List Header — Price list where purchase prices will be created.

See Activate Vendor Items for the full activation process.