Purchase Price Lists

Write imported DATANORM prices as a real purchase price list for the vendor so purchase price calculation picks them up.

What the app writes

An imported price is only useful once Business Central finds it on a purchase order. The app therefore writes prices not just onto the item but as price list lines into a purchase price list for the delivering vendor. Standard Business Central price calculation then applies.

One DATANORM purchase price list is created per vendor and updated on every subsequent import.

Property	Value
Code	Prefix, price type and vendor number, for example DN-PUR-10000. Set the prefix through Price List Code Prefix.
Description	DATANORM purchase prices plus the vendor name.
Source type	Vendor
Status	From Price List Status: Active or Draft.

Steps

1

Synchronise the articles

Price lines need an item, so synchronise article staging first, see Reviewing and Approving Staging.

2

Write the prices

Run Write Purchase Price List on the import session.

3

Read the result

The app reports the number of purchase, sales and scale price lines written, plus the number of articles skipped.

4

Open the price list

Verify the result with Show Purchase Price List.

With Write Purchase Price Lists enabled in the setup, prices are already written during synchronisation. You then only need the action on the import session to write them again, for example after reassigning the vendor.

Which price becomes the purchase price?

DATANORM delivers up to two prices per article, distinguished by the price indicator: the list price (indicator 1) and the net price (indicator 2). Purchase Price Source decides which one applies.

Setting	Effect
Net Price	Only the net price is used. Articles without a net price get no price line.
List Price	Only the list price is used – sensible when you derive discounts from the discount group.
Net Price then List Price	Prefers the net price and falls back to the list price when it is missing. The shipped default and the most robust choice for most deliveries.

Applying discount groups

Enable Apply Discount Groups to Purchase Price and the app applies the discounts of the DATANORM discount group to the list price. Multiple discounts are chained multiplicatively, as DATANORM specifies.

The .RAB file must be imported before you write the price list, otherwise the app does not know the discount rates. See Discount Groups.

Price changes

A DATPREIS file contains only new prices for articles already delivered. After importing it, run Write Purchase Price List; the app updates the existing lines of the price list rather than creating new ones.

If a price record carries a validity date, it becomes the starting date of the price line.

Skipped articles

The result message reports a number of skipped articles. Typical reasons:

Reason	Remedy
The article has not been synchronised yet.	Approve and synchronise article staging, then write again.
The article has no price in the selected source.	Set Purchase Price Source to Net Price then List Price.
The price is 0.	Check whether the supplier actually delivers the price.

If no vendor is assigned to the import, writing stops with a message – a purchase price list without a vendor is not possible. Assign the vendor with Assign Vendor, see Manual Import and Vendor Assignment.