Is it possible to modify the quotation numbers?

The module configuration does not let you choose the starting quote number or its format.

The PDF number contains OD, the year and month of the quote date, then its identifier padded to at least four digits. Changing the table counter does not change this format or renumber existing quotes.

An expert can change the next identifier in the database after taking a backup and checking the largest existing value. The example code is:

ALTER TABLE ps_opartdevis AUTO_INCREMENT = 60;

In this example, ps_ is the table prefix and 60 is the desired value for new identifiers. Adapt the prefix to your shop and choose a value above identifiers already used.

IMPORTANT: If you do not have perfect mastery of SQL, do not make this modification yourself. Ask an expert to do it for you!

Other FAQs in this category