Hi,

We want to delete all the Integration records of year 2002
from tfgld410 ,tfgld417, tfgld418
Can someone please enlighten me in which contditions we may delete this records.

Thanks

Caner

Have you looked into using the archive session for these tables tfgld4210m000

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Caner,

if PCS is used, you may not delete the integration records that are project specific, unless the project is closed (They are needed for project cost calculation).

I could imagine the same holds true for unclosed standard production orders - there are some postings (surcharge results) that probably are generated during closing of the order by looking into the integration table. But I'm not sure about this, you should test that out.
Last point: I don't know how archiving reacts if there are no integration records, but I do not think there is a problem with it. Archiving should be able to handle eg. sales orders without integration records.

Keeping these points in mind, deleting
integration records is possible.

http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6960