****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Financial\Dynamic Full Year Actual - Forecast.rpt
****************************************************************************************************

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

-- Command(s)

Command_9

SELECT [Amount], [Account Number],[Month]
FROM [Monthly Account Budgets]
WHERE Year=Year({?End Date})

-- Query(s)

SELECT 
	Command_9.Amount
	,Command_9.[Account Number]
	,Command_9.Month
FROM
	Command_9

SELECT 
	Journal_Entry.[Journal Entry 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 Heading Number]
	,Account.[Account Type ID]
	,Account.[Account Name]
	,Account_Type.[Account Type]
	,Journal_Entry.[Journal Entry ID]
	,Journal_Entry.Date
	,Journal_Entry.Amount
	,Journal_Entry.[Debit Or Credit]
	,Command_9.Amount
	,Command_9.[Account Number]
	,Command_9.Month
	,Account_Heading.[Account Heading Name]
	,Journal_Entry_Type.[Journal Entry Type]
FROM
	Command_9
		INNER JOIN Account ON Command_9.[Account Number] = Account.[Account Number]
		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 Heading] Account_Heading ON Account.[Account Heading Number] = Account_Heading.[Account Heading Number]

-- Record Selection Criteria

WHERE
	Account_Type.[Account Type] in ("Revenue", "Expense") and
Journal_Entry_Type.[Journal Entry Type] <> "closing entries" and
Journal_Entry.Date <= dateserial(year({?End Date}),12,31) and
Journal_Entry.Date >= dateserial(year({?End Date}),1,1)

-- Record Sorting

ORDER BY
	Account_Type.[Account Type] -- Original Order Group #1
	,Account_Heading.[Account Heading Name] ASC -- Group #2
	,Account.[Account Name] ASC -- Group #3
	,Journal_Entry.[Journal Entry ID] ASC -- Group #4