Intercompany Matching Sign Values error

[Former Member]

Dear experts,

we are running the ICDATA logic for Interompany matching.

Below you can find my Input data:

Entity| Interco | Amount | Account |Datasrc

A | I_B | 30 | Asset1 | Input

B | I_A | 30 | Liability1 | Input

when the package runs, the following 4 lines are created:

Entity| Interco | Amount | Account |Datasrc

A | I_B | - 30 | Asset1 | Debit1

B | I_A | -30 | Asset1 | Debit2

B | I_A | 30 | Liability1 | Credit1

A | I_B | 30 | Liability1 | Credit2

My problem is that In the BW cube the amount posted for the Asset1 Account which has an Acctype AST has a negative value.

For this reason when i create the IC Matching report the same amount is displayed positive and the Total Debit1 + Debit2 does not equal to 0 but it is shown as 60.

It seems that since the system shows all AST and INC amounts with a negative sign in excel and my posted amount is negative in the cube then the system runs the logic (-30)x(-1) = 30 which produces a wrong result.

The How-to guide provides an example where all created debit and credit lines have a positive sign and not negative.

Has anyone ever came across this issue? When you run the ICDATA report how are your amounts posted in the BW cube?

We run BPC for NW SAPK-75004INCPMBPC

Thank tou in advance,

Best Regards,

Dimitrios

[esjewett]

I'm not quite following. Are these values you are showing the values in BW or the values shown in BPC?

Generally, INC and LEQ type accounts are displayed with the opposite sign (credits positive, debits negative) and EXP and AST type accounts are shown with the same sign as they are stored. If you have an AST type account with a negative value in BW, I would expect it to also show a negative value in BPC.

Ethan

[Former Member]

Hi Ethan and thank you for your answer.

The amounts i am showing are the ones posted in BW. You are correct that the INC accounts are showed in BPC with a reverse sign and since in my case they are negative in BW (-30) the excel shows them positive (30). This is exactly my problem because the intercompany matching does not zero up, but sums the two transactions to 60.

In my understanding the problem resigns in how the amount is posted to BW. I would not expect the system to post a negative value in my Datasource but a positive value (at least this is what the guide shows). If the values where all positive in BW then due to the ACCTYPE property my IC Matching would be correct.

What the ICDATA package did was to post to BW the correct amounts in the DEBIT CREDIT DataSrc but with a negative sign for all INC accounts. Is that logical?

I hope I made it clearer.

Best Regards,

Dimitrios

Edited by: Dimitrios Myronis on Dec 22, 2010 2:11 PM

[esjewett]

If these are all BW values, then I think your problem is that your starting position is out of balance. You show two debits - one debit of 30 on an Asset account and one debit of 30 on a Liability account. What does your total balance sheet show in BPC? I would expect to see a total of 60 on the balance sheet given these values - and what you want is a total of 0.

Ethan

[Former Member]

Problem solved.

The issue was that the two accounts used where not basemembers of the same Parent Account. It now became clear to me that although the reports show positive values the Calculated Parent Account reads the data from BW where the signs are correct so the difference of those is 0.

Thank you for your help, points awarded.

[esjewett]

Yup, that's correct - hierarchy aggregation in BPC uses the values on the database/cube, not the values shown in the report. I'm glad you figured out the issue!