• alpha
  • New member
  • Offline
  • Registered: 01/04/2010
  • Posts: 3

Topic: Starting Sales Invoice Number

I am new to FrontAccounting and wanted to know if I can start issuing Sales Invoice Numbers in sequence to existing Invoice Numbers (say 11231 is the last Invoice Number used and wanted to issue Sales Invoice Number 11232 next using FrontAccounting)

Same question regarding Purchase Order Numbers as well.

Thank You

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

Re: Starting Sales Invoice Number

The easiest way is to use the Reference number field as your invoice number. The next reference number for your invoice is set in Setup tab, Forms setup.

/Joe

  • alpha
  • New member
  • Offline
  • Registered: 01/04/2010
  • Posts: 3

Re: Starting Sales Invoice Number

I saw the option to use the reference number, wanted to know if I could set/change the next Invoice Number itself.

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

Re: Starting Sales Invoice Number

Yes, you can. By using phpMyAdmin go to your database and company (table prefs). Enter debtor_trans and find your last transactions with type 10 (Invoice). You will probably find your last numbers here. Change these to follow your new number serie.
Remember to change these numbers also in table debtor_trans_details.
When FA is finding the next Invoice number it will take the MAX number + 1.

/Joe

  • alpha
  • New member
  • Offline
  • Registered: 01/04/2010
  • Posts: 3

Re: Starting Sales Invoice Number

Thanks for the quick reply, that's what i needed.