How to Link Posted Purchase Invoice Lines with General Ledger Entries

(0) 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?

Thanks!

Categories:

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

All responses (1)

Answers (0)

Valentin Castravet 22,030 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/