Template for Belgian market upgraded to version 1.5.2


#1
  • 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.


Template for Belgian Market
#2

Hello, I’m new with IP so can you guide me to install it?

& Is there a version for the Quotation also?

Regards


#3

hi
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

rgds


#4

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


#5

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.


#6

Hi,
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
Severity: Notice
Message: Undefined index: miw
Filename: src/Mpdf.php
Line Number: 20462
Backtrace:
File: /var/www/ip/vendor/mpdf/mpdf/src/Mpdf.php
Line: 20462
Function: _error_handler
File: /var/www/ip/vendor/mpdf/mpdf/src/Tag.php
Line: 6596
Function: shrinkTable
File: /var/www/ip/vendor/mpdf/mpdf/src/Mpdf.php
Line: 14873
Function: CloseTag
File: /var/www/ip/application/helpers/mpdf_helper.php
Line: 75
Function: WriteHTML
File: /var/www/ip/application/helpers/pdf_helper.php
Line: 103
Function: pdf_create
File: /var/www/ip/application/modules/invoices/controllers/Invoices.php
Line: 280
Function: generate_invoice_pdf
File: /var/www/ip/index.php
Line: 327
Function: require_once
....

#10

Hi Cita,

How can I put the function format_currency_other? Which function should I literaly copy to the helper php?