Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
VAT rounding by line rather than item
I've searched the forums and haven't seen that anyone else is having this problem, but can't believe it's so. We primarily advertise our products as VAT inclusive. our clients are not interested in the price excluding VAT.
[LIST]
[*]So, a product might be priced in our catalogue at £1.39 (inc. VAT).
[*]We put this into Netsuite as £1.18 (£1.39 / 1.175 - rounded to the nearest penny).
[*]When this is sold as an individual item Netsuite calculates the VAT and gives a Gross Amount as £1.39. No problem.
[*]However when we sell 100, Netsuite does the calculation and comes up with £138.65 (£1.18 x 100 x 1.175 - rounded to the nearest penny at the end of the calculation), rather than £139.00
0