Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / You must specify a jou...
Small and medium business | Business Central, N...
Suggested answer

You must specify a journal batch ID or a journal ID to get a journal line.

(0) ShareShare
ReportReport
Posted on by tlhgolfer 6

I am not sure if I should post this to this forum, but I am hoping Microsoft is listening and can assist.  We are trying to use Power Automate to import general journal lines and continue to get this error message.

You must specify a journal batch ID or a journal ID to get a journal line.

This post is the same issue, but it seems crazy that a out of the box connector makes you have a work around.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Create-record-in-Business-Central-Journal-Lines/td-p/945111

Has anyone been able to import general journals with the Power Automate connector for journals and journal lines.  The batch creates perfectly fine, but fails on the line import.

Thanks,

Tanya

  • matthewjd24 Profile Picture
    matthewjd24 75 on at
    RE: You must specify a journal batch ID or a journal ID to get a journal line.

    Hi Josh, is this the same thing I'm trying to do? (Post here community.dynamics.com/.../get-production-journal-lines-in-odatav4-or-through-api)

    It seems like you use the body to specify what journal lines to get, is that right? I just copied you but I can't get it to work. Do you have any advice?

  • Suggested answer
    JAngle Profile Picture
    JAngle 46 on at
    RE: You must specify a journal batch ID or a journal ID to get a journal line.

    To avoid this conflict I’ve opted away from the api pages. Instead using a web service published page for the journal batch. You can then pass in a larger body of json. I used this in a demo, hence the hard coded dates:

    2BE89BFA_2D00_059A_2D00_4723_2D00_B118_2D00_7A049780C823.jpeg

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: You must specify a journal batch ID or a journal ID to get a journal line.

    I have not tried it myself but you will have to at least provide all the primary key fields being journal, batch and line no.

    And i guess the API use the ID for journal and batch instead of the names.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans