Does anybody have any half decent documentation for finance archiving in particular relation to transferring contents of 106 to history company.

I'm interested in doing this from a performance point of view but I also want to transfer the ledger balances into the history company so that I have the ledger balances with the transactional history behind it.

I think I need to run tfgld6206m000 and tfgld6205m000 followed by the sessions for removing fully paid invoices.

I'm talking to support re: patches and more info but if there's anybody out there who's done this some feedback would be useful.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

first run remove fully paid purchase invoices tfacp2250m000 and run remove fully paid sales invoices tfacp2260m000 the gld106 recordeds will not transfer if the reference exists in tfacp200 or tfacr200.

then run tfgld6205m000

I think it is better not to run tfgld6206m000 instead dump tables
tfgld201 202 203 204 205 206 import to archive company, you can then still see the old balances in the live company rather than moving them to the archive.

Also the setting in maintain group company parameters for store data for x years determines how many years of past data can be archived.

Hi Neal,

I strongly recommend that you have the latest Baan solutions loaded for Year-End. There is a general solution for this.

Are you sure that you want to remove the Sales invoices and Purchase invoices, and not to archive them?

Regards, Juli

Thanks for the feedback,

Yes Juli I do mean archive Sales / Purchase invoices as opposed to deleting them.

Good tip on dumping the tables Darren I really do need to see the balances in both companies and I believe that tfgld6206m000 removes the history from the original company. The only downside to this approach would be that these tables also contain data for years that isn't archived as yet.

I certainly intend getting the latest sols for these sessions from support before continuing.

Thanks again
Neal Matthews
Intier Automotive - IT Support Analyst

To clear the balances in the archive company that you do not want to see use GTM once you have imported them and delete the the balances for the non archived years.
Or setup an exchange export and import scheme and put a condition script on either export or import to ignore the ones you don't want.

Thanks Darren,

I think that certainly covers all the angles.

Regards
Neal Matthews
Intier Automotive

Don't forget to reconcile GRNI before you archive your Purchase Invoices.

Keith

Thanks Keith,

I'll certainly be talking to Finance before pushing the button.

Regards
Neal Matthews - Intier Automotive

Have you (Neal Matthews) implemented this procedure for archiving tfgld106?

Did it went well?

Could you please share your experience?

Thanks in advance,


Best Regards,
Antonio Domingues

Hello,

Yes I did successfully archive for tfgld106.

I think once I'd got the latest solutions and understood how the sessions worked it went very well.

Basically I just ran tfgld6206m000 followed by tfgld6205m000.

Off the top of my head the prerequisties for running these sessions were that the year in question had to be finally closed and I also adjusted the Store Data for x years parameter in the group company parameters to get the session to run.

These sessions are also the last ones I run in my archiving strategy as they stand a better chance of archiving the maximum amount of data.

If you require any further details please let me know.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Hello Neal,

Thank you very much for your quick reply.

Do you remember if you have archived Integration Transactions (tgld41X) before archiving tfgld106?

Thanks in advance.

Best Regards,
António Domingues

Yes I actually ran tfgld4210m000 twice.

On the first run I tranferred to history and then I ran the session from the history company to remove them.

On the second run I printed the report to a file.

I would suspect that it's not really necessary to run the session twice but I removed them to the history company and then waited for a couple of months before finally removing them.

Hope this helps.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Hi Neal,

Thank you very much, it was very kind of you.

Actually I'm looking for someone who had experienced archiving tfgld106 without having archived integration transactions before. I would like to know what's the real impact of that.

Best Regards,
Antonio Domingues