Create Entry in General Journal using Postman and API or ODATA

(0) Share

Report

Posted on by MahGah

15,437

Is it possible to create General Journal Entry using Postman? If yes how I can do that?

Thanks

All responses (5)

Answers (1)

MahGah 15,437 on at

Like (1)

Report

RE: Create Entry in General Journal using Postman and API or ODATA

Thanks Mr Bruvik and Mr Zhu

This was really helpful. I am learning API and Postman and this helped a lot. I was even able to use the method to create journal using HTTP in Power Automate. I want to use HTTP to create line with dimension since BC Create record has no dimension

The only strange part is I need to convert GL Account to G_x002F_L_x0020_Account for HTTP to work. Maybe as a newbie I do not know enough and making mistake here.

Thanks
Verified answer

YUN ZHU 81,883 Super User 2025 Season 1 on at

Like (1)

Report
RE: Create Entry in General Journal using Postman and API or ODATA

Hi, let me do a simple test.

1. Get batch name

https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox220/api/v2.0/companies(028e612e-fbc9-ed11-94c9-000d3a260b8c)/journals(12eaab7a-72d2-ed11-a7c7-6045bd6326d4)

2. Get the journal lines under the batch

https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox220/api/v2.0/companies(028e612e-fbc9-ed11-94c9-000d3a260b8c)/journals(12eaab7a-72d2-ed11-a7c7-6045bd6326d4)/journalLines

Generally, the following fields are the fields that can be posted.

3. Post:

https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox220/api/v2.0/companies(028e612e-fbc9-ed11-94c9-000d3a260b8c)/journals(12eaab7a-72d2-ed11-a7c7-6045bd6326d4)/journalLines

{ "lineNumber": 20000, "accountType": "G_x002F_L_x0020_Account", "accountNumber": "1320", "postingDate": "2023-04-10", "documentNumber": "2304050844", "externalDocumentNumber": "", "amount": 200, "balanceAccountType": "G_x002F_L_x0020_Account", "balancingAccountNumber": "2340" }

Hope this helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (1)

Report

RE: Create Entry in General Journal using Postman and API or ODATA

You should use this API

learn.microsoft.com/.../dynamics_journalline_create

And here is a sample body.

{

"accountNumber": "1090",

"postingDate": "2023-04-22",

"documentNumber": "1000",

"externalDocumentNumber": "123",

"amount": -100.00,

"description": "MyDocument",

"comment": "CommunityRocks"

}

Reach out if you need a Postman collection
MahGah 15,437 on at

Like (0)

Report

RE: Create Entry in General Journal using Postman and API or ODATA

Thanks Mr yzhums

The first part which is insert data to general journal is my issue. I do not know how to insert data into general journal using POSTMAN. I always get many errors about BODY.

Can you share how to insert data into general journal using POSTMAN? I mean here or in your blog?

Thanks
Suggested answer

YUN ZHU 81,883 Super User 2025 Season 1 on at

Like (1)

Report

RE: Create Entry in General Journal using Postman and API or ODATA

Hi, Unfortunately, this cannot be done directly as far as I know.
You can insert data to general journal first and then post in Postman.

For posting, you can use the following standard API

https://github.com/microsoft/ALAppExtensions/blob/1b4179b94c1bca9f6e445bf67737e2f143040364/Apps/W1/APIV2/app/src/pages/APIV2Journals.Page.al

Hope this helps.

Thanks.

ZHU