Our system was originally set up with a number of shared finance tables and a group payments company.

We no longer have a group payments company and make payments from two individual companies after unsharing the payment tables.

As the two companies are becoming totally seperate entities they have asked the question about having seperate tfgld008 (chart of accounts) tables.

Is this as simple as creating another copy of the table and breaking the shared link or are there other tables I need to seperate at this point.

Has anybody done this sort of exercise before with gld008 ?

Cheers
Neal Matthews
Intier Automotive - IT Support Analyst

Neal,

My answer is based on a recollection is that you're on Baan IV.

I haven't actually made that change but I think it should be one of the easier decentralizing tasks, assuming that you start by simply copying the existing table before deleting the logical link.

Beyond tfgld008, look at all of your logical tables. I think it is safe to say that any table that references a ledger account -- whether in tf or another package -- will also need to be unique by company unless the table row also includes the company number. For example I'm sure you will also need to "separate" tfgld009 (Dimension Ranges by Ledger Account), tfacp005 (Ledger Accounts by Supplier Group), tdinv850, tdsls070/71, etc. in a similar manner, if those are currently shared.

Since the request for separate ledgers was driven by business decision, you should probably question whether the actual dimension codes should also be unique, but that's from a business -- not a Baan -- functional perspective.

Obviously, you should try the change in your test environment before breaking the logical links in production. Hopefully someone else who has made the actual change can advise further.

Scott Johnson

Hi Scott,

Many thanks for the feedback.

You are correct in remembering that we are on IVc3 (I should really have put this in my post).

I have been reviewing my logical table setup and agree with the tables you have picked out. Your answer was certainly more comprehensive than the one that I got back from support.

I will now go back to support with this list before proceeding with the split exercise in my test environment.

Thanks again.

Neal Matthews
Intier Automotive - IT Support Analyst

I have just done the very same job last month and it is a simple as you think.

1. create sequential dump of file

2. unshare table

3. load dump to new company

I did this in a high volume company in the UK and have had heard of no problems to date.

Pleased to hear it.

Should be going for it shortly.

Thanks for the feedback.

Neal Matthews
Intier Automotive - IT Support Analyst