News and Announcements icon

Dynamics 365 CommunityForums Business Central forum direct link between th...

Business Central forum

Suggested answer

direct link between the GL Entries table and the VAT Entries

(0) Share

Report

Report

Posted on by jaybeegee

119

Hi All

We are looking for a direct link between the GL Entries table and the VAT Entries - can anyone shed some light on this please? cheers Jay

Categories:

Financial Management

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: direct link between the GL Entries table and the VAT Entries

Jay,

Here is my GB country database example. I have the General Ledger Entries and VAT Ledger Entries and you can see the Document No. field links the GLE to VLE.

Thanks,

Steve
Suggested answer

JAngle 33,141 on at

Like (0)

Report

RE: direct link between the GL Entries table and the VAT Entries

“Transaction No.” is another possibility but it’s similar to “Document No.”. You will need to filter for the VAT gl accounts from the posting setup otherwise you get the other postings too
Suggested answer

Inge M. Bruvik 32,744 Moderator on at

Like (0)

Report

RE: direct link between the GL Entries table and the VAT Entries

I do not think there is a direct relations between the two table. I think you have to use the document no. from the G/L Entry to find the VAT entries that are connected to the document you want to investigate.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2

Martin Dráb 228,112 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans