Data Import - Naming Series

ERPNext User Forum
1
I've imported couple of Sales/Purchase Orders/Invoices from one system to another via .csv import.

Now when I try to create new Sales/Purchase Orders/Invoices, I get an error saying that SO-00001 already exists. Is there a way I can set this naming series/overcome this?

Thanks

Omkar

–

  1. Please be kind and don't send large attachments
  2. For issues, features requests use https://github.com/frappe/erpnext/issues

    —

    You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAOnj–LZe3RRGhDtvW-dvnjg7DCXKdzVoSVLz%3D9mGZqdj1cr4Q%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.
2
Hello Omkar,

You can change the starting or current sequence number of an existing series. 
Options available at Setup > Settings > Naming series > Select transaction sales order

---
Sunil
Partner for ERPNext 

On Friday, September 26, 2014 2:50:35 PM UTC+5:30, Omkar Ghatpande wrote:
I've imported couple of Sales/Purchase Orders/Invoices from one system to another via .csv import.

Now when I try to create new Sales/Purchase Orders/Invoices, I get an error saying that SO-00001 already exists. Is there a way I can set this naming series/overcome this?

Thanks

Omkar

–

  1. Please be kind and don't send large attachments
  2. For issues, features requests use https://github.com/frappe/erpnext/issues

    —

    You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/3f6a9854-37ab-41a2-95cf-0fc4e41d057d%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
3
Omkar,

When importing new invoices, you should keep name columns as blank. Value in the column should be entered only when you are over-writing existing records.

On Fri, Sep 26, 2014 at 2:50 PM, Omkar Ghatpande <om...@gmail.com> wrote:
I've imported couple of Sales/Purchase Orders/Invoices from one system to another via .csv import.

Now when I try to create new Sales/Purchase Orders/Invoices, I get an error saying that SO-00001 already exists. Is there a way I can set this naming series/overcome this?

Thanks

Omkar

–

  1. Please be kind and don't send large attachments
  2. For issues, features requests use https://github.com/frappe/erpnext/issues

    —

    You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAOnj–LZe3RRGhDtvW-dvnjg7DCXKdzVoSVLz%3D9mGZqdj1cr4Q%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.




–
Thanks and Regards,
Umair Sayyed
www.erpnext.com
1 Like
4

Thanks for the response Umair. I realized the same thing after posting.

Regards

Omkar

On 26-Sep-2014 4:57 pm, "Umair Sayyed" <um...@iwebnotes.com> wrote:
Omkar,

When importing new invoices, you should keep name columns as blank. Value in the column should be entered only when you are over-writing existing records.

On Fri, Sep 26, 2014 at 2:50 PM, Omkar Ghatpande <om...@gmail.com> wrote:
I've imported couple of Sales/Purchase Orders/Invoices from one system to another via .csv import.

Now when I try to create new Sales/Purchase Orders/Invoices, I get an error saying that SO-00001 already exists. Is there a way I can set this naming series/overcome this?

Thanks

Omkar

–

  1. Please be kind and don't send large attachments
  2. For issues, features requests use https://github.com/frappe/erpnext/issues

    —

    You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAOnj–LZe3RRGhDtvW-dvnjg7DCXKdzVoSVLz%3D9mGZqdj1cr4Q%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.




–
Thanks and Regards,
Umair Sayyed
www.erpnext.com

–

  1. Please be kind and don't send large attachments
  2. For issues, features requests use https://github.com/frappe/erpnext/issues

    —

    You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ33fAsYJkgMuQVWX%2BL3hTLXxFQG%2B%2BeP_RzWuM4BDakCMuEARQ%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.

–

  1. Please be kind and don't send large attachments
  2. For issues, features requests use https://github.com/frappe/erpnext/issues

    —

    You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAOnj–%2BmSj5MUNiDrqPnnCEQiQrsJBVV3TD%2B9NMz%2B-EPF%2BZHAg%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.