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: 43

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 28th December 2003, 07:20
noorulhaq's Avatar
noorulhaq noorulhaq is offline
Senior Member
Join Date: Jul 2002
Location: Sharjah, UAE
Posts: 147
noorulhaq is on a distinguished road
Baan: Infor 10 ERP LN, BaaN IV c 4, - DB: SQL Server 2008 SP2, SQL Server 2012 SP1 - OS: Windows 2008 R2 Sp1
Archive Inventory Transactions


We are trying to Archive Inventory Transaction by Item (tdinv7210m000) for a particular year. Total 85 % of the records have been archived and 15 % records still exist and it is not moved to archive company. Even Projects(pcs) & production orders relates these records are already archived.

we dont know why these records are not archived. I could not find any link. Please advise.
Reply With Quote
Old 29th December 2003, 09:12
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,853
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
transaction date and project status

The inv history may not be archived if the

1. Inventory transaction date > the date u specify on the form. or
2. Project status is not archieved.

Just check this .
Reply With Quote
Old 7th January 2004, 10:54
Badre Alam Badre Alam is offline
Join Date: Nov 2001
Location: New Delhi, India
Posts: 39
Badre Alam is on a distinguished road
Baan: BaaN IV c4 - DB: Informix - OS: Tru64 Unix
attaching an archiving notes related to archiving inventory history etc.. as we did the same 2 yrs back, the docs will explain which records will be archvived which not be, complete logic/reason of is mentioned.

Alam badre
Attached Files
File Type: zip archiving warehouse order series in (4.7 KB, 107 views)
Alam Badre
Unix/BaaN/Informix (Admn.)
Informix Certified Professional
Reply With Quote
Sponsored Links
Old 27th June 2011, 10:53
samsan samsan is offline
Join Date: Mar 2006
Location: France
Posts: 34
samsan is on a distinguished road
Baan: Baan IVc4 - DB: Informix 11.50 - OS: server HP-UX 11.31/client XP

This is an old post, but it describes well our problem.
As it's explained in the archiving documentation, the "tdinv7210m000" session archives inventory transactions comparing the transaction date (trdt) with the form parameter.

The "tdinv700" table is read sequentially for each item from the oldest transaction date to the newest, but once a transaction on a non-archived project is met, it jumps to the next item and doesn't analyse other transactions.

I don't understand the logic and it causes many problems in my company because we are re-using a production orders serie and it results in a melt of oldest and newest inventory transactions in the tdinv700.

Thank you in advance for sharing your experience on this session.

Best regards
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
Archive Inventory Adjustments cherokee Archiving & Multisite 1 13th February 2004 22:41
Significance of Enter Inventory Transactions manish700 Distribution, Transportation & Warehousing 1 27th May 2003 14:57
Inventory Transactions N. sriram Distribution, Transportation & Warehousing 2 14th April 2003 17:02
Back Order Qty. Not showing up on planned inventory transactions by customized item. ajitdon Distribution, Transportation & Warehousing 2 14th October 2002 15:44
How to restore History - Inventory Transactions by Location (tdilc301) baaniac Distribution, Transportation & Warehousing 3 7th March 2002 20:20

All times are GMT +2. The time now is 16:30.

©2001-2018 - -