Problem Statement:
ERPNext enforces automatic numbering series for invoices, which complicates importing or entering past invoices (e.g., from legacy systems). In my family businesses in Dubai, we often need to backfill historical data with custom numbers to match old records, but the system doesn’t allow manual overrides easily.
Proposed Feature:
Allow users to choose manual or custom numbering for invoices (Sales/Purchase) via a setting in Accounting > Numbering Series. Include an option to disable auto-generation and input a custom series/name directly in the form, with validation to prevent duplicates.
Benefits/Use Case:
This makes migrating data from old systems easier and supports businesses with non-standard numbering (e.g., prefixed by year or location). For instance, entering past wholesale invoices would be straightforward without workarounds like amending drafts.
Hi @NeerajL
This is not the case.
You can insert ID number as you like for any doctype import in excel template regardless of pre defined naming series for the same docytpe.
Further there are multiple options available to set naming series dynamically for each doctype along side manual document number as following;
In order to bring more advance logical naming, naming rule can serve the purpose.
quick question on this @ahsantareen
if let’s say I were to manually set an invoice number as HH-1001, would the next invoice I create automatically have HH-1002 or would I have to enter the full thing over again manually?
I’ve used this software called Vyapar before where the series you’d set would continue, but when you wanted to set a custom number for the invoice, you could.
hi, set as @ahsantareen adviced and use custom script to find the last number which will show there and you will be able change as per your need.
