Skip to Content
author's profile photo
Former Member

Getting Opening & Closing Balance in Customer Ledger Report

Oct 06, 2007 at 12:04 PM | 3 Views

Hi Guys.

I am developing a report of Customer Ledger. There I have to display the Opening Balance & Closing balance of individual customers on m onthly basis.

I have date related objects

1. Fiscal Year/Period,

2. Fiscal Year Variant,

3. Posting Date,

4. Clearing Date and

5. Entry Date.

BW Business Explorer (SAP BEx)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 06, 2007 at 12:07 PM

    I am sorry for the above posting...

    Hi Guys.

    I am developing a report of Customer Ledger. There I have to display the Opening Balance & Closing balance of individual customers on m onthly basis from debit amout and .credit amount.

    I have date related objects

    1. Fiscal Year/Period,

    2. Fiscal Year Variant,

    3. Posting Date,

    4. Clearing Date and

    5. Entry Date.

    I have created a variable on posting date with "interval".

    Please let me know how to restict the keyfigures to get my report to display Opening & Closing Balance.

    ThanX in advance

    Peter

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2007 at 12:09 PM

    Hello Boggiti

    what is ur user input/selection variable...based on that you can calculcate month start thru customer exit and then put that customer exit variable on KF restricytion...

    Thanks

    Tripple k

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Oct 07, 2007 at 06:14 PM

      Peter,

      If you have a selection created which has Posting Period and the variable on this and your Key Figure for your Closing Stock, your Opening Stock should be the same selection with offsets set on the interval to give you the Closing Stock for the previous period.

      Closing Stock for the previous Period is the opening stock for the following one.

      Regards

      Gill