Hi Experts,
Issue
In ECC side ME23N, for particular PO number, summation of Invoice value in LC having both +ve and -ve values. Total is calculated accordingly.
Ex, for 3 invoices 10,20,-10 --> summation value is 20
In BI side, at cube I am getting correct value, but in report I am getting values as 10,20,10 --> summation value as 40.
I am not getting -ve sign in report and so when I display the total, all the values are summed up, but actual -ve values should be subtracted, this is not happening.
Please suggest me, what settings I need to check in Query to display -ve values which are there at cube level and get required output as summation value.
Thanks,
Saravanan.