mig28mx
25th July 2006, 20:43
Hello all,
Our series for sales offers, is almost full.
How can I re-use the oldest series numbers?
Is enough to initialize the first free number to 0?
Is there other implications to observe?
thank you in advance.
Jan Ruppert
26th July 2006, 10:33
You can set the first free number to whatever you want and Baan will use the next free number which is not in tdsls001 "Sales Offers" or tdsls010 "Sales Offers History".
Thus you need to copy unneeded data to a disk and delete them in the following tables
tdsls001 Sales Offers
tdsls002 Sales Offers Lines
tdsls010 Sales Offers History
tdsls011 Sales Offers History Lines
Then these records can be reused. The only problem is that the reference in the sales order lines tdsls041.qono (sales offer) and tdsls041.qpon (sales offer line) refer to a non existing sales offer.
Yours
Jan (jan.ruppert@web.de)
mig28mx
26th July 2006, 17:46
Thank you very much, Jan.
I will do that.
This procedure apply also for sales orders?
I mean, if I reutilize the old sales orders numbers, there will be a problem on finance, like duplicate values or somelike that?
Thank you in advance.