News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... direct link between th...

Small and medium business | Business Central, N...

Suggested answer

direct link between the GL Entries table and the VAT Entries

(0) Share

Report

Report

Posted on by jaybeegee

135

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

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,159 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,748 Super User 2024 Season 1 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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans