Price- and discount matrix

The bar code can be printed on the price lists.

Used in the integration between Zpider and Business NXT. With this field, the changes you make in Business NXT are updated in Zpider immediately.

Cost prices are used to calculate stock values and incurred costs. Stock values are always calculated using the FIFO price in the Shipment table.

Customers can be assigned to one or more customer price groups in the corresponding field in the Associate table. Valid customer price groups are defined in the Text table. Customer price group settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the customer price group for rows without a product no should be applied in the Order and Order line table or not.

Customers can be assigned to one or more customer price groups in the corresponding field in the Associate table. Valid customer price groups are defined in the Text table. Customer price group settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the customer price group for rows without a product no should be applied in the Order and Order line table or not.

Customers can be assigned to one or more customer price groups in the corresponding field in the Associate table. Valid customer price groups are defined in the Text table. Customer price group settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the customer price group for rows without a product no should be applied in the Order and Order line table or not.

Delivery methods can be assigned to a customer in the corresponding field in the Associate table. Valid delivery methods are defined in the Text table. Delivery method settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the delivery method for rows without a product no should be applied in the Order and Order line table or not.

Delivery terms can be assigned to a customer in the corresponding field in the Associate table. Valid delivery terms are defined in the Text table. Delivery term settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the delivery term for rows without a product no should be applied in the Order and Order line table or not.

The Empl. no. is a unique number identifying one specific Employee.

Employees can be assigned to a employee price group in the corresponding field in the Associate table. Valid employee price groups are defined in the Text table. Employee price group settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing in the Company information table controls whether the employee price group for rows without a product no should be applied in the Order and Order line table or not.

Do not use more favourable price/discount

The selections for discounts do not apply if the Search for price - discount amount checkbox is selected in the Discount suggestion field in the Company information table.

You can also excempt a product from discounts by selecting the discount in the dialog box and leave the discount field empty. For example can this be used on products that belong to a group that is given a discount.

No discount % on

You can choose not to calculate percentage discounts on sales, hire and purchase prices. This might, for example, be appropriate for campaign prices.

This applies to discount percentage only. If there is a discount amount in the same row in the Price and discount matrix, this is deducted.

Sales price

Sales discount

Hire price

Hire discount

Compensation price

Purchase price

Purchase discount

Cost price

Sales price

Hire price

Purchase price

Sales price addition

If you do not enter a from and/or to date, the row remains valid for an unlimited period until it is changed or deleted.

The date is validated using the regional settings in Windows.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.

All price options in the dialog can be used as gross or net price. Cost prices are always net and are therefore not displayed in this dialog box.

Sales price

Suggested price

Hire price

Compensation price

Purchase price

The price and discount settings will be applied depending on whether the product is part of a structure or not.

The Included in structure settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the Included in structure for rows without a product no should be applied in the Order and Order line table or not.

1 - Only if included in structure

You can limit prices and discounts when the product is included in a structure by entering this value.

2 - Not if included in structure

The row is only valid if the product is not included in a structure.

The value is set automatically when updating product data from Incoming product data. The field contains a lookup to the Incoming document table.

Prices and amounts with positive numbers in sales order lines are adjusted downwards if the line amount is higher than the Maximum amount. The price is set at the Maximum amount field divided by the Quantity field of the Order line.

The price on the Order line is set at the Minimum amount field divided by the Quantity field.

In this field you enter the minimum quantity of units for the row to be taken into account. The minimum quantity is compared to the Quantity field in the Order line and is valid regardless of whether you have filled in the Quantity 1 and Quantity 6 fields. If the value 1 is set in the Prices/disc. total field in the Company information table, the total quantity for the lines in the orders are based on the same value in the Product price gr. 1 field.

Order no settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the order no for a row without a product no should be applied in the Order and Order line table or not.

Orders can be assigned to an order price group in the corresponding field in the Order table. Valid order price groups are defined in the Text table. Order price group settings in the Price- and discount matrix table are not automatically taken into consideration if they are not associated to a particular product. The Price/discount processing setting in the Company information table controls whether the order price group for rows without a product no should be applied in the Order and Order line table or not.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

The field appear with the name assigned to it in the Company information table.

The field appear with the name assigned to it in the Company information table.

The field appear with the name assigned to it in the Company information table.

The field appear with the name assigned to it in the Company information table.

The field appear with the name assigned to it in the Company information table.

The field appear with the name assigned to it in the Company information table.

It updates the Description field in Order line table and the Product transaction table. The corresponding value from the Product table gets overridden.

Can be used as additional information.

The date is validated using the regional settings in Windows.

It gets automatically filled when a date is set in the Price cat. date field.

Can be used as additional information.

Valid price types are defined in the Text table.

If a price unit is entered in a row of the price and discount matrix, then this row is only valid for order lines with that particular price unit. If the field is blank then the price will be applied to all order lines.

1 - Quantity in base unit

2 - Length

3 - Area

4 - Volume

5 - Net weight

The product no is not mandatory for price and discount settings. If the product no field is blank then the settings in the Price/discount processing in the Company information table will be applied.

Product price groups are defined in the Text table.

Product price groups are defined in the Text table.

Product price groups are defined in the Text table.

If the Split order line field is set in the Price- and discount matrix table then the order will be split automatically into multiple lines taking the quantities into consideration. The price in the Sales price field is applied up to the quantity in the Quantity 1 field, Sales price 2 to Sales price 6 fields are used for the corresponding quantity fields. The Sales price 7 field is used for the quantity which is above the set value in the Quantity 6 field.

If the Split order line field is set in the Price- and discount matrix table then the order will be split automatically into multiple lines taking the quantities into consideration. The price in the Sales price field is applied up to the quantity in the Quantity 1 field, Sales price 2 to Sales price 6 fields are used for the corresponding quantity fields. The Sales price 7 field is used for the quantity which is above the set value in the Quantity 6 field.

If the Split order line field is set in the Price- and discount matrix table then the order will be split automatically into multiple lines taking the quantities into consideration. The price in the Sales price field is applied up to the quantity in the Quantity 1 field, Sales price 2 to Sales price 6 fields are used for the corresponding quantity fields. The Sales price 7 field is used for the quantity which is above the set value in the Quantity 6 field.

If the Split order line field is set in the Price- and discount matrix table then the order will be split automatically into multiple lines taking the quantities into consideration. The price in the Sales price field is applied up to the quantity in the Quantity 1 field, Sales price 2 to Sales price 6 fields are used for the corresponding quantity fields. The Sales price 7 field is used for the quantity which is above the set value in the Quantity 6 field.

If the Split order line field is set in the Price- and discount matrix table then the order will be split automatically into multiple lines taking the quantities into consideration. The price in the Sales price field is applied up to the quantity in the Quantity 1 field, Sales price 2 to Sales price 6 fields are used for the corresponding quantity fields. The Sales price 7 field is used for the quantity which is above the set value in the Quantity 6 field.

If the Split order line field is set in the Price- and discount matrix table then the order will be split automatically into multiple lines taking the quantities into consideration. The price in the Sales price field is applied up to the quantity in the Quantity 1 field, Sales price 2 to Sales price 6 fields are used for the corresponding quantity fields. The Sales price 7 field is used for the quantity which is above the set value in the Quantity 6 field.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

The Price/discount processing in the Company information table allows individual setting for each discount. The Chain discounts matrix is used to set up the way how discounts are calculated and the discount suggestion tab is used to decide which discounts should be applied on order lines.

Sales price addition % must be used in combination with Sales price basis. You can limit the addition downwards by checking the Sales price addition box in the dialog box for the Fixed prices/discounts field.

The most favourable price is selected and you can easily combine the use of the Sales price addition % with ordinary sales prices.

You can also use the Price from supplier no. and Sales price addition % fields in the Order head to calculate sales price. The purchase price from supplier will be retrieved, raised by the addition from order head.

You need to enter the Sales price basis and Sales price addition % in the same row where you have entered the purchase price or cost price.

Exception: If you use option 3 - Average cost price from the stock balance table, you can enter the enter the Sales price basis and Sales price addition % in any row with the product number or covered by the price/discount criteria that you have defined in the Company information table.

Purchase discount (% and/or amount) can only be used with option 2 - Purchase price after discount. For this option you need to enter the Purchase discount (% and/or amount) in the same row.

The Sales price addition % can be defined for all possible criteria. The program will use the lowest addition percentage if several rows meet the criteria. The Sales price addition % can be limited downwards by selecting this in the dialog for the field for fixed prices/discounts.

Business NXT will choose the most favourable price, and the use of the Sales price basis can be combined with ordinary specification of Sales prices.

1 - Purchase price before discount

2 - Purchase price after discount

3 - Average cost price from the stock balance table

4 - Cost price from the price and discount matrix

5 - Suggested price

6 - Cost price from the price and discount matrix with discount

The shipment number needs to be entered on the order line to get the price from the price and discount matrix.

If you select Split order line in a row in the matrix, the following prices are used:

• The price in the Sales price field for quantities up to and including the Quantity 1 field.
• Sales price 2 for quantities from Quantity 1 up to and including Quantity 2.
• Sales price 7 for quantities above Quantity 6.

The order lines can be split up to 7 times when quantities are entered.

If you have not checked the Split order line box, one of the prices for the whole quantity is used.

• Sales price when the quantity is less than Quantity 1.
• Sales price 2 if the quantity is greater or equal to Quantity 1 and less than Quantity 2.
• Sales price 7 if the quantity is greater than Quantity 6.

If you do not enter a from and/or to date, the row remains valid for an unlimited period until it is changed or deleted.

The date is validated using the regional settings in Windows.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.