on 07-24-2012 12:32 PM
Hi,
I need a complete copy of one consolidation group to another.
We want to do some manual postings at group level in the new/target consolidation group without afecting the actual/origin consolidation group.
My problem is in documents of posting level 30. How can I copy/upload them?
I considered create a new version to use the documents copy functionality from the workbench but not even here documents of posting level 30 are copied (I'm still in SEM 600 version and Bussiness function FIN_ACC_GROUP_CLOSE is not available).
It's seems that the only possible way is to use the flexible upload functionality but I've never used it before with documents upload, so I'm not 100% sure it will work.
If you have any idea please advise.
Thank you.
Célia Guerra
As far as I know the flexible upload should work. However, it may be possible to create a reclassification method and task for this.
For the reclassification the trigger is the cons group to be copied from, with the target being the new/source cons group. In cases similar to this I've created a dummy cons group which is a copy of the trigger cons group. This dummy cons group is used as the source cons group and is excluded from the cons group hierarchies.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Dan.
I managed to solve my problem with a reclassification task as per your suggestion.
I found detailed information here:
http://help.sap.com/saphelp_erp60_sp/helpdata/en/4b/767176286dd44fa828e7560d799124/content.htm
Regards
Hi Dan,
After all my problem is not solved yet.
I did the configuration as your suggestion:
"For the reclassification the trigger is the cons group to be copied from, with the target being the new/source cons group. In cases similar to this I've created a dummy cons group which is a copy of the trigger cons group. This dummy cons group is used as the source cons group and is excluded from the cons group hierarchies."
Trigger: cons.group A (cons group to be copied from)
Target: cons.group B (new cons.group.)
Source: cons.group C (copy from cons.group A; source)
But it didn't work. No documents were posted. When I run the task in the monitor I receive the message: "Processing is not necessary".
I think this is this constraint described in SAP documentation:
..." Similarly, you can select any consolidation group (that differs from the trigger) for the source and the target. Here, the following constraints apply:
http://help.sap.com/saphelp_erp60_sp/helpdata/en/4b/767176286dd44fa828e7560d799124/content.htm
But if I use the same cons.group in source and target, my problem won't be solved because posting level 30 will be posted debiting and crediting the same cons.group (in my example, cons.group B).
If you could help, I would apreciatte it.
Thanks in advance.
Célia Guerra
Because I haven't done it quite this way I was unaware of the constraint.
The only other option I can think of is the flexible upload. With the upload you can use posting level 00 for reported data, and/or posting levels 01, or 10 for documents instead of 30. This provides more flexibility for reporting.
Hi Dan,
Thank you again for your inputs.
I'm still trying to solve my issue with a reclassification task. According to SAP documentation it seems I should be able to do it, so I believe I'm doing something wrong... and I really want to avoid flexible upload.
I set up the new cons.group (B) as the source and the target cons.group and for items I'm using a dummy item in the target.
In this way all items will be posted against this dummy item:
cons.group.B - cons.unit X - item 123 - 1.000
cons.group.B - cons.unit X - item dummy 1.000
...
cons.group.B - cons.unit X - item 456 1.000
cons.group.B - cons.unit X - item dummy - 1.000
...
cons.group.B - cons.unit Y - item 123 - 2.000
cons.group.B - cons.unit Y - item dummy 2.000
...
etc
But now I'm getting error message nº UCD1011 - 'Balance sheet/income statement balance &1 &2'.
I've already maintained the clearing item "Clear consolidation unit" and I still get the error message.
Thanks in advance.
Célia Guerra
Hi Dan,
I already overcame the out-of-balance problem.
I set up four steps with different source items (BS + P&L + cash flow + statistic accounts) instead of just one step and it worked.
But now I have other issue to solve: debit balance accounts were credited and credit balance accounts were debited.
cons.group.B - cons.unit X - item 123 - 1.000
cons.group.B - cons.unit X - item dummy 1.000
...
cons.group.B - cons.unit X - item 456 1.000
cons.group.B - cons.unit X - item dummy - 1.000
...
cons.group.B - cons.unit Y - item 123 - 2.000
cons.group.B - cons.unit Y - item dummy 2.000
I have a BS and a P&L in my target cons. group (B) with the same items and amounts as my trigger cons.group (A) but with inverse debit and credit signs.
My conclusion is that this funcionality - Reclassification Across Consolidation Groups - is not for what I need...
If you have any suggestion, please share.
Thank you.
Célia Guerra
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.