Hello
We have customers who receive different discounts on some products but not on all products and the discount percentage is entered in Sage 200 for each product sold whenever we generate the sales order.
I need to show the total amount of discount (net amount deducted) on the footer lines of the sales orders and invoice so I will have a layout as the one below:
Invoice net amount = Individual values without discount
Discount = total amount of discount applied for each line on the invoice
VAT = VAT on net amount minus discount
Total to pay = (Net amount - Discount) + total VAT
Can you please advise how can I achieve this task?
Thank you very much for your help.
Kind regards
Mihaela