web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Closing bookings with ...

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

Answered

Closing bookings with U in date - Excel

(1) Share

Report

Report

Posted on by RO-20060739-0

4

We have run the year closing report which generate a journal entry with date U31-12-2023 (Ultimo booking).

When we export the journals with API (web services) the U before the date has been removed.

Any Idea how to exclude these bookings for the financial reporting in Excel?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

KasparsSemjonovs 4,821 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try to add filter to General Ledger Entries API to the field "Source Code" <>CLSINCOME (or check how the Source code for such entries is in Your language)

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,796 Super User 2026 Season 1

#2

YUN ZHU 965 Super User 2026 Season 1

#3

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans