News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) AR Rollforward : Journ...

Microsoft Dynamics GP (Archived)

AR Rollforward : Journal Entry transaction detail for selected GL accounts

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello all :

I am trying to get JE details for all transactions entered manually or via import for selected GL accounts.

We are not using the AR module (all transactions are imported via batches from a POS as well as manual JE's).

I understand this might come off the GL30000 table.

I would like a file that would look something like this

JE #.... Trans Date ... DR Acct ... CR acct ... DR amount ... CR amount

100.....01/15/2015....1000.................................500............................................

100.....01/15/2015...........................3000.......................................500...............

What tools can I use to get the file I am looking for

SmartList (I know I can pick an account range but it will yield an unmanageable size file)

SmartList Builder ..

SQL

Thanks,

Robert

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

MattPaulen 6,910 on at

Like (0)

Report

RE: AR Rollforward : Journal Entry transaction detail for selected GL accounts

SQL would probably be your best option. You could even create a data connection in Excel to pull this. The GL30000 will be journal entries for closed years. GL20000 will be for Open years.

Take a look at the following site for a good start of a view for the GL. You can always modify it to what you need.

victoriayudin.com/.../sql-view-for-all-posted-gl-transactions-in-dynamics-gp

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans