Facing Error in Fund Center Derivation

[khadim_ansaari]

Dear FM Experts,

As per the Management requirement we have created new cost center and fund center with code number 5010231. while posting accounting document through FB50 system showing the motioned below error

Funds center 010231 in FM area 5000 did not exist on key date 30.06.2020

Message no. F6556

There is a slight difference that we have cost centers with 6 digit number but new cost center is created with 7 digit number because of the sub department of already existed cost center.

i have also updated derivation rules but still system is not deriving the right fund center. Fund center number is 5010231 while system showing error by displaying fund center number 010231 instead of 5010231. I have attached all the relevant screen shots to understand the bug easily.

Please help me to sort out it.

[iklovski]

Hi,

As you can see in your trace for values before and after, the rule you have is not triggered. So, first, check the steps log in the derivation trace, and see if the condition is met (you can show the screenshot of this).

The point is that you seem to have two rules (4 and 😎 to derive fund centre from a cost centre, and I guess, that rule number 8 is not defined to overwrite the previous values, so you stay with the same value.

Regards,

Eli

[khadim_ansaari]

Hi Eli,

We have two types of derivation Strategies (fund center derive from cost center) defined in FMDERVIVE. One is "Assignment" and other is derivation rule. But i tested "assignment strategy" has priority over "rule strategy".

Actually i have found that problem is fall with the number length of cost center code. As i mentioned in my question that already we have cost center master data with 6 digit number length and now i created new cost with 7 digit number length (because new cost center is the sub department of the cost center we already have)

Assignment strategy source field is defined as "part of field contents" and character position is defined 4 and number of characters is 6.if I changed it to 3 and 7 then system derived the fund center but it gives error for other cost centers which have 6 digit number length because it added 0 as prefix. It takes 6 digit fund center as 0501023 instead of 501023

Please guide how I can handle derivation if we have cost centers with two types of character length i,e 6 digit and 7 digit.

[iklovski · Accepted solution]

Hi,

That would have been my next question, whether in your rule you take the entire cost centre or only a part of it 🙂

Well, if you can't change this rule without damaging other logic, then your only option is to make the 'table' rule to overwrite the values of 'assignment' rule. Actually, I don't quite understand why would you have two rules, but since you do, consider to make the last one to have prevailing power.

Regards,

Eli

[khadim_ansaari]

Hi Eli,

Thanks for your guidance.

I have deleted 'Assignment' rule and just retain the lookup table derivation rules. it is working fine for both 6 and 7digits cost centers in FICO. Further, I have forwarded to our MM & HCM consultant to test this change in their modules for any integrated postings in FICO.

Please let me know one last thing to set look up table rule priority over assignment if i remain the both. I have tested table rules only works if there is no assignment rule.

Regards,

[iklovski]

If you flag the fund centre field in table rule as 'overwrite', and if it comes after assignment rule, then it should work

[khadim_ansaari]

Thanks Eli, it is working now.