****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Financial\Current Period and YTD Cash Flow.rpt
****************************************************************************************************

-------------------------------------------------- Main Body --------------------------------------------------


SELECT 
	Journal_Entry.[Journal Entry Type ID]
	,Journal_Entry.Date
	,Journal_Entry.Amount
	,Journal_Entry.[Debit Or Credit]
	,Journal_Entry_Type.[Journal Entry Type]
FROM
	[Journal Entry Type] Journal_Entry_Type
		INNER JOIN [Journal Entry] Journal_Entry ON Journal_Entry_Type.[Journal Entry Type ID] = Journal_Entry.[Journal Entry Type ID]

SELECT 
	Account.[Account Number]
	,Account.[Account Type ID]
	,Account.[Account Class ID]
	,Account_Type.[Account Type]
	,Journal_Entry.[Journal Entry Type ID]
	,Journal_Entry.Date
	,Journal_Entry.Amount
	,Journal_Entry.[Debit Or Credit]
	,Account_Class.[Account Class]
	,Journal_Entry_Type.[Journal Entry Type]
FROM
	Account
		INNER JOIN [Account Type] Account_Type ON Account.[Account Type ID] = Account_Type.[Account Type ID]
		INNER JOIN [Journal Entry] Journal_Entry ON Account.[Account Number] = Journal_Entry.[Account Number]
		INNER JOIN [Account Class] Account_Class ON Account.[Account Class ID] = Account_Class.[Account Class ID]

-- Record Selection Criteria

WHERE
	Journal_Entry_Type.[Journal Entry Type] <> "closing entries" and
Journal_Entry.Date <= {?End Date}

-- Record Sorting

ORDER BY
	Account_Class.[Account Class] ASC -- Group #1
	,Account_Type.[Account Type] ASC -- Group #2