Linking A/P and the G/L

(0) Share

Report

Posted on by john.ellis

3,510

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)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

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,510 on at

Like (1)

Report

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,262 on at

Like (1)

Report

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,510 on at

Like (1)

Report

yes, as well as the vendor ledger entries.

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

Like (2)

Report

@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