Small and medium business | Business Central, N...

How can we get Customer Ledger Entries using API

(2) Share

Report

Posted on by Community member

I am finding the solution to get customer ledger entry from BC. how can I get it using API.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

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

Like (5)

Report

Hi, as of now, Customer Ledger Entries does not have a standard API, but there is a standard Web Service, which you can access using the Odata URL below.

https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox223/ODataV4/Company('My%20Company')/Cust_LedgerEntries

Below is the standard code for all standard APIs V2.0.

https://github.com/microsoft/ALAppExtensions/tree/main/Apps/W1/APIV2/app/src/pages

PS: Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs

https://yzhums.com/20960/

Thanks.
ZHU

Was this reply helpful? Yes No
CU03041415-1 3 on at

Like (0)

Report

Is it possible to POST or PUT to the Customer Ledger Entries?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,435 Super User 2025 Season 2 on at

Like (0)

Report

You can't post directly to any ledger entries page in Business Central. This goes against how the system works. To post something, you need to use documents or a journal. So if you post documents such as sales orders, or journals where the entry is against a customer, you would be created customer ledger entries indirectly. You can do this using APIs

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

You don't have a standard API; you can use the OData Services, but you cannot create ledger entries directly by using API. You need to use Sales Documents or Journals to create ledger entries.

Check the second blog, which describes how the entries are created.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

https://svirlan.com/customer-ledger-entries-in-business-central/

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

You are not supposed to post directly to Customer Ledger Entries because there are a lot of tables related to this.

You need to create and post through a document or journal.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, hope the following helps.

Dynamics 365 Business Central: Can we insert/modify/delete posted data (Posted Documents & Posted Entries) via AL???

https://yzhums.com/54657/

Thanks.

ZHU

Was this reply helpful? Yes No