Changes

If the new rule can crete conflicts with old one, it will be necessary to rename old existing references. This can be do by a SQL request.

If the new rule can crete conflicts with old one, it will be necessary to rename old existing references. This can be do by a SQL request.

For example, to go from numbering module Jupiter (FYYYYMM99) to Terre (FAYYMM-999), you can run the folloing request:

For example, to go from numbering module Jupiter (FYYYYMM99) to Terre (FAYYMM-999), you can run the folloing request:

<pre>

<source lang="sql">

update llx_facture set facnumber=concat('FA',substr(facnumber,4,4),'-',substr(facnumber,8))

update llx_facture set facnumber=concat('FA',substr(facnumber,4,4),'-',substr(facnumber,8))

where facnumber like 'F%' and facnumber not like 'FA%';

where facnumber like 'F%' and facnumber not like 'FA%';

</pre>

</source>

For example, to rename references from modele FAYYMM999 to Terre (FAYYMM-999), you can ru the following request:

For example, to rename references from modele FAYYMM999 to Terre (FAYYMM-999), you can ru the following request:

<pre>

<source lang="sql">

update llx_facture set facnumber=concat('FA',substr(facnumber,3,4),'-',substr(CONCAT('0000',substr(facnumber,7)),-4))

update llx_facture set facnumber=concat('FA',substr(facnumber,3,4),'-',substr(CONCAT('0000',substr(facnumber,7)),-4))

where facnumber like 'FA%' and facnumber not like '%-%';

where facnumber like 'FA%' and facnumber not like '%-%';

</pre>

</source>

= Submit a patch, work and help on Dolibarr development =

= Submit a patch, work and help on Dolibarr development =