GL linked to purchase invoices lines

(4) Share

Report

Posted on by CU04111701-0

123

Good evening to everyone,

I would like to know if there is a chance to link 1:1 the GL posting to the purchase invoice lines. So far as I know, the only join between invoices and general ledger is the invoice number (document number) but not on the specific lines of that document.

Is there a chance to identify which purchase invoice line is referring to a specific general ledger entry?

Document No (Invoice No.)	Invoice line	General Ledger Entry
INV-0001	10000	GL0001
INV-0001	20000	GL0002
INV-0001	30000	GL0001

etc.

thanks in advance

Federico

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Teagen Boll 2,534 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

That assumption is correct. From my understanding there is zero linkage between the invoice line and the general ledger entries. The reason is because the relationship between an invoice line and the general ledger entry table is not 1:1. Many invoice lines could roll up into one general ledger entry line.

An option you do have is to enable Copy Line Descr. to G/L Entry in the Purchases & Payables Setup:

This would mean that every line in a purchase invoice when posted will create a GL line. You won't be able to match them based off a Primary Key/Foreign Key but it would still allow you to compare based off the Document No. + Description.

Best,

Teagen

Catapult ERP

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,113 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

No, there's no as such connection between these two.

Why do you need this?

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 1,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yes, that's is possible

In BC14+, the G/L Entry has "Document Line No." (field 79) which gets filled from the purchase invoice line during posting. So filtering on Document No. + Document Line No. gives you a good 1:1 mapping.

For item lines it's even better to go through Value Entry → G/L Entry.

Can you please mark it as verified if you found it useful?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 100,974 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

As far as I know, there is no direct way.

For example, the following example, It only has two lines, but it generates 7 lines of GL Entries.

Excluding the details of cost adjustments, there are a total of 5 lines.

This depends on the GL Account you set up.

You can't manually check every single invoice, so it's impossible to match them one by one.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 16,074 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello Federico,

Standard BC doesn’t give you a universal line-to-G/L-entry 1:1 link for posted purchase invoices. At best, you usually have the document number as the common key, and then the trace depends on the purchase line type: G/L Account lines can be tied more directly to G/L entries, while Item lines go through Item Ledger Entries / Value Entries and then to G/L via the G/L–Item Ledger Relation table, so the link is indirect, not a simple posted invoice line → G/L entry join. So yes, you can often trace it, but not with one standard direct join for all line types; for that, you’d normally need a custom query/report/extension.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 16,074 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Yes it means Microsoft is now at the forced-update stage, so you can’t push it past Apr 2 anymore; if blocking extensions are still incompatible, they need to be fixed fast because during the enforced period Microsoft can proceed with the upgrade and incompatible extensions may be removed so the update can succeed.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No