Double figure for Elimination

[Former Member]

Hi all,

This is my detail explaination regarding this issue.

When I run balance carryforward for period 1/2008, figure for posting level 20 will carryforward.(RM27,441.0). This is IU figure from period 16/2007. But after I run task IU Elimination, the carryforward figure will display like double posting.(RM54,882.00)

i.e

C4000 15053100 C4400 00 RM 27,441.00 RM 27,441.00

C4000 15053100 C4400 00 RM 25,855.92 RM 25,855.92

C4000 15053100 C4400 20 E1 RM 0.00 RM 54,882.00

C4000 15053100 C4400 20 E1 RM 0.00 RM 25,855.92-

My method config for IU Task.

Use for selection 1 and 2 (Two sided elimination)

Consolidation Company [Our subsidiaries]

Item [FS Item]

Trading Partner [Our subsidiaries]

Posting Level [00-12]

Document Type

Posting Level - Two-sided Elimination Entry

Balance Check - Error when balance not equal to zero

Application - Other

Posting - Automatic Posting

Inversion - Automatic Inversion Also in New Fiscal Year

Hopefully all of you will help me to solve this issue...

Thanks you.

Azie

[Former Member]

Hi Dan,

Thanks for your answer, very helpful answer....anyway is it possible the figure for period 1/2008 with posting level 00 will display at posting period 000-000 2008 after I run all task as below.

1- I already upload the TB for period 01/2008 at cube.

2. Run all task include balance carry forward and IU Elimination for period 01/2008.

Thanks,

Azie

[dan_sullivan]

As long as the data is being loaded via BCS monitor (UCMON) tasks, there is no way to populate values in period 000 except for the balance carry forward task.

Some conversions have used direct load in BW which bypasses the BCS logic and control checks and allows data to load into period 000.

[Former Member]

Hi all,

I want to know, actually when I select posting period 00-00, the figure for posting level 20 will display or not before I run balance carryforward?..

Tq.

Azie

[dan_sullivan]

There should be no records for any posting level (00-30) in period 000-000 prior to the execution of the balance carryforward.

[Former Member]

Hi Azie,

First of all, you ought to understand if this possible double amounts came from the BCF or not.

If not, then I would thouroughly examine the entries of the I/C elimination task.

I met several times the situations when a wrong strategy of writing differences lead not to a elimination, but just to the opposite: the doubling of difference. For me it looks like very much as your situation.

[dan_sullivan]

To fix the problem include posting level 20 in the selections.

Unless there is some unusual situation, I typically exclude the posting levels completely in the configuration of eliminations, as well as companies and trading partners. The system is logical enough to determine the correct postings.