on 2016 May 05 4:25 AM
Hi Experts
As we known, elimination entries are generated by BPC consolidation monitor. Our clients want to view elimination and adjustment records in the form of financial document, like BPC journal document.
Because user can understand the financail document easily than simple audit report. Do anyone have this kind of experences ? Let user can know how the elimination and adjustment entries are generated, why need to be generated? thanks.
Regards
Ajdsmod
Request clarification before answering.
Dear DC,
Here is an old BPC MS document on eliminations. In principal elims work the same way in NW as it did back then.
To provide documentation, we usually set up a report that can be run after elims that show the ins\out and the posted amounts. Usually accounts are on the columns, entities and audittrail in the rows.
Hope this helps!
Akos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Normally BPC elimination works at group level. I mean You use a "TYPELIM" property in Account dimension and refer the same property while creating elimination rules.
So let say, you created following property:
| ACCTYPE | TYPELIM |
|---|---|
| INC | ICELIM1 |
| EXP | ICELIM2 |
You create elimination rule
| Source Account | Source Flow | Reverse Sign | Destination All | Destination group |
|---|---|---|---|---|
| ICELIM1 | ICELIM1 | ICPL | ||
| ICELIM2 | ICELIM2 | ICPL |
This is how the elimination rules are configured. If this is the case, then the gl :ICPL will show net of balance of all income and expense accounts.
To view the all intercompany gls & its elimination leg as separate entry, you will be required to use different Destination account for each such intercompany gls.
and then you can create report for your source account and destination group account. This report will serve the purpose of journal entry
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 17 | |
| 11 | |
| 9 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 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.