We are faced with a situation where we need to omit the discount given to certain products from being included in the tax calculations. Example:
- we have a product with a sale price of 100
- the tax is 13%
- we want to give the customer a 10% discount, but we have to maintain the 13% tax amount
what we managed to find in the system is that any discount given on the item line will affect the tax calculated. Some suggested to put the tax on the sales order rather than the item line, but we need to be able to know which items were sold with discount.
So, our scenarios that we are looking for (from best to least working) are as follows:
1. a setup that will allow us to give discounts on certain products (on the line level) without affecting the tax
2. a setup that will allow us to give a discount on the entire sales order but will distribute the discount amount on the items (some sort of linking the discount to the items - and apologies for me not being accounting savvy, i am yet to take my AX Financial courses!!!)
3. a setup that will allow us to add the discount on the sales order and without affecting the tax amount imposed on the item's original price
Note: we are not using any retail modules and all sales are done through the Accounts Receivable - Sales Orders
Help is very much appreciated!
*This post is locked for comments