web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to get single entr...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to get single entry from General Journal Account Entry table when joining with CustTeans using Vouchdr

(0) ShareShare
ReportReport
Posted on by Community Member

Hi 

I am trying to join the General Journal Account Entry with Custtrans using the Voucher field. 

Select T1.*, T2.*

GeneralJournalAccountEntry T1,  CustTrans T2 

Where T1.Voucher = T2.Voucher.

But I am getting a lot of nulls on the AR front (data from CustTrans) after joining. 

Could you please assist me with correct join. Also the possible reasons to the nulls.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    I would recommend taking a look at the transaction origin report in GL and how it is designed.

    It allows you combining vouchers and including subledger details.

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

    Hi Mahek,

    Next to the voucher, you also need to have a range on the posting date. Make sure you have an inner join as there are accounting entries not related to customer transactions.

  • Community Member Profile Picture
    Community Member on at

    Hi Calavon,

    Thank you, could you also help me with more details about which posting dates  can be considered. Should more focus be on Accounting Date/Document Date etc. from GJAE table or any posting dates from CustTrans table to select only Closed transactions.

    Or maybe, is there any field to identify customer transaction in the GeneralJournalAccountEntry among other transactions.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

    Hi Mahek,

    The table GeneralJournalEntry should be linked as well. This table has the AccountingDate field to be used for the link with the CustTrans table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 677 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 442 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 339 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans