Setting the Current Value for Naming Series
Naming Series feature allows you to define prefix for naming of a documents. For example, if a Sales Order has prefix "SO", then the series will be generated as SO-00001, SO-00002... and so on. Click here to learn how you can customize Number Series for a transaction/master in ERPNext.
1. Setting the Current Value
Naming Series feature also offers a tool where you can set Current Value for specific prefix. This is generally required if you have recently started using ERPNext, and have old transactions in the previous system, and you want the numbering series to start in from where it ended in the old system. Let's consider a scenario to learn this better.
For example, you have 322 Sales Orders created in your old system with SO00322 as highest Sales Order Id. In ERPNext, you need the first Sales Order to pick up #323 when it is saved. To enable this, you should set Current Value for SO series in following steps.
Go to Naming Series Tool
Setup > System > Naming Series
Update Series Section
Considering our scenario, prefix for Sales Order will be "SO".
If you have currently 12 Sales Orders created in your account, then current value updated will be 12. You can edit Current Value to 322, and then click on Update Series Number.
With this setting, you will have numbering for the New Sales Orders starting with #323.
2. Error Due Series Number
If you receive a Duplicate Name error while saving a transaction, for example, while saving Item Price, you receive an error saying:
Duplicate name Item Price RFD/00016
This error message indicates that when you are saving Item Price, system is trying to allocate "RFD/00016" to that Item Price record. But it is finding that Item Price with this ID is already existing in your system.
This error could arise because Current Value for Series/Prefix of Item Price is disturbed and not in sync with actual Current Value. While actual Current Value for Item Price could be 20 (or any number more than 16), someone has set Current Value for this series as 15.
To confirm actual Current Value for particular Series, you should check report for document in question (Item Price in this case), and check for the Item Price ID with highest value.
Let's assume we find that actual Current Value for Item price is 22, then you go Naming Series, and set Current Value for the Prefix/Series of Item Price to 22, and Update Series Number.
These instructions is applicable for all the documents in ERPNext for which user can customize Series and its Current Value.
Let's consider another scenario to learn this better. On assigning a document to another user, error message says:
Duplicate name ToDo TDI00014286
This indicate the Current Value for Series/Prefix of ToDo (TDI) has been disturbed. You should follow these steps to correct value for Current Value for TDI prefix.
- Check ToDo report for the highest ToDo id value.
- Setup >> Settings >> Naming Series
- Check section B of Update Series
- Select Prefix for ToDo "TDI"
- Ensure that highest number for ToDo is updated as Current Value in Naming Series. If not, correct Current Value, and click on "Update Series Numbering".