Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Archiving & Multisite

User login

Frontpage Sponsor

Main

Google search


Poll
What version of Baan have you installed
Baan IV
30%
FP3
3%
FP4
0%
FP5
1%
FP6
2%
FP7
4%
10.2 (incl. 10.2.1)
3%
10.3
6%
10.4
18%
10.5
29%
Other
2%
Total votes: 93

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 20th November 2008, 16:39
bmorris's Avatar
bmorris bmorris is offline
Junior Member
 
Join Date: Jul 2003
Location: UK, London
Posts: 8
bmorris is on a distinguished road
Baan: BaanIV - DB: Informix, Oracel - OS: XP
Best way to remove sales orders? Archive or Copy Company?

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
Reply With Quote
  #2  
Old 5th December 2008, 16:09
a_choudhury's Avatar
a_choudhury a_choudhury is offline
Junior Member
 
Join Date: Aug 2006
Location: United Kingdom
Posts: 28
a_choudhury is on a distinguished road
Baan: BAAN C4 - DB: INFORMIX - OS: WINDOWS 2003
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,
Reply With Quote
Sponsored Links
  #3  
Old 5th December 2008, 16:41
bmorris's Avatar
bmorris bmorris is offline
Junior Member
 
Join Date: Jul 2003
Location: UK, London
Posts: 8
bmorris is on a distinguished road
Baan: BaanIV - DB: Informix, Oracel - OS: XP
I assume from your answer that your company has the latest porting set ?

I assume from your answer that your company has the latest porting set ?

Our company did not update the porting set since 2001 ?
Reply With Quote
  #4  
Old 8th December 2008, 16:04
Darren Phillips's Avatar
Darren Phillips Darren Phillips is offline
Guru
 
Join Date: Aug 2001
Location: west wales, UK
Posts: 334
Darren Phillips is on a distinguished road
Baan: IV4c4 SCH1 SP14 /AGS2 - DB: SQL7/sql2000/Oracle 9 - OS: NT4 Enterprise / win2000/3
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).
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy company from 200 to 290. Error! simona Tools Development 7 28th March 2008 07:39
How to access Archive Company as a normal User BRADSJ DEM & Workflow 1 18th February 2006 13:26
Manipulating Sales Orders in LN6 ? Trisli AFS/DDC/OLE: Function servers 3 22nd October 2005 15:12
Archive set-up for Multi Fin/Multi Logistic julia0726 Archiving & Multisite 1 16th July 2004 13:20


All times are GMT +2. The time now is 21:31.


©2001-2017 - Baanboard.com - Baanforums.com