Description |
When Retained earnings Account is selected, the detail grid will show the balance per month/period based on selected date range.
Select datepart(mm,dtmDate),datepart(yyyy,dtmDate),SUM(dblDebit-dblCredit)
from tblGLSummary inner join tblGLAccount
on tblGLSummary.intAccountId=tblGLAccount.intAccountId
where tblGLAccount.strAccountId>'3000-000'
and dtmDate<'1/1/2015'
group by datepart(mm,dtmDate),datepart(yyyy,dtmDate)
order by datepart(yyyy,dtmDate),datepart(mm,dtmDate)
Assume that the fiscal year is setup on calandar basis
1/1 to 12/31
Data:
|Date|Type|Debit|Credit| |
|1/10/2014|Expense|10| | |
|2/20/2014|Revenue| |20| |
|1/1/2015|Expense|100| | |
|1/15/2015|Revenue| |200| |
| | | | | |
| | | | | |
| | | | | |
|From Date|To Date|Beginning Bal|Debits|Credit|Ending|
|01/01/1900|12/31/2015|0
|110|220|110 CR|
|1/1/2015|12/31/2015|10 CR|100|200|110 CR|
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
|