Allocation Structure

[#1]

Dear Expert,

I’ve problem after run CJ88 the result show wrong GL.

the condition there is WBS Element create with sysem status REL AVAC STC , with settlement rule CAT G/L  with account 123456 as settlement receiver. I use Allocation structure for this scenario

The resul of CJ88 :

the correct jurnal should be :

1012000                52338020 (Dr)

5110098                52338020- (Cr)

Where does account 5110099 comes from ? how to check in allocation structure ? what meaning of Source and Settlement Cost Element in allocation structure ?

Thank you,

Iwan S

[Former Member]

Hi Iwan,

Settlement process is controlled via Settlement Profile. You can see Settlement Profile in your Project.

Settlement Profile (among other thing) controls which Settlement Cost Elements are used in settlement.

You can use different Settlement Cost Elements to settle different costs posted to WBS.

For example costs associated with materials consumed into WBS can settle with Settlement Cost Element XXXXXX and costs associated with labour consumed into WBS can settle with Settlement Cost Element YYYYYY.

You make this assignment in Allocation Structure (which is assigned) to Settlement Profile.

Source in Allocation Structure groups together 'input' costs and then you assign Settlement Cost Element with which they should be settled (credit to WBS).

So in your case you must have two assignments in your Allocation Structure using two Settlement Cost Elements: 5110098 and 5110099.

Regards,

Szymon

[Former Member]

Dear Szymon,

you correct I have several assignment in that allocation structure, how to find which assignment is use when settlement is running ?

In settlement profile was setting like this

Thank you,

Iwan S

[Former Member]

Hi Iwan,

In your case two assignments are active as there are two Settlement Cost Elements.

In other words Costs debited to WBS fall into Sources assigned to two assignments.

If you want to check please follow:

SPRO -> Project System -> Costs -> Automatic and Periodic Allocations -> Settlement -> Settlement Profile -> Create Allocation Structure

Select your Allocation Structure Z1. From menu select Extras -> Overview list

It'll allow you to analyse allocation structure.

Put your cursor on the name of allocation structure. Press Expand button.

Then use search for cost element  5110099 to find out which assignment uses it.

Regards,

Szymon

[Former Member]

Dear Szymon,

this the setting of allocation structure

Assignment 10

Source

Settle Cost Element

Assignment 30

Source

Settle Cost Element

need your advice.

Thank you,

Iwan S

[Former Member]

Hi Iwan,

Based on your screenshots I can say that both are used during settlement.

There must be costs posted to WBS in question with cost element 1012000 (looks like settlement from another object to this WBS) and they are settled with  5110098 and also other costs posted with elements belonging to cost element group ZPRIMCOST1 and they are settled with cost element  5110099.

You need to analyse costs posted to this WBS element.

Regards,

Szymon

[ajaycwa1981]

Hi Iwan

Check CJI3.. Are these GLs posted there?

Check in your allocation structure if "By cost element" is ticked.. If yes, settlement will credit each individual cost element

If you want to credit only one GL, then assign the same as "Settlement cost element" in Allocation structure

Source Cost Elements are mapped to a Settlement cost element in Allocation structure, so that instead of crediting original cost elemnts, you credit one single settlement cost element

Br. Ajay M

[Former Member]

Dear Ajay,

I check CJI3 yes GKs are posted there.

In allocation structure by cost element was untick in source I put cost element 1012000 and in settlement cost element I put cost element 5110098.

I know in settlement parameter of WBS there allocation structure was set as default, but which assignment was use for this allocation structure how can I find ? because in assignment I have several assignment, which one was use when settlement is run.

Thank you,

Iwan S

[ajaycwa1981]

Hi Iwan

Alloc Structures are always unique, each cost element can be assigned only once

Which assignment is used, - you need to find that out manually

Br Ajay M

[Former Member]

Dear Ajay,

pls check my setting allocation structure, need advie.

Thank you,

Iwan S

[ajaycwa1981]

Hi

The system is promptly Crediting the Cost elements 511/98 and 99. This is as defined by you in Allocation Structure, (Settlement cost element)

The Debit posting is what must be going to your settlement receiver

So, where is the issue?

Br. Ajay M

[Former Member]

Dear Ajay ,

the issue is why in doc accounting after settlement running GL 511/99 has value ? where is it come from the value ?

Since the value only for GL 511/98 not 511/99.

Thank yous,

Iwan S

[Former Member]

Hi Iwan,

Please send a screen shot of actual cost report for WBS in question.

Regards,

Szymon