How to import a vendor invoice journal

(3) Share

Report

Posted on by MBates237

233

Hello,

I have a requirement to create a vendor invoice journal to import monthly payroll costs from another system.

How would I import these? I would like the vendor invoice journal header to be created, and then vendor invoice journal lines added to that header. The only success I've had so far is by creating the header in system and then importing lines. I do not want this manual step.

This is an example of my lines import, where I have had to specify the journal batch number as an existing record

I know the numbers do not match ...7625 was my next attempt.

Thanks,

Michael

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (1)

Adis 6,597 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

My first thought is to do it via Power Automate. If that is an option, then I would suggest to check in Power Automate the possibilities of creating a journal and then creating journal lines via Power Automate where you pass the created journal number to tell Power Automate in which journal to put in the lines.

If that is an option I can check if there is an entity to create journals.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Verified answer

Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

Which data entity are you using? Try General journal - it will handle AP invoices and create the header and lines from one source file.

Was this reply helpful? Yes No
MBates237 233 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Frank Hamelly | MVP, MCP, CSA, I have had some success importing general journals for the same process. Currently, these transactions are created as a supplier invoice journal but I'll explore whether they can be done as a general journal instead.

Was this reply helpful? Yes No