Skip to Content
author's profile photo Former Member
Former Member

Sales cash settlement discount incorrectly calculated (UK)

When testing our cash settlement discounts given to customers I notice that when matching the cash received (with customer having taken the discount) with the invoice (FB05) the discount in being overstated.

In the UK, the VAT applied to the invoice should be calculated after the cash discount is deducted. e.g. for 20% VAT and a 10% cash discount:

If my item is £100, then the VAT is £18 (20% of £90 (100-10)) making the invoice total £118.

I would be expecting the customer to pay £108 (£120 less 10% or £118 less 10% of £100), an 8.5% discount on the invoice total (inc VAT), since the VAT is already discounted.

However FB05 is calculating a 10% discount on £118 (£1.18), so expecting £106.20, which is taking a double discount on the VAT.

Any ideas what is causing this and how to rectify?

Thanks

Ben

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 25, 2011 at 12:29 PM

    Please check OBY6, here Discount base amount is the net value should be activated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.