Sales Prices and Discount Groups

Optionally derive sales prices from DATANORM data, and how discount groups are taken into account.

Sales prices from DATANORM

DATANORM is a format for supplier data – the list price is your supplier's purchase list price, not your sales price. That is why Write Sales Price Lists is off by default.

Enable the option if you want to use the list price as a starting point for sales. The app then writes it into a shared sales price list for all customers.

Property	Value
Code	Prefix with the price type, for example DN-SAL.
Description	DATANORM sales prices
Source type	All Customers
Status	From Price List Status in the setup.

Before enabling this, consider whether you really want to sell at the purchase list price. The app applies no mark-up. Keep your margin in a separate price list or in a Business Central costing setup.

Recommended approach

1

Purchasing first

Let the app maintain the purchase prices, see Purchase Price Lists. That is the part DATANORM is designed for.

2

Calculate sales prices yourself

Keep sales prices in a price list of your own, based on the DATANORM purchase prices. Your calculation then stays traceable and is not overwritten by the next import.

3

Use the status stage

Set Price List Status to Draft if every price change should be approved before it takes effect in sales.

Discount groups in purchasing

The DATANORM discount group describes the discount you receive from your supplier. Two routes are available:

Route	Effect
Apply Discount Groups to Purchase Price off (default)	The price from the file is written. You maintain your terms separately in Business Central.
Apply Discount Groups to Purchase Price on	The app applies the discount group's discounts to the list price and writes the net price into the price list.

Discounts are chained multiplicatively, as DATANORM specifies: 20% and 10% amount to 28% total discount, not 30%.

The second route pays off when your supplier really does deliver the terms in the .RAB file. Many suppliers ship 0% there and agree discounts separately – in that case leave the option off. See Discount Groups.

How the settings work together

Goal	Settings
Maintain purchase prices only	Write Purchase Price Lists: on · Write Sales Price Lists: off
Take the supplier's net prices	Source: Net Price then List Price · Apply discount groups: off
Derive net from list price and discount	Source: List Price · Apply discount groups: on · import .RAB first
Sales prices with approval	Write Sales Price Lists: on · Price List Status: Draft