Number Series

All tables in the MERA Open รค may have an associated range of numbers that determine whether a table's key can be entered by the user or be assigned by the system. If a table has no associate number series, the key, of course, entered by the user in the creation of a new row in the table. A number series can contain numbers, letters and special characters, but there are only counted on the numerical part. The system counts up until there is an unused number. Some tables are created automatically from others, for example. Create a slip from a sales order. The sequence for example. slips can be content with being a prefix to the sales order number. If so generated more rows (slips) from a table (sales order) form a continuous 2 digit suffix.

A number sequence automatically stops at:

  • Overflow in number.
  • When a user-defined maximum number is reached.
  • If the date of the transaction is greater than the number series completion date.

And transferred to a new number series. If there is no set new number series, interrupted transaction and the user is notified that the number sequence is over and a new one must be hospitalized.

A number series can be:

  • stock Dependent Number series of tables containing stock transactions (eg. Picking and delivery notes) can be marked that they are storage-dependent, and you can set up individual number series per stock.
  • Depending account Number series of tables containing reference to an account (eg. Orders) can be marked that they might account is dependent. If there is a range of numbers for the account used, else the default number sequence for the table.

In addition, a table number series points to another table, and you can run the same number series for several different tables. Eg. if you want the sales and purchase order must be running in the same number series.


At we use cookie. Read  Hide