Skip to main content

Notifications

Announcements

No record found.

Finance forum
Answered

GL details

Posted on by Microsoft Employee

Hello everyone,

Is there a way to pull all GL entries (with journal number, accounts, description, posted by, approved by) for a time frame? Any advice is greatly appreciated.

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL details

    I got the question solved by using voucher transactions. Thank you all.

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,740 on at
    RE: GL details

    Hi larkyang,

    You can get your desired details from 02 inquiry screens as follows:

    1. General Ledger >> Inquiries and reports >> Accounting Source Explorer

    2. General Ledger >> Inquiries and reports >> Voucher transaction

    Right Click on grid, You can add columns you want.

    5270.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL details

    Hi André, thank you for your reply. There are two standard reports that I want to combine, e.g. voucher transaction report has journal entry details, but not the creator and approver info. The journal batch report has batch information (such as creator and approver), but it is at batch level, which could not be directly indexed to voucher transaction report. Is there a way to pull a journal entry data table to have all GL attributes?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL details

    Thank you, Gunjan!

    I have tried Voucher transactions, but how can I add other parameters, such as entry creator, approver details into the default report?

    Appreciate your help!

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: GL details

    Hi,

    If you are trying to see all the posted entries, you can try the Voucher transactions under General ledger > Inquiries and reports.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,835 Super User on at
    RE: GL details

    Hi Larkyang,

    Can you tell what exactly you want to achieve? What do you mean with pull all GL entries? Do you e.g. want to export it to another database, make a selection on a report or have the details available in Excel?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans