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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Is there an easy or re...
Finance | Project Operations, Human Resources, ...
Answered

Is there an easy or recommended way to tie GeneralJournalAccountEntry records to their Originating Transactions?

(0) ShareShare
ReportReport
Posted on by VickyD

I am trying to tie the GenralJournalAccountEntry transactions back to the original transactions. While I've tried to start with individual modules e.g. Projects, Vendors etc, I'm wondering if there is a recommended or easy way to go about this as opposed to what I am doing. Wondering if there is already a pre-built entity or table that has all this data brought together. 

As an example, in the case below, I have 2 tables

1. Has some basic information from GeneralJournalAccountEntry and GeneralJournalEntry

2. Has similar information from ProjectTrans with the addition of the Project ID. 

I can visually see that the 3 GL transactions can be tied back to the Project Transactions based on Voucher and Cost Center ID below but I'm not certain if that is the ideal or correct way to tie these 2 datasets together.  

pastedimage1681303998635v1.png

Is there a better approach to this?

I have the same question (0)
  • VickyD Profile Picture
    VickyD on at

    The primary business requirement was just to be able to identify if any transactions that are actually project related have been posted directly to the cost center that the project is associated to instead of the project itself. These incorrect postings are basically causing cost center based reporting and project based reporting to not tie out.

    The above requirement is reasonably addressed through the posting type field itself so we are good. I just thought that there's a way to actually uniquely tie the 2 together that I just couldn't figure out, which is why I thought I'd ask here.

    Now that you've indicated that it is technically not supposed to be a unique link, I will stop pursuing that.

    Thanks a lot for your inputs.

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

    HI Vicky,

    Thanks for the clarification. The Cost Center ID might not be unique. In that case, you can again get many to many. In this case, there is no unique link. Can you tell about the business requirement? Maybe there is another solution direction possible.

  • VickyD Profile Picture
    VickyD on at

    In my example screenshot above, if I were to tie it based on just Voucher and Accounting Date, it will create a many to many join as all 3 GeneralJournalAccountEntry transactions will tie to all 3 Project Transactions given the voucher and date are the same on all 3.

    My hope is that I will be able to tie each GeneralJournalAccountEntry transaction that uniquely to one or more Project Transactions that in aggregate match the GeneralJournalAccountEntry transaction amount.  

    In my example above, adding the Cost Center ID to the linkage would help achieve that but I'm not 100% sure that is the right approach or not.

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

    Hi Vicky,

    On the voucher transaction form, which is using the GeneralJournalAccountEntry details, there is an option to view the origin. In most of the cases, you can link on the Voucher and Accounting Date/LedgerTransDate. Based on settings (summarize postings), the voucher might not always be filled on the GeneralJournalAccountEntry 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

News and Announcements

Season of Giving Solutions is Here!

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 December 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 843 Super User 2025 Season 2

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans