I want to add an additional column in specific table, but I am new to dolibarr and I can not handle it by myself. Any help is much appreciated.
In Products and Services modules setup, I have added Complementary attribute called “location”, which will point the place where each product is stored in my warehouse.
I would like to add an additional column, also called “location” in products list table at Sales Orders section.
The idea is, when I open an order card, to have this additional column with Complementary attribute “location” of each product in the table with all purchased products.
Is it possible to implement this column?
If anyone has a solution to a similar problem, I will be very grateful for sharing the solution.
In the product module I created extrafield, called “location”.
When I create or edit product, I enter the value of the “location” extrafield.
Then, when I open Sales order card there is a table with products, purchased in that order.
I want in that table to be visual the “location” of each product.
You suggest to create an extrafield ‘location’ on Sales Order line, but how to call the value of the ‘location’ extrafield already created and stored at product card?
One extrafield on product called location type “String”
One extrafiled on Sales Order line, called location (or anything else we don’t care), type : “computed filed”, value : (($reloadedobj = new Product($db)) && ($reloadedobj->fetch($objectoffield->fk_product))) ? $reloadedobj->array_options['options_location'] : 'Not found'