Customizing the Quote & Invoice

Job Offers
1

Hi,
i am looking for some one who can rename the “QTY” field as “Area” & the value should be calculated from 2 other custom columns “Length & Height”.

Can this be done?

2

I’m looking for exactly the same solution to calculate m² inside that box.

3

You mean like this ?

2 Likes
4

Yeah exactly that!

5

Can you share this with us?

6

Hi @oussamadouhou , could you explain with more detail ? It’s fine with me to code to fit your need.

7

What i need exactly is the follow:

heigth x width = m2

I was able to add the classes in the item_table view and add the heigth and width fields in this array and was able to add this also inside the loop, so the same row with needed fields is recreated after adding a new row, see picture below:

image
image1671×560 14 KB

8

Thank you for your detailed response. I had finished and can be downloaded from here.

Please follow the steps:

  1. Runing following sql commands via phpMyAdmin or SQL or any database tool:
ALTER TABLE `ip_invoice_items`
ADD `item_height` decimal(10,2) NOT NULL AFTER `item_description`,
ADD `item_width` decimal(10,2) NOT NULL AFTER `item_height`;

ALTER TABLE `ip_quote_items`
ADD `item_height` decimal(10,2) NOT NULL AFTER `item_description`,
ADD `item_width` decimal(10,2) NOT NULL AFTER `item_height`;

  1. Copy all files to your InvoicePlane installation folder.

  2. It shold be work :wink:

2594×344 13.5 KB

By the way, I use Hoogte and Breedte as shown in your image. You can edit the file application/language/English/ip_lang.php on line 46 and line 238 for changing it.

Please let me know if there is anything i can help.

2 Likes
9

Hi Wake,

First of all i really apriciate your help her. I already spent some days figuring this option, but i learned a lot about IP and the functions.

I will try this tonight and give you some feedback about it. But one more time, THANKS!!!

1 Like
10

Do you see any possibility we can chat?