Hello,
I am trying to create a word document quote (based off the templates available online), but am having trouble finding the field that would calculate the line item x the quantity - the manual discount. In our old SQL based quotes that line was "extendedtotal" but in the word docs that is showing the line total including tax. I also tried "baseamount" but that does not include the manual discount. Because of tax regulations our discounts must be before tax is calculated so having a lumped sum of discounts will not work.
Any help would be appreciated.
*This post is locked for comments