Skip to main content

Hi, 

I have a formula (percentage) field that calculates the margin based on Net Total and Cost for a Quote Line Item.

Now that one of our target markets needs Quotes that always have VAT included in the pricing, I created a price rule that adds VAT to the Quote Line's Unit Net Price if 'VAT included' is checked on the Quote Record.

Any idea on how to change my formula field (that displays the margin), so the margin is still displayed without taking VAT into account? I cannot use the Net Total anymore as this has VAT included. I tried to create additional fields for Unit Net Price (without VAT) and Net Total (without VAT), but the resulting values don't seem to add up.

Thanks

2 comentarios
  1. 30 mar 2021, 15:26

    Thanks for stopping me overthinking it.

    I have formula fields now that add VAT to Package Total and Grand Total (Which are the only ones that'll be displayed on the Quote Doc).

0/9000