Customer Forum

reset object reference

External Posted: 2012-07-16 20:07

Hi there

I have created a few draft invoices and even opened an invoice then closed it.

I have noticed that each time this is done the object ref picks the next number in a sequence,

Is there anyway to reset and start again from #1 this as I want to duplicate existing records from setting my business up and I wouldlike the numbers to tally for accounting purposes.

Thanks

Adam

Workbooks Support Posted: Mon, 16.07.2012 - 21:16

Hello Adam

The short answer is that there isn't an easy way. This is so you can't reuse numbers - again, for accounting purposes! You can change sequence so it starts form a bigger number - e.g. start your invoices from 1001 and go from there.

Go to Start > Configuration > Database > Sequences and Numbering and set the next ID there.

James

External Posted: Tue, 17.07.2012 - 08:05

Thanks James

I appreciate that it is so you cant use the same numbers but it even sets a number when there is no draft i.e. before the record is complete? Surely you dont need to set a record number if the document doesnt exist?

Regards

Adam

Workbooks Support Posted: Wed, 01.08.2012 - 11:15

Hi Adam

You're right that the Object Reference is set as soon as you create the record but this is just the draft number - this will change to a different number when the transaction is marked as Complete and is given a status of POSTED. (It will take the next unused number in the sequence for POSTED documents.)