Linking A/P and the G/L

(0) Share

Report

Posted on by john.ellis

3,530

Hi:

I'm having trouble linking Business Central's Vendor Ledger Entry table to the Gen. Journal Posted Line table.

I'm able to "pull in" data from the Vendor Ledger but not the corresponding debits, credits, and General Ledger data.

I have linked these two tables, as best as I know how, based on Document Number, External Document Number, and Posted Date. I have tried other linkings, too, but no luck.

So, what am I missing in linking these two tables?

Thanks!

John

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

The entry no. is the link.

So the corresponding G/L Entry will have the same Entry no. as the Vendor ledger entry.

Then you can get the correct date and doc.no. to make a better filter.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 102,123 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, if you are talking about G/L Entry (17) table, I think your approach is fine, because the standard only uses "Posting Date" and "Document No.", However, there is a one-to-many situation as shown below, you need to take this into account.

And you can choose “Show Amounts” in General Ledger Setup to display Debit and Credit amount.

More details: https://yzhums.com/4985/

G/L Entry (17)

If you are talking about Posted Gen. Journal Line (181) table, as far as I know, you can only link Payments posted in General Journal, Invoice will not show up here.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
john.ellis 3,530 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Inge:

I can't find a corresponding Entry No. field in the Vendor Ledger table. What is it?

John

Was this reply helpful? Yes No
Alfredo_Iorio 1,268 on at

Like
a
(1)

Report
Copy link

Link copied!

The link is correct. Vendor ledger entry and G/L Entries can be linked through the document number and posting date.

As Yun says, there is a one-to-many relation that might conflict with your report. For example, if you try to get the total of the G/L entries starting from a Vendor ledger entry, you will always get 0 because the total G/L entried for the document posted will always wash.

What are you trying to achieve? Do you want to return a list of all the G/L entries?

Was this reply helpful? Yes No
john.ellis 3,530 on at

Like
a
(1)

Report
Copy link

Link copied!

yes, as well as the vendor ledger entries.

Was this reply helpful? Yes No
john.ellis 3,530 on at

Like
a
(2)

Report
Copy link

Link copied!

@YUN: Thank you! I was, indeed, using the wrong table! I should have been using G/L Entry.

I got it, now! Again, thanks!

John

Was this reply helpful? Yes No