Skip to Content
0
Former Member
Mar 03, 2011 at 06:49 AM

Opening Balance of Customer

12 Views

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....