Create Number Series

For each company that you set up, you need to assign unique identification codes to things such as general ledger accounts, customer and vendor accounts, invoices, and other documents. Numbering is important not only for identification. A well-designed numbering system also makes the company more manageable and easy to analyze, and can reduce the number of errors that occur in data entry.

Note

We recommend that you use the same number series codes as you see listed in the No. Series List window in the CRONUS demonstration company. Codes such as P-INV+ might not make immediate sense to you, but Business Central has a number of default settings that depend on these number series codes.

You create a numbering system by setting up one or more codes for each type of master data or document. For example, you can set up one code for numbering customers, another code for numbering sales invoices, and another code for numbering documents in general journals. After you have set up a code, you set must set up at least one number series line. The number series line contains information such as the first and last number in the series and the starting date. You can set up more than one number series line per number series code, with a different starting date for each line. The series will be used consecutively, starting each series on the respective starting date.

You typically set up your number series to automatically insert the next consecutive number on new cards or documents that you create. However, you can also set a number series up to allow that you manually enter the new number. You specify this with the Manual Nos. check box.

If you want to use more than one number series code for one type of master data - for example, if you want to use different number series for different categories of items - you can use number series relationships.

Behavior of the No. field on Documents and Cards

On sales, purchase, and transfer documents and on all cards, the No. can be filled in automatically from a number series or manually, and it can be set up to be invisible.

The No. field can be filled in three ways:

  1. If only one number series for the type of document or card exists where the Default Nos. check box is selected and the Manual Nos. check box is not selected, then the field is automatically filled with the next number in the series, and the No. field will not be visible.

    Note

    If the number series does not function, for example because it has run out of numbers, then the No. field will be visible and you can manually enter a number or resolve the issues in the No. Series List window.

  2. If more than one number series for the type of document or card exist, and the Default Nos. check box is not selected for the number series that is currently assigned, then the No. field is visible, and you can look up to the No. Series List window and select the number series you want to use. The next number in the series is then inserted in the No. field.

  3. If you have not set up a number series for the type of document or card, or if the Manual Nos. field is selected for the number series, then the No. field is visible and you must enter any number manually. You can enter a maximum of 20 characters, both numbers and letters.

When you open a new document or card that a number series exists for, then the relevant No. Series Setup window opens so that you can set up a number series for that type of document or card before you proceed with other data entry.

Note

If you need to enable manual numbering on, for example, new item cards that have been created with a data migration process that has hidden the No. by default, then go to the Inventory Setup window and choose the Item Nos. field to open and set the related number series to Manual Nos..

To create a new number series

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter No. Series, and then choose the related link.
  2. Choose the New action.
  3. On the new line, fill in the fields as necessary. Hover over a field to read a short description.

To set up where a number series is used

The following procedure shows how to set number series up for the Sales area. The steps are similar for other areas.

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter Sales & Receivables, and then choose the related link.
  2. In the Sales & Receivables window, on the Number Series FastTab, select the desired number series for each sales card or document.

The selected number will now be used to fill in the No. field on the card or document in question, according to the settings you made on the number series line.

To create relationships between number series

If you have set up more than one number series code for the same kind of basic information or transactions, you can create relationships between the codes. This feature can assist you in deciding among the codes when you use a number.

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter No. Series, and then choose the related link.
  2. Select the line with the number series you want to create relationships for and then choose Relationships.
  3. In the Series Code field, enter the code for the number series that you want to relate to the series you selected in step 2.
  4. Add a line for each code that you want to relate to the selected number series.
  5. Close the window.

Now when you set up something that requires a number, you can use the relationships you created to select among the related number series.

See Also

Setting Up Business Central
Working with Business Central