sharma
10th September 2003, 02:34
Hi friends ,
We are archiving data in our company for some previous years.We are running sessions as .
1.tfacp2250m000
2.tfcmg3200m000
3.tfacr2260m000
4.tfgld6205m000
5.tfgld4210m00
6.tfgld4220m000
But after ending this when we checked the table tfgld106 , we find that all the records for the archived period are flaged only table field deleted with yes .Please suggest how we can remove this data.

Thanks

SS

Hitesh Shah
10th September 2003, 18:15
This is the case when these records pertain to open items (i.e. not fully paid) .

When these items become fully paid and u remove fully paid invoices , it will get deleted.

Karin Espelage
11th September 2003, 19:22
As Hitesh already said: most likely the balances in tfacr200 and tfacp200 are not zero. Note that in Baan 4 all balances have to be 0 in those two tables, including the balance in invoice currency and the "balance anticipated".

I sometimes find differences between the balances in home and invoice currency, due to rounding errors. I've developed a program that checks on all prerequisites for archiving (please find examples on www.maxsc.com if you're interested).

Karin Espelage