Issue with JVA cube 0Credit value

[Former Member]

Hello BI experts,

We have a new requireent to create a JVA cube. This JVA cube JVAC01 does not treat credit postings the same way as other FI cubes. The KF 0CREDIT is loaded with negative values whereas 0FIGL_C10 loads as positive values.

This means that the Net Debit Credit key figure comes out with wrong numbers. Eg in FI 0debit 100 0credit 25 shows net dr cr as 100 u2013 25 = 75 but in JvA 0debit 100 0credit -25 shows net drcr as 100 - - 25 = 125.

Please let me know your thoughts.

Regards,

Naidu

[Former Member]

Hi,

Multiply the credit with -1 while loading to the JVA cube. This should solve the issue.

Regards,

Shyam.