Same range of document numbers for payment documents
I have the petty cash internal bank account that uses a payment document with document numbers from 0 to 9999 (last used is 799). The law says that begining 1st of january 2010 I have to start all over from 0 with the document numbers. I defined a new payment format and assign it to the petty cash bank account but when I enter the document numbers (0 to 9999) a message pops up saying that I "have already used this range of documents. re-enter."
How can I do this in Oracle and still be legally correct ?
Thank you.
Carmen