cancel
Showing results for 
Search instead for 
Did you mean: 

Project Settlement - Aggregating/Settling on new custom field

Former Member
0 Kudos

At our company, we created a new custom field called "Location Code" that is populated during journal entries through manual input. When an entry to a WBS element is posted with a Location Code value entered, the Location Code value also gets carried over to CO (controlling), SPL, and is in PS. The problem we have is with settlement as it does not carry over the Location Code at the final settlement receiver. For example:

1. Journal entry is posted to WBS element H01.12345.01.01 with Location Code value entered of "435" (this is a field in the FI document posting screen) for $100. Another entry is posted to the same WBS element but with a different Location Code of "080" for $200. Both entries to the same G/L account.

2. Settlement is run to settle the 2 entries in Step 1 above which totals ($200 + $100) $300. WBS element H01.12345.01.01 will settle to a cost center.

3. When we view the final accounting documents (especially our special ledger purpose documents), Location Code value is blank and there is one entry to the receiving cost center for $300. It seems project settlement aggregates entries based only on WBS level and G/L account.

QUESTION: Is it possible (and if so, how) to get projects to settle these lines individually based on aggregating on Location Code as well as G/L account? We would like to see $200 settle to the receiving cost center with Location Code value "435", and another line settling $100 to the receiving cost center with Location Code "080".

I hope I made sense. Thanks in advance!

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member203108
Active Contributor
0 Kudos

If you want to populate some custom field during settlement, then please open a message to SAP, they may guide on this.

NathanGenez
Active Contributor
0 Kudos

Have you looked at CJIC and doing this manually?

[-nathan genez|http://wiki.sdn.sap.com/wiki/display/profile/Nathan+Genez]

Former Member
0 Kudos

Hi Nathan. Thanks for your reply. The WBS element is not settling to a fixed asset. I'm not too familiar with this t-code, but will it work for settling to other cost objects?

NathanGenez
Active Contributor
0 Kudos

line item settlement should only be possible if the setting is maintained in the IM Profile and it sounds like your projects don't have an IM profile... so it shouldn't work. I haven't used it on a non-capital project but you could give it a shot.

[-nathan|http://wiki.sdn.sap.com/wiki/display/profile/Nathan+Genez]

NathanGenez
Active Contributor
0 Kudos

There might be some way to do this via a substitution... that's where I would look.

[-nathan|http://wiki.sdn.sap.com/wiki/display/profile/Nathan+Genez]

Former Member
0 Kudos

Thank you so much for your response and recommendations, Nathan. I really appreciate it. How would we make the setting in the IM profile to get line item settlement? Thanks again.

NathanGenez
Active Contributor
0 Kudos

IM profiles are configured at OITA. There is an option to choose from Summary vs. Line Item settlement. LI settlement is much better for asset reporting purposes.

[-nathan|http://wiki.sdn.sap.com/wiki/display/profile/Nathan+Genez]

former_member203108
Active Contributor
0 Kudos

Aileen, You use investment profile for capital investment projects, where you will use project to built an asset. Moreoever, line item settlement indicator in investment profile is applicable only if your WBS Element is an investment measure. But, I dont think this is not your case.