on 07-27-2010 8:02 PM
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!
If you want to populate some custom field during settlement, then please open a message to SAP, they may guide on this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you looked at CJIC and doing this manually?
[-nathan genez|http://wiki.sdn.sap.com/wiki/display/profile/Nathan+Genez]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.