Open Forum

Auditors have requested a list of all journal entries and their descriptions.  Not detail just a list.

 We are running version 18.3.1245 with Smartlist Builder

------------------------------
Curtis Ramsey
VP Accounting
Goodwill Central FL
Orlando FL
------------------------------

We're running version 18.3.1173.  Using Account Transactions Journal/ History Financials* as a base report, you may add the columns desired.  Use the Search  to define your desired date range.  Below is an example of the report we use for our journal entry listing.  Hope this helps!

------------------------------
Lorraine Tutt
Guilford Technical Community College
Jamestown NC
------------------------------

Original Message:
Sent: Feb 27, 2023 02:39 PM
From: Curtis Ramsey
Subject: List of all journal entries for a year

Auditors have requested a list of all journal entries and their descriptions.  Not detail just a list.

 We are running version 18.3.1245 with Smartlist Builder

------------------------------
Curtis Ramsey
VP Accounting
Goodwill Central FL
Orlando FL
------------------------------

I use the smartlist - Financial > Account Transactions  Then search by source document equal to GJ

------------------------------
Teresa Waters
Controller
La Crosse Milling Company
Cochrane WI
------------------------------

Original Message:
Sent: Feb 27, 2023 02:39 PM
From: Curtis Ramsey
Subject: List of all journal entries for a year

Auditors have requested a list of all journal entries and their descriptions.  Not detail just a list.

 We are running version 18.3.1245 with Smartlist Builder

------------------------------
Curtis Ramsey
VP Accounting
Goodwill Central FL
Orlando FL
------------------------------

If it is very time consuming to use the Smartlist in GP, you can ask your DBA to extract it for you in Excel using SQL Query.

Here's the script: https://cecilegp.blogspot.com/2023/02/extract-journal-entries-for-auditors.html

------------------------------
Cecile Dinh
GPUG Leader - Washington, DC.
------------------------------

Original Message:
Sent: Feb 28, 2023 08:57 AM
From: Teresa Waters
Subject: List of all journal entries for a year

I use the smartlist - Financial > Account Transactions  Then search by source document equal to GJ

------------------------------
Teresa Waters
Controller
La Crosse Milling Company
Cochrane WI

Original Message:
Sent: Feb 27, 2023 02:39 PM
From: Curtis Ramsey
Subject: List of all journal entries for a year

Auditors have requested a list of all journal entries and their descriptions.  Not detail just a list.

 We are running version 18.3.1245 with Smartlist Builder

------------------------------
Curtis Ramsey
VP Accounting
Goodwill Central FL
Orlando FL
------------------------------

To get list of Journal Entries, their descriptions and with credit or debit amount, run this sql and copy to Excel.

select JRNENTRY,m.ACTNUMST,DSCRIPTN, DEBITAMT,CRDTAMNT from GL10001 g join GL00105 m on g.ACTINDX=m.ACTINDX
union
select JRNENTRY,m.ACTNUMST,DSCRIPTN, DEBITAMT,CRDTAMNT from GL20000 g join GL00105 m on g.ACTINDX=m.ACTINDX
order by JRNENTRY

------------------------------
dexteritydeveloper
dexteritydeveloper@gmail.com
https://keptonworking.blogspot.com/
------------------------------

Original Message:
Sent: Feb 27, 2023 02:39 PM
From: Curtis Ramsey
Subject: List of all journal entries for a year

Auditors have requested a list of all journal entries and their descriptions.  Not detail just a list.

 We are running version 18.3.1245 with Smartlist Builder

------------------------------
Curtis Ramsey
VP Accounting
Goodwill Central FL
Orlando FL
------------------------------