Discount Groups

Discount groups from the R record and their role in determining the purchase price.

Where they come from

Discount groups live in the R record, usually in a file with the extension .RAB. An R record carries

Value	Meaning
Discount group	The key articles reference.
Discount indicator	Distinguishes whether the value is a discount or a factor.
Discount / factor	The value itself, for example 20 for 20%.
Description	Plain text of the group, such as "Baths/Shower trays".

The app creates entries in DATANORM Discount Groups from these.

Many suppliers ship the discount rates as 0 and agree the actual terms separately. A discount of 0% is therefore often not an import error but exactly what the file says.

Effect on the purchase price

By default the discount group does not affect the purchase price – the app writes the price the file delivers.

Enable Apply Discount Groups to Purchase Price in the setup and the app applies the group's discounts to the list price to derive the purchase price. Multiple discounts are chained multiplicatively, as DATANORM specifies.

Example of multiplicative chaining

List price 100.00, discounts of 20% and 10%:

• multiplicative (how DATANORM works): 100 × 0.80 × 0.90 = 72.00
• additive (30% at once) would be: 100 × 0.70 = 70.00

The app uses the multiplicative variant.

Details on price determination under Purchase Price Lists and Sales Prices and Discount Groups.

Import order

If discounts are to affect the price, the .RAB file must be imported before you write the price lists. Otherwise the app does not yet know the discount rates and uses the price from the file.

Switching processing off

Use Process Discount Groups in the Record Filters section to skip R records entirely.