How to Link Posted Purchase Invoice Lines with General Ledger Entries

(1) Share

Report

Posted on by FY-27091544-0

Hi everyone, I am trying to merge the posted purchase invoice lines with general ledger entries, but I could not find a key to merge. I know that there are line no in the posted purchase invoice lines, and I can find ledger entry no in the g/l entries. Unfortunately, the order of line no does not match the order of ledger entry no.

I know they have the same document no, but I need to combine these two tables in the lines level. If I only use the document no as the key, then I cannot make sure each line is combined correctly.

Under this situation, how should I merge these two tables in Power BI? Please note that I want to combine posted purchase invoice LINES instead of posted purchase invoices.

Thanks!

Categories:

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses (2)

Answers (0)

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

Like (0)

Report

How to Link Posted Purchase Invoice Lines with General Ledger Entries

The standard associates them through Document No. and Posting Date.

Hope this helps.

Thanks.

ZHU
Valentin Castravet 22,638 Super User 2024 Season 2 on at

Like (0)

Report

How to Link Posted Purchase Invoice Lines with General Ledger Entries

They will both have the same document no.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/