• From: Malaysia
  • Registered: 11/13/2014
  • Posts: 26

Topic: invoice - how do make invoicing number like this

FrontAccounting gurus,

I am having unresolved issues on the invoicing numbers as per below.

Assuming this month is Nov 2014, I would like to have it 1411-0001, 1411-0002, 1411-0003.... followed by December 2014, as 1412-0001, 1412-0002, so on...

How do i get around it?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: invoice - how do make invoicing number like this

This is not possible in FA.

/Joe

3 Reply by netracer (edited by netracer 11/13/2014 09:41:15 am)

  • From: Malaysia
  • Registered: 11/13/2014
  • Posts: 26

Re: invoice - how do make invoicing number like this

even by using javascript to read-off the current date (month/year) and concatenating them?
or can it be manually adjusted every month end to 0001/MMYY

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,185

Re: invoice - how do make invoicing number like this

yes, i hope its possible, you need to edit it with php date and invoices number table.

generally, invoice is an integer in the table and its auto incrementer. but you are requiring to use it as integer+character.
  a little struggle, but you can do it.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • tm
  • Senior Member
  • Offline
  • From: Sweden
  • Registered: 05/13/2013
  • Posts: 142

Re: invoice - how do make invoicing number like this

Adding a prefix should be simple enough. The tricky bit is to have the sequence reset for each new month. I guess it could be bolted on using a separate field in the database, but internally the documents would still have a plain sequence number.