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:
Closing Balance 3,000
What it should show is as follows:
Balance B/D 2,000
Closing Balance 5,000
Please guide me on how to cater the above scenario