Create Entry in General Journal using Postman and API or ODATA

(0) Share

Report

Posted on by MahGah

15,529

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

Thanks

I have the same question (1)

All responses (5)

Answers (1)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (1)

Report

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

Was this reply helpful? Yes No