web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
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.

(3) ShareShare
ReportReport
Posted on by tlhgolfer 23

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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,153 Moderator on at

    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.

  • Suggested answer
    JAngle Profile Picture
    JAngle 150 on at

    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

  • matthewjd24 Profile Picture
    matthewjd24 77 on at

    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
    Santiago270500 Profile Picture
    Santiago270500 51 on at
    Hi, I discover that using the journal batch id can get thru the process of the flow, in the example given im using an Approvals to get the batch and the journal lines from the batch (this is where i couldnt get the lines, it gave me a [ ] in the raw outputs ), using the journal batch Id it gives me the lines that are in the batch.
     
    Hope my answer helps you.
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,376 Super User 2026 Season 1 on at
    Hi, hope the following helps.
    More details:
    Dynamics 365 Business Central: How to use standard customerPayment API to get customer payments (customerPayments/customerPaymentsJournals APIs returns empty records)
     
    Thanks.
    ZHU
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,662 Super User 2026 Season 1 on at

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. OussamaSabbouh 2,042 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Dhiren Nagar 1,077 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. YUN ZHU 1,068 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans