====== {$page} ======



===== Explanation of SQL =====



This SQL is used to pull a summary of all GL changes for a given time period.  It can be cut and pasted as a SQL Report in the menus.



===== Risk of Data Corruption if Run Improperly =====

**None**. This is a selection query and no data is modified in the running of it.



==Parameters==
  * **Date Range**
    * Use - Enter the starting and ending dates for the report.
    * Type - DateTime
    * Recommended Default - Today



===== SQL =====



[[code_formatsql]]



select 



  Journal.ID as [Journal ID],



  Division.DivisionName as [Division Name],



  GL.EntryDateTime as [GL Date],



  JournalActivityText as [Journal Type], 



  Journal.Description as [Journal Description],



  GLAccount.AccountName as [Account Name],



  GL.Amount as [GL Amount],



  case when GL.Amount > 0 then GL.Amount else 0 end as [Debit],



  case when GL.Amount < 0 then -GL.Amount else 0 end as [Credit],



  GL.Description as [Line Description],



  TransHeader.OrderNumber as [Order Number],



  Account.CompanyName as [Company],



  GL.Reconciled as [Line Reconciled],



  GLAccount.GLClassTypeName as [GL Class Type Name],



  Journal.CompletedDateTime as [Journal Date],



  Journal.Notes as [Journal Notes],



  Journal.IsVoided as [Journal Voided],



  Journal.VoidedDateTime as [Voided Date],



  GL.ID as [GLID],  



  GL.GLAccountID as [GLAccountID],



  GL.AccountID as [AccountID],



  Division.ID as [DivisionID],



  GL.TransactionID as [TransHeaderID],



  GL.GLClassificationType as [GLClassificationTypeID]



  



from GL 



left join Journal on Journal.ID = GL.JournalID



left join GLAccount on GL.GLAccountID = GLAccount.ID



left join Account on Account.ID = GL.AccountID



left join TransHeader on TransHeader.ID = GL.TransactionID



left join EmployeeGroup Division on Division.ID = GL.DivisionID



where GL.EntryDateTime between  and 



order by [Division Name], [GL Date] desc, JournalID, GLClassificationTypeID, [Account Name]



[[code]]



===== Version Information =====
  * Entered : 8/20/2009
  * Version : 4.3+



===== Related SQLs =====
  * Backlinks [[include_pagepage_componentbacklinks]]