opening balance

[former_member182516]

Hi gurus,

Need info regarding how to calculate opening balance.

I'm having the fields Sales , adjustments and colelctions which i'm getting these values from debit/credit amount.

Now my requirement is i need to calculate opening balance and closing balance.

Closing bal = Sales -(adjustments+colections) - where i'm getting the closing balance but the issue is closing balance is becomming the opening balance for the same customer for next day.

now the closing balance calculation is changing

Closing bal = opening bal + sales -(adjustments+collections)

how to achive this opening bal.

regards

Prashanth K

[former_member182516]

not resolved

[former_member182516]

Hi Gurus,

in continuation to the above ...

I'm having the posting date field in my infoCube, now my question is how to get the posting date values with an offset of -1, this i tried writing a customer exit. its not working can any guide me in writing the abap code (customer exit).

so that i can get the opening bal = posting date-1*closing balance so that it will be displayed for the next days opening balance.

here i want to create a formula variable with replacement path customer exit to get the posting date with offset -1.

help me in getting the correct code.

regards

Prashath

Edited by: prashanthk on Jun 28, 2010 8:12 AM