Go Back > Forum > Baan SIGs > Archiving & Multisite

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 85

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 24th March 2020, 14:15
jerrygjj jerrygjj is offline
Junior Member
Join Date: Dec 2017
Posts: 5
jerrygjj is on a distinguished road
Baan: FP7 - DB: SQL 2008 - OS: windows server 2008
Sales order and purchase order archive question at LN FP7
Baan: Infor ERP 10.1 (FP7)

Don't have any sales orders archive to tdsls400 ,tdsls401 in archive company, and purchase orders archive to tdpur400, tdpur401 in archive company. I have checked these order status are closed. and don't have any error information when via tdsls5201m000(archive SO session ) and tdpur5201m000(archive PO session) archive.

LN version is LN 6.1 FP7.
Reply With Quote
Old 24th March 2020, 15:40
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,844
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Archive company present ?

are these steps done ?
Creating an Archive Company
Number of archive companies
When you set up an archive company, various concepts and strategies are involved. 
You can have one archive company, which will be fed with data yearly, that is, the 
operational company will archive its data each year to the same archive company. 
Therefore, all data will be centrally stored. However, this concept has one 
major drawback: performance degradation. 
Due to the transfer of large amounts of data from the operational company 
to the archive company, over time, the archive company grows larger than the 
operational company. Therefore, you must make enough disk space 
available, which, in turn, significantly decreases the performance of the 
archive company as more data is archived.

The second concept of setting up an archive company implies the data 
of the operational company will be archived each year to 
a new archive company. Having one archive company for each archiving
period limits the size of the archive company, which, in turn, stabilizes 
the performance to access this data. You can easily store this archive 
company onto an external device for a longer period of time. At the end
of the archiving cycle the data will be cleared. With one archive company 
for each year, you can easily drop the entire company at 
once, whereas filtering the old data that can be removed from one 
large archive involves more investigation and takes more time.

Another point worth considering setting up the archive company is the 
strategy towards migration. If the operational company will be migrated 
in the future, the archive company must also be migrated. With this strategy, it is 
easier to migrate multiple smaller companies than one large archive company.

When you archive in LN, you must keep close watch on the company numbers (operational – archive).

The subsequent procedure for creating an archive company is valid for a standard, non-localized and non-customized ERP environment.
In the examples used throughout this document, companies 001 and 002 are operational companies; companies 901 and 902 are archive companies.
To perform the steps to create an archive company, you must be super user.
Reply With Quote
Sponsored Links
Old 25th March 2020, 01:04
jerrygjj jerrygjj is offline
Junior Member
Join Date: Dec 2017
Posts: 5
jerrygjj is on a distinguished road
Baan: FP7 - DB: SQL 2008 - OS: windows server 2008
Thank you for your information.

Yes , the archive company set up done. I can archive Production order, Warehouse order. Sales order and purchase order just archive some history data to archive company. but tdsls400,tdsls401,tdpur400,tdpur401 don't have any orders archive to archive company.
Reply With Quote
Old 27th March 2020, 03:08
jerrygjj jerrygjj is offline
Junior Member
Join Date: Dec 2017
Posts: 5
jerrygjj is on a distinguished road
Baan: FP7 - DB: SQL 2008 - OS: windows server 2008
"Archive/Delete Sales Order/Schedule History" (tdsls5201m000) just deletes the sales order history data at LN FP7 version. Sales order and Sales order line can't archive any data at LN FP7 version . Who can help me confirm is right or not? Thanks
Reply With Quote

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
Is it possible to Create Sales order or Purchase order through ION info_erp ION 1 6th January 2014 09:55
Generate Purchase Order advice from sales order SoerenH Distribution, Transportation & Warehousing 2 5th March 2012 11:46
Process question - linking purchase orders to sales or production Mick Andrus Distribution, Transportation & Warehousing 5 27th May 2010 10:24

All times are GMT +2. The time now is 13:09.

©2001-2018 - -