Hi all,
I've been going through the sales taxes of sage 50 for sometime and I'm trying to find a way how to calculate chained vat or tax calculations.
Further explaining the chained vat / tax scenario.
If an invoice is issued to a customer for two items each costing 50 the sub total without taxes will be 100. so under the same tax organization the taxes are mentioned separately as NBT = 2.4% and VAT=8.0%
With reference to the image mentioned below it is required to calculate the sub taxes appearing under the same tax agency as
(Total amount without taxes * NBT%)+ (Total amount without taxes+(Total amount without taxes * NBT%)) * VAT%
and the total billing amount will be Total amount without taxes + ((Total amount without taxes * NBT%)+ (Total amount without taxes+(Total amount without taxes * NBT%)) * VAT%)
If someone knows the solution please kindly help me to solve this.