We have several products that require annoying recalculations based on product value.
e.g. Widget Gross - £20.00 = Nett £16.67 + VAT = £3.33 = £20. All good for a single item.
However, if I change the quantity to 3 items on the sales order we then get
Widget Gross - £60.01 = Nett £50.01 + VAT = £10.00 = £60.01. Annoying.
The only way to fix it on either a sales order or invoice is to enter the line item with double click or F3, re-input the gross value in "Unit Price GBP £" of £20 and press Calc Net. at which point the VAT value switches to £3.33 and all is well.
In a long list of invoice items we have to do this for every line item and it takes a long time.
We need a 'post process' on the quantity field that automatically peforms a 'Calc Net. function thus correctly updating the VAT value where quantities equal more than one rather than having to edit every record.