Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Enterprise Edition Forum

Thread Tools Rate Thread Display Modes
Old 12-08-2016, 09:58 AM
BamaDon BamaDon is offline
Registered User
Join Date: Dec 2016
Posts: 1
Table where do the GL entries reside?

Hello all,

I have been tasked with retrieving this data in a custom report. I am looking at the JournalEntryLine table. When I pull everything in FY2016, I get 29 million in debit/credit totals. However when I run a Transaction Detail by Account from Quickbooks, I get a completely different number - as in 163 million - for credit/debit totals.

Am I looking at the wrong table? What else should I look at?

Quickbooks Enterprise 14 by the way

Last edited by BamaDon; 12-08-2016 at 10:13 AM.
Reply With Quote
Old 12-11-2016, 11:11 AM
Lorin Browning Lorin Browning is offline
Registered User
Join Date: Apr 2004
Location: Landrum SC
Posts: 656
I am not sure I understand just what the problem is.

The are multiple sources for General Ledger data, with General Journal entries being just one source. Because a relatively small percent of the General Ledger content normally come from General Journal entries, it is not surprising that the journal entries gives 29 million which is a subset of the 163 million.
Lorin Browning, Ph. D.
Fellow -- National Tax Practice Institute
Reply With Quote

Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump

All times are GMT -5. The time now is 01:10 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.