bmorris
20th November 2008, 16:39
Hello To all, This questions is aimed at the experience Baan users
I have a question, after 8 years of use of BaanIVc4 we are going to run out soon of sales orders.
We will have to delete old sales orders,
But we want to save the old orders, there is a discussion here what is preferred to use archiving, which would require us to upgrade porting set and its been a log time since any corrections where installed on the system.

OR copy the entire company into a different company / server and then (after testing) delete all orders

OR Copy all tables in to an Oracle server and access all tables using Crystal reports Or Cognos or Oracle reporting tools

And after we are confident (and test the delete process) that there are no problem remove all the old sales orders, we will be glad to do that


So what would you recommend?
By the way upgrading to Baan 5 or 6 is not an option

a_choudhury
5th December 2008, 16:09
Hi,

The best way ofcourse is archiving which helps in reducing the integration transactions of fianance. We faced the same problem couple of years ago, we started archiving and also enlarged the sales order number from 6 to 7.

Regards,

bmorris
5th December 2008, 16:41
I assume from your answer that your company has the latest porting set ?

Our company did not update the porting set since 2001 ?

Darren Phillips
8th December 2008, 16:04
the first archive company I setup was in 2000 so you should be able to setup an archive company. Back then there wasn't an option to archive sales orders. You could only delete them, so to get round it I did an exchange scheme that dumped all the completed sales orders from the system and another scheme to loaded them to the archive company and then deleted them from the live company. I also printed all the the sales orders to PDF documents ( did it in blocks of a thousand).