if the year 2017 is not closed yet, how do I get a Report on All Journal Entries Posted in a Specific Year?
Either a Smart List or SQL Query help would be appreciated.
*This post is locked for comments
Thanks, but I was not looking for a Trial Balance report.
I did find the following SQL from Victoria's blog, not sure if will generate data for all posted Journal Entries, please take a look and let me know.
select
YEAR1 Trx_Year,
TRXDATE Trx_Date,
JRNENTRY Journal_Entry,
ORTRXSRC Originating_TRX_Source,
REFRENCE Reference,
ORMSTRID Originating_Master_ID,
ORMSTRNM Originating_Master_Name,
ORDOCNUM Originating_Doc_Number,
DEBITAMT Debit_Amount,
CRDTAMNT Credit_Amount,
ACTNUMST Account_Number,
ACTDESCR Account_Description,
ACCATDSC Account_Category,
CURNCYID Currency_ID,
USWHPSTD User_Who_Posted
from
(select ACTINDX, OPENYEAR YEAR1, TRXDATE, JRNENTRY, ORTRXSRC,
REFRENCE, ORDOCNUM, ORMSTRID, ORMSTRNM, DEBITAMT,
CRDTAMNT, CURNCYID, USWHPSTD
from GL20000
where SOURCDOC not in ('BBF','P/L') and VOIDED = 0 AND OPENYEAR=2017
union all
select ACTINDX, HSTYEAR YEAR1, TRXDATE, JRNENTRY, ORTRXSRC,
REFRENCE, ORDOCNUM, ORMSTRID, ORMSTRNM, DEBITAMT,
CRDTAMNT, CURNCYID, USWHPSTD
from GL30000
where SOURCDOC not in ('BBF','P/L') and VOIDED = 0) GL
inner join GL00105 GM
on GL.ACTINDX = GM.ACTINDX
inner join GL00100 GA
on GL.ACTINDX = GA.ACTINDX
inner join GL00102 C
on GA.ACCATNUM= C.ACCATNUM
Financial > Reports > Financial > Trial Balance. You will then choose whether the year is an open year, historical, or for the current.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
