Linking A/P and the G/L

(0) Share

Report

Posted on by john.ellis

3,480

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

Categories:

Reports and Business Intelligence

All responses (6)

Answers (1)

john.ellis 3,480 on at

Like (1)

Report

RE: Linking A/P and the G/L

@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
john.ellis 3,480 on at

Like (0)

Report

RE: Linking A/P and the G/L

yes, as well as the vendor ledger entries.
Alfredo_Iorio 1,260 on at

Like (0)

Report

RE: Linking A/P and the G/L

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?
john.ellis 3,480 on at

Like (0)

Report

RE: Linking A/P and the G/L

Hi Inge:

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

John
Verified answer

YUN ZHU 70,116 Super User 2024 Season 2 on at

Like (1)

Report

RE: Linking A/P and the G/L

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
Suggested answer

Inge M. Bruvik 32,744 Moderator on at

Like (1)

Report

RE: Linking A/P and the G/L

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.