Compiere provides a variety of options how to generate and manage document numbers and formats. It also allows to maintain gapless sequence numbers. When any table has a the field "DocumentNo", it is recognized and managed as a document number.
The default algorithm checks, if the field is empty and if so, a number is assigned. This number comes from an automatically created Document Sequence, which is sufficient for many areas. When a table has a Document Type (field "C_DocType_ID"), you determine for that Document Type if the numbering is manual the default behavior applies (i.e. if it is not entered, the number is created from the automatically created sequence). If the document type is document number controlled, a Sequence is referenced. Multiple document types can share a sequence or can have it's own sequence.
A Document Sequence can also have a user defined prefix and suffix, so you can create document numbers like "Sales-12345-Export". Same algorithm here, if the Document number is empty, the number is created from the document sequence for the specific document type.
Recent Comments