A new knowledge base article has been published on our support portal.
In this scenario the business requirement that needed to be solved was related to tax on Order Products.
The customer wanted a simple way to update the Tax on all the Order Products connected to an Order. To solve this we added a custom tax field to the Order form that will hold the tax rate percentage. When this is changed the formula will calculate the value of the tax in each Order Product and update it accordingly.
N52 Formula Manager Solution
The Formula Manager solution works like this,
- A Formula of type ‘Save – Perform Action’ is created on the Order entity
- Event is set to ‘Create & Update’
- Source Property is set to Tax