Setting up number series for invoice related documents

Related topics

DC1 supports the following types of invoice related documents:

  • Invoice
  • Credit note
  • Cash receipt
  • Cash credit receipt
  • IRO invoice
  • Pending invoice
  • Pending credit note

The number series set-up for these types of documents differs from other types of documents that require a number series. All invoice related documents require a connection to a document type, which is ultimately connected to the document number series. In some EU countries, legislation stipulates that for each VAT registration number a unique document number series for invoices/credit notes must be used. For one VAT registration number different document number series for different types of invoices/credit notes can be used. If your business spans several invoice (delivery) countries, you can set the system up to ensure you adhere to any legislation in place. The flexibility via document types allows you to stay within the same document number series for the same invoice (delivery) country. Simply put, you would set up different document types for different countries or warehouses, allowing you to have multiple document number series per type of invoice related document and country.

The following needs to be set up:

File/Table To do
Document number series table Define the document number series for the invoice related documents. Note: During invoicing, statistics are written to BIW (Business Information Warehouse). This can also be possible even if no invoice/credit note is printed, as is the case for pending invoices and pending credit notes due to periodical invoicing. If the PNDINVS (Pending invoice statistics) function is activated in the Function control file, those BIW transactions for pending invoices/pending credit notes also receive an invoice number/credit note number from this document number series.
Document type table Create A/R related document types for the applicable invoice related documents. Then connect the applicable document number series to the applicable document types.
DIS control file Navigate to the Number series panel. Click the Invoice types function key and set up the invoice types on system level. For each applicable preloaded invoice type, connect the applicable document type.
At this point the system is ready to utilize the invoicing functionality, consuming numbers from the applicable document number series. IF you must adhere to EU regulations or any other invoicing regulation, whereby you cannot break the invoice number series within the same invoice (delivery) country, continue with the set up stated below to override the document number series. This override can be done on country level or on warehouse level. The warehouse level is the lowest level and is always country dependent.
Document type table For the applicable A/R related document types for the invoice related documents, set the Unique number series field to YES. This will ensure you use the same document number series for the same document type. Separate document types can be set up per invoice type, each having a unique document number series.
Work with countries (if wanting to override on country level) For the applicable country, click the Invoice types option and connect the applicable document type.
Work with warehouses (if wanting to override on warehouse level) For the applicable warehouse, click the Invoice types option and connect the applicable document type.

If DC1 Alert Management is installed and activated you can configure an alert, (i.e. SONOTINVCD = Sales order not invoiced), to be triggered during invoicing that will alert the user if the document type is not found or if no document number series is found. In both cases the order will not be invoiced.

Related topics