Linking GeneralJournalAccountEntry to VendTrans or LedgerJournalTrans D365 F&O Datalake

(0) Share

Report

Posted on by MD-27040941-1

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!

All responses (3)

Answers (0)

Sort by

CU27040932-0 2 on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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 = ' '
Ankit Life 689 on at

Like (0)

Report
Copy link

Link copied!

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