GL linked to purchase invoices lines

(1) Share

Report

Posted on by CU04111701-0

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 (1)

Answers (0)

Suggested answer

Teagen Boll 1,268 Super User 2026 Season 1 on at

Like (0)

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