Supporting product and financial discounts as well as mutliple VAT rates.
Also mentions composition of VAT amount as required by BE VAT administration.
Also allows invoicing in foreign currency eg USD.
The delivery date which is best practice to allow VAT administration to determine the period for which VAT is due, is now a custom field placed in the properties.
Prerequisites are mentioned in the template, you need to create 5 custom fields
The invoice looks like this
This the template
SRNGBEFact.php (17.2 KB)
If you want to see it in action just mail info(at)
sanremong.com and we will give you access to our demo environment.
Hello, I’m new with IP so can you guide me to install it?
& Is there a version for the Quotation also?
just dowload the template and move it to your server. see the IP wiki for explanations how to do this.
then you can select the template in the application.
also dont forget to create the custom fields.
in BE you pay vat on the real price ie the price after discount, ip however calculates vat on the price before the discount. you need to fix that if you don t want the standard behavior.
we dont yet have a version for the quotes
June 18, 2017, 8:34am
I don’t think it matters when you add the discount. Here’s my math, correct me if I’m wrong.
Say for example we sell an item which costs € 150 and we give a family discount of 10%
In this example I’m adding the VAT to the total price, and apply the discount afterwards:
(150 + (150 * 0,21)) * 0,9 = 163,35
Now this one is more complex
(150 * 0,9) calculates the discount on the item
((150 * 0,9) * 0,21) calculates the VAT on the discounted item
When you add them up, you get the same result
(150 * 0,9) + ((150 * 0,9) * 0,21) = 163,35
June 18, 2017, 2:31pm
to continue your example , invoiceplane calculation is as follows 150 * 0,21 + 150 * 0,9 = 166,5.
in other words invoiceplane calculates VAT on the full amout and not on the discounted amount, in BE that is not correct.
I’m using your template, but when the invoice contains more than a certain amount of lines (10 in my case), I’m getting an error.
Am I the only one ? I’m using IP 1.5.3.
A PHP Error was encountered
Message: Undefined index: miw
Line Number: 20462
September 22, 2017, 9:15am
How can I put the function format_currency_other? Which function should I literaly copy to the helper php?
I tried to install your template, I am new in IP. I got many errors. can you help me, with custom fields and maybe to fix the errors?
Thanks in advance for your help.
P.S. I using version 1.5.11
have fixed errors on this template. If u like to have your own template, please msg me.
Thanks but file is not avalable anymore. If you can reupload this will be great