Frenchj
6th November 2003, 23:15
Hello,
We have started a new division. With this comes changing existing customers over to the new division. We went through this once before and had to create new customer account #'s in order to change the FCG. This causes confusion within our company as well as the customer. My question is:

Is there a way to change the Financial Customer Group on a customer without using GTM or creating a new acct.#?

Thanks,

James

baandude
7th November 2003, 04:40
Hello,

there may be a way rather than changing FCG also, for instance, how have you defined your dimensions, if it is by product line or dept, then simply add the new dept to the dimensions table.

Kindly provide more details of the finance / corp. layout., as i believe you may not have to remap the FCGs for the new division.

Thanks,

Frenchj
7th November 2003, 15:11
We are set up as Multi-Finance/Single Logistic. Each Finance Division uses different Ledger Accounts for A/R, Sales, etc. We use the FCG to map these accounts. That is why we need to change the FCG on a customer. The A/R is the most important.

Thanks,

Hitesh Shah
8th November 2003, 08:57
Following is my understanding . Correct me if wrong.

1.Table tccom010 is shared among all finance companies.
2.tfacr001 is shared .
3. tfacr005 is not shared between the finance companies.
4. tipcs850, tdinv850,tdsls070,tdsls071 and tcmcs036 are not shared .

If this be the case, there should be no need for u to change the customer financial groups because this setup will take care of differences with each division.

If ur setup is different , I recommend u to make it in conformity with what I described. This will allow u the flexibility u need in the long run.

It's not difficult to unshare tables which are shared . Take export , unshare it (ttaad4120m000), convert to run time , logout & login , import data in each company and it's done .

baandude
8th November 2003, 15:07
Hi James,

As you are setup as Multi Finance, I would advise you to start thinking of cases where you would need to add another division, after the current one. In such cases, Baan Finance config should be as straight forward as possible.

Yes, I also belive that tfacr005 is tied to the finance company, and tccom010 can be shared, however, there are fields in there for the Finance customer / or parent business partner for Finance, if you need to consolidate sales to a large customer.

Thus, best option is to revise the setup, where the AR control accounts in each Fin co, are consolidating to a parent AR account in the parent company, if you

Think of it this way, if you need further segmentation, I have advised clients to use dimensions like FCG, or product line, or division, to add the needed details in financial reporting.

Thanks

jroberts
10th November 2003, 22:41
If the control accounts for the from and to financial customer groups are the same, then it is safe to change the FCG. I would talk to baan support about this further.

The control accounts can be viewed from Maintain FCG, and then zoom out from there.

After exensive discussions with Baan support, I wrote a session that allows users to make this change, it validates the control accounts to ensure that they are the same between groups.

This is in a single finance - single logisitcs environment.

John

Frenchj
10th November 2003, 22:54
Jroberts -
We do change the G/L Accts. That is where our problem arises. Thanks