Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

(0) Share

Report

Posted on by Community member

Hi all,

For our reporting solution we would require to link a GeneralJournalAccountEntry to the Vendor involved.
However, this has proven to be quite difficult since there seems to be no way to uniquely link these GeneralJournalAccountEntry lines to tables like VendTrans or LedgerJournalTrans.
We have tried doing this based on the subledgerVoucher (GeneralJournalEntry), SubledgerVoucherDataAreaId (GeneralJournalEntry) and AccountingCurrencyAmount (GeneralJournalAccountEntry), but there are plenty of cases which have these values in common.
Would anyone know of a better way to link a GeneralJournalAccountEntry to the correct Vendor involved?

Thank you in advance!

I have the same question (0)

All responses (3)

Answers (0)

Community member 2 on at

Like (0)

Report

Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

Hi, I am trying to do the exact same thing, Did you ever find out how to do this?

Was this reply helpful? Yes No
Ainoa20 2 on at

Like (0)

Report

Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

Hello, did you try to make the relation in this way, the values always coincide in common:

SELECT * FROM [dbo].[GeneralJournalEntry]
Join [GeneralJournalAccountEntry]
at [GeneralJournalAccountEntry].GeneralJournalEntry = [GeneralJournalEntry].recid
where [GeneralJournalEntry].Documentdate = ' '

Was this reply helpful? Yes No
Ankit Life 681 on at

Like (0)

Report

Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

Hi Merjin,

Have you got the solution to this issue. I also have similar requirement, where i need to find vendor account generated from ledgergeneraltrans related to Sales tax posting. It might be possible that offset account is in other line. Is there a way to retrieve vendor account number from generaljournalaccountentry.

Regards,

Ankit

Was this reply helpful? Yes No

Join the conversation

Community site session details

Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates