Naming Series - Using Customer Number in Quotation and Invoice Naming Series

Frappe Framework Customization
,
1

Hi,

Any idea how to generate naming series for quotation and invoice include custom field customer number (generate from customer number naming series like CUST-0001, but only use the number 0001 not include “CUST” prefix)?
example
QO-.customer_number.-.####.YY.MM.DD
INV-.customer_number.-.####.YY.MM.DD
I tried to use “customer” field but it give the whole customer name, it’s to long.

I am also planning to use the same format for buying (supplier number)

Thanks,
Thanks

2

Hi Ical

You can create new hidden field: customer_seri in Quotation, When choose customer you write custom script to update customer_seri too. Exam: choose CUST-001 → update customer_seri = 001

QO-.customer_number.-.####.YY.MM.DD
=>
QO-.customer_seri.-.####.YY.MM.DD

3

Hi vinh, thank you for replying my post. I will try it.
sorry for late reply

4

ERPNext new training vidoe uploaded https://youtu.be/sWgmAC7AeWw ERPNext Naming Series , How to insert Year, Month, Short Codes in Naming Series - ERPGulf Training