**************************************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Financial\Trial Balance.rpt **************************************************************************************************** -------------------------------------------------- Main Body -------------------------------------------------- SELECT Account.[Account Number] ,Account.[Account Type ID] ,Account.[Account Name] ,Account_Type.[Account Type] ,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] INNER JOIN Account ON Journal_Entry.[Account Number] = Account.[Account Number] INNER JOIN [Account Type] Account_Type ON Account.[Account Type ID] = Account_Type.[Account Type ID] WHERE Journal_Entry_Type.[Journal Entry Type] <> "closing entries" and Journal_Entry.Date <= {?End Date} and Journal_Entry.Date >= dateserial(year({?End Date}),1,1) ORDER BY Account_Type.[Account Type] -- Original Order Group #1 ,Account.[Account Name] ASC -- Group #2