Working with Baan4c

Problem: wrong ledger account being posted on PCS / COGS.
I am seeing certain Fin Customer Groups go into the wrong ledger. But then once in a while I will see the same Fin Customer Group with a different Item group go into correct ledger.

See attachment
The settings for the Integration are (PCS Projects tfgld4121m000)


1. Cost (pri-1) Project (general) Method by Ranges
2. Prod (pri-0) Fin Cust Grp PCS Proj - Cost Price Component by ranges
3. Div. (pri-0) Fin Cust Grp PCS Proj- Cost Price component by ranges

Problem: the ledger accounts are basically set up the same.
1 Cost Center Optional (same for both ledgers)
2. Product line =Optional (same Products in each)
3. Division =Optional (same division for both ledgers)
4 Project=optional (note this is optional in correct ledger)
but the wrong ledger it is going to it is set as =not used.

Not sure why These Customers are going into wrong ledger. The same financial Customer Group can go into either account. But the wrong ledger is used 90% of the time. But the wrong ledger is posting 90% of transactions. The Item's can be used in both ledgers.

Note: since the CP is posting into the wrong account we can't use session Tipcs8150m000 to fix. Since the components have already posted.

Thank you for your help
-Mark

I also noticed Same Financial Customer Group is posting into wrong ledger.

Wrong Ledger (531000)
Financial Customer Group Item Group
BTH F777
AER AK005
IDP F747
AER FGSC

Error No ledger or Cannot define ledger account
Financial Customer Group
BTH FGComps
BTH AK005


It looks like the component 400 with the same item posted ok. And this is a trend happening with all.

CP 100 Raw material is posting too wrong ledger

Hi,
I guess you should analyse the integration set-up in more detail:
- check set-up of tipcs8150m000 for combination of FCG, FSG, CPC, etc.
- the screen shot given by you for tfgld4121m000 is showing only for 3 dimensions (not for 4th dimension)???

Check for data errors. For e.g. FCG of customer may differ from FCG of the sales order / project.

Hello Mark,

if you don't mind, I will share my experience .
I have same situation with you when I report duty to new place.
Here , task list in order to help you find root cause and solution

1. Print active mapping scheme details with dimension
From here, you must have details ledger with dimension been setup.
You could classified based on your error finding

2. From here, you must extract information General Item which you have relation with Project. Normally, for project, it has separate item code to ease tracking

3. Match information and find the weird things

4. You may start seeing what's been wrongly setup, which transaction triggered the mapping , who did the process

5. You will find option for solution and open for discussion .

Thank you