Formula based discount (or markup)
I would like to be able to offer a VAT discount to customers who cannot reclaim VAT. Even though we are VAT registered, we want to be able to 'strip' the VAT amount from a product using the formula x = x / 120*100.
Simply put, an item selling for £100+VAT is £120 to the customer.
We want to give customers an offer of (eg) NO VAT in January.
We want to create a product called 'VAT Friendly'
So, the £120 item will sell to the customer for the pre VAT price of £100, but we still must pay our VAT, so the price would be actually be £83.33 + VAT. There is still VAT in the sale, but the customer benefits from a discount equal to the VAT.
To get from £120 to £100 (pre VAT price) cannot be achieved by a simply % discount so a formula is required.
It would be double nice, if this discount formulated product could be hidden so it effectively modifies the line item above it (or entire invoice) without being shown as a line item. This could allow unpublished discounts or mark-ups from being show.
Ryan (CTO, Pinellas Computers) commented
@RS: This appears to be a duplicate of a similar idea. Please redirect votes here: http://feedback.repairshopr.com/forums/165658-general/suggestions/5531550-automatically-calculate-markup