Trigger for discount on orders
It is possible to add a trigger to manage the discount in the ordering process.
In this example we will give automatically discount based on the user groups the person ordering beloangs to.
-
People that are in the group 'Student' will get 50% off.
-
People that are in the group 'Internal' will get 100% off (they can order for free).
-
People in any other group (not in Student nor Internal) will get no discount and will have to pay the full price.
-
In the Order template, make sure that the option Reduction group is unchecked.
-
In the desktop, go to the backstage section - Database - Edit groups of current database
-
Check the ID of the groups to be included. In this example the Interal group is ID7 and the Student group is ID8
-
Check the following information:
-
World id: In the backstage section - Info - Current database information
-
in these example triggers we will use the Word id: 1234567
-
ID of Total price field in the Order headers table
-
ID of Order status field in the Order headers table
-
- Database, Trigger management (admin rights are required to be able to access the Trigger management). Two triggers are needed to make the reduction go smootly: