{$page}

Create a view within SQL that can show (only) the manual Journal Entries from Control

This page will walk you step by step through generating a view and or an export from SQL that shows only manual Journal Entries from Control.

1. Go to the setup tab and enter reporting setup menu

1. In reporting setup chose “Reports On Main Menu”

1. Within “Reports On Main Menu” choose the sub-category of “User Reports”

1. Hit the add button at the top and choose new SQL Report

1. For menu item name you can name it “Manually Entered Gl Journal Entries Report”

1. Choose SQL and enter the query below into the box

1. In the options box choose create view and save

1. Now save your report

code_formatsql

declare @StartDate datetime;

declare @EndDate datetime;

set @StartDate =

set @EndDate =

SELECT Employee.FirstName +' '+ Employee.LastName as Employee,

         Journal.CompletedDateTime AS JournalDate,

         Journal.Description AS Description,

         GLAccount.AccountName,

         Ledger.Amount,

         Ledger.EntryDateTime as GLDate,

         TransHeader.OrderNumber,

         Ledger.JournalID

FROM Ledger

LEFT JOIN GLAccount on GLAccount.ID = Ledger.GLAccountID

LEFT JOIN Journal ON Journal.ID = Ledger.JournalID

LEFT JOIN Employee ON Journal.EmployeeID = Employee.ID

LEFT JOIN TransHeader ON Journal.TransactionID = TransHeader.ID

where Journal.ClassTypeID = 20035

and EntryDateTime between @StartDate and @EndDate

order by JournalID desc

code

Contributor: Jeremy, Cyrious Software

Date: 9/2011

Version: Control 4.0+

• Backlinks include_pagepage_componentbacklinks