Opening Balance of Customer

[Former Member]

Dear FI Consultants,

My company's Fiscal Year is from July - June (V6). If I want to display report for Customer Balance, Vendor balance or GL Account Balance from a particular date (for eg from 05.09.2010 - 25.09.2010), it only shows the transactions that have incurred during this time frame and its sum. Although it should include and show the Opening Balance upto 04.09.2010 which is my Balance B/F and the transactional balance from 05.09.2010 to 25.09.2010 and the closing balance as at the 25.09.2010 which is my Balance C/F.

It shows as follows:

05.09.2010 10,000

06.09.2010 5,000

18.09.2010 -12,000

Closing Balance 3,000

What it should show is as follows:

Balance B/D 2,000

05.09.2010 10,000

06.09.2010 5,000

18.09.2010 -12,000

Closing Balance 5,000

Please guide me on how to cater the above scenario

Best Regards....

[atif_farooq]

Dear:

By doing so you are specifying the posting range date of the all transaction posted during that period. It will not get the Balance brought forward prior to the opening date you are giving. Only run time activities which ceated line items during the period you selected will be shown in the report.

Regards

[Former Member]

Dear Atif,

Is there any report in the standard system that will display the above requirement?

Best Regards...

[atif_farooq]

Dear:

Develop Z report for that purpose from ABAPER. We have the same report which you are requiring ABAPED.

Regards

[Former Member]

Dear All,

Thank you for your support.

Best Regards,

Anss Shahid Essani