Skip to Content

opening balance

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 28, 2010 at 06:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2010 at 08:44 AM

    not resolved

    Add comment
    10|10000 characters needed characters exceeded