31,028
edits
Developer FAQ: Difference between revisions
Jump to navigation
Jump to search
m
→Change my numbering system after start
| Line 86: | Line 86: | ||
= Change my numbering system after start = | = Change my numbering system after start = | ||
{{ToTranslate}} | {{ToTranslate}} | ||
If the new numbering system does not conflict with the old one, to change the numbering rule, just go on menu Setup - Modules - Invoice setup and choose the new numbering rule in the list. | |||
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: | |||
<pre> | <pre> | ||
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)) | ||
| Line 94: | Line 94: | ||
</pre> | </pre> | ||
For example, to rename references from modele FAYYMM999 to Terre (FAYYMM-999), you can ru the following request: | |||
<pre> | <pre> | ||
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> | </pre> | ||
= Submit a patch, work and help on development = | = Submit a patch, work and help on development = | ||