Cash Receipt Journal Entries

(1) Share

Report

Posted on by TU-27061257-0

Hi, I am new to Business Central and we are trying to automate the some use cases using power automate. I am trying to get a list of cash receipt journal entries posted for a particular customer using the JournalLines API, but I am unable to see the posted entries. Any suggestions on how I might be able to get the list. Eg. I made a cash receipt Journal entry of $100 and posted the same. When I retrieve the list , I want to retrieve this cash receipt Journal entry of $100. Any help would be much appreciated.

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

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

Like (1)

Report

I believe JournalLines is only for unposted lines, for posted lines you need to use another API such as the customer ledger entries, general ledger entries, or a developer can create an API for the posted general journals which will have your posted lines.

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

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

Like (1)

Report

Hi, Valentin is right, SourceTable = "Gen. Journal Line", so you cannot get the data of the General Ledger Entry table.

https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV2/app/src/pages/APIV2JournalLines.Page.al

You can use the following API to get the posted data.

Get generalLedgerEntries

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_generalledgerentry_get?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No
TU-27061257-0 32 on at

Like (0)

Report

Thank you for your reply. Is it possible to use the Cash Receipt Journals page exposed as a web service to automate the Cash Receipt Journal line entries?

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Hi, Yes, you can, but you need to add some fields in advance, such as Journal Template Name, Journal Batch Name, etc., because the Web Service can only process the fields that are already displayed on the page.

Thanks.

ZHU

Was this reply helpful? Yes No
TU-27061257-0 32 on at

Like (1)

Report

What happens when there are updates/upgrades to the Page by Microsoft? Does the API still work?

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report

Hi, unless a major update like the one below occurs, it can generally be used.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-w1?wt.mc_id=DX-MVP-5004336#api-v10-for-business-central-removed

Thanks.

ZHU

Was this reply helpful? Yes No
TU-27061257-0 32 on at

Like (1)

Report

Thanks for all your replies. Its been helpful.

Was this reply helpful? Yes No