Promotions

Promotions in SQL

This chapter contains only SQL Provider specific information related to the promotions configuration. The general information about the promotions configuration can be found here.

If a fixed amount type is selected the fixed discount amount should be configured. The SQL Provider supports only the B2C scenario. By default the customers have the property 'Prices including VAT' set to 'true'. Therefore the value including VAT is retrieved for the promotion discount.

The promotion can be seen in the sales order details in the backoffice. The promotion discount is saved in the order lines. It can be viewed in the 'Sales -> Sales orders' category of the backoffice. Click on the 'View order lines' link of the related order.

When the order export is run from SQL to NAV the order is saved without invoice discount calculations in the same way as it is saved in the SQL database.