DSO Keys with numerous amounts

[Former Member]

Hi All

I have a DSO with 5 Keys.

ID

partner ID

Day

Cost Type

Cost Code

On two of my rows i have the exact same keys but different amounts.

ID--

---

Partner ID

---

Day

---

Cost Type

---

Cost Code--

---

Amount

1--

---

B

---

01.01.2009

---

B

---

200150--

---

75000

1--

---

B

---

01.01.2009

---

B

---

200150--

---

25000

When loading from PSA to DSO it takes the last row amount (25000) and doesn't add them together even though it is set to SUM in the key figure.

How do i get it to summarise (give me 100000) the duplicate key amounts?

I do not think this will happen in reality but if i can solve this it would be good anyway.

Regards

[Former Member · Accepted solution]

hi Andrew,

it is not clear where you have set the setting SUM.

In the key-figure or in the transfer rules/transformation.

It must be set in the transfer rules/transformation.

[Former Member · Accepted solution]

ha ha what an idiot i am...cant beleive i didn't check there.

Many thanks Udo for that its baffled me for two hours before you poited out the obvious

THANK YOU