This question has been flagged

Hello,

In the accounting->under the invoices i want to edit the invoice sequence format. After lot of effort i figured that the sequencing happens in account.py file under the account add on. I think sequencing happens in the function _get_sequence_prefix but the problem is that i have played around with this method but there was no change in the invoice format.

Existing code

def _get_sequence_prefix(self, code, refund=False):
prefix = code.upper()
if refund:
prefix = 'R' + prefix
return prefix + '/%(range_year)s/'

Edited code

def _get_sequence_prefix(self, code, refund=False):
prefix = code.upper()
if refund:
prefix = 'R' + prefix
return prefix + '/TEST/%(range_year)s/'

after this edit in the code i was expecting the upcoming invoice numbers to contain test in them but that didn't happen. why ? If i'm wrong in where the invoice number is being generated, please do point me out at the right direction. Thank you

P.S: I did upgrade the invoicing module.

Avatar
Discard
Author

I know I can do this using UI but i'm interested in code level changes of the invoice sequence format

Author Best Answer

I have changed the sequence from back-end using an update command in postgresql, still have to figure out where and how to change this using python/xml code.

Avatar
Discard
Best Answer

You can change it using a function in  XML  and  define  that  function  in  python,  and  add  a  update  query  to  make  no  update  =  false.

Avatar
Discard