search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.23k stars 2.72k forks source link

Missing field "manufacturer" on product/services #27236

Open lmag opened 8 months ago

lmag commented 8 months ago

Feature Request

Missing manufacturer on product

Use case

Missing manufacturer on product to know norme, type of fabrication, etc... Sample an scaffolding should be manufacturer by -Thirdparty 1 -Thirdparty 2 and sell by -Thirdparty 3 On certain products we can have the name of the manufacturer for traceability

Suggested implementation

Add table for link product/service to manufacturer Add tab Add norme, label, etc... for manufacer between date start and date end

Suggested steps

No response

FHenry commented 8 months ago

Table schema suggested new Dictionnary of Relation type between product/service and thridparty

rowid code label active

new Relation Table

rowid fk_product : required fk_soc : required fk_relationtype : required date_start date_end

Sample data can be Product 1 is Manufacture by Soc1 from 01/01/2021 to 31/12/2022 Product 1 is certified ISO9011 by Soc1 from 01/01/2021 to 31/12/2021 Product 1 is Selling by Soc2 from 01/01/2022 to 31/12/2023

On Product or service list (or other dedicated list) it should be possible to filter by Relation type , date range start, date range end, Thirdparty

lmag commented 8 months ago

@eldy any advice ?

eldy commented 8 months ago

Looks good to me. Can you update the migration 19 to 20 instead of 18 to 19 ?

FHenry commented 1 month ago

Work in progress https://github.com/FHenry/dolibarr/tree/dev_UI_product_thirdparty IF anyone want to contribute, feel free