For the complete documentation index, see llms.txt. This page is also available as Markdown.

Scale Prices

Quantity-dependent prices from the Z record as additional price lines with a minimum quantity.

Where they come from

Scale prices come from the Z record. The supplier states from which quantity a lower price applies – for example 12.50 from 10 pieces and 11.80 from 50 pieces.

How the app represents them

With Write Scale Prices (Z Records) enabled, each tier becomes an additional line in the same purchase price list for the vendor, carrying the minimum quantity from the Z record.

From the Z record
In the price line

Article number

Item of the price line

Minimum quantity

Minimum Quantity

Scale price

Unit Cost

Validity date

Starting Date, where delivered

Business Central automatically picks the line with the highest applicable minimum quantity on a purchase order.

Example

An article has a base price of 13.20 and two tiers:

Minimum quantity
Price

0

13.20

10

12.50

50

11.80

Ordering 30 pieces uses the line with minimum quantity 10, so 12.50.

Prerequisites

Two toggles must be on for scale prices to arrive: Process Surcharges in the Record Filters section – so that Z records are read at all – and Write Scale Prices (Z Records) in the Price Lists section.

If no tiers show up

Cause
Check

The file contains no Z records.

Many deliveries come without scale prices. Price staging shows what was read.

Z records are switched off.

Process Surcharges in the setup.

Writing is switched off.

Write Scale Prices (Z Records) in the setup.

The article is not synchronised.

Synchronise the articles first, then write the price list.

Surcharges

Besides scale prices, the Z record carries surcharges such as copper-dependent add-ons. The app takes those values as information on the article but derives no price from them. A day-to-day copper recalculation is not part of the app, see Limitations.

Last updated