web

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

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... YTD Trial balance in M...

Finance | Project Operations, Human Resources, ...

Answered

YTD Trial balance in Management Reporter (Opening Balance, Debits, Credits, Ending Balance)

(1) Share

Report

Report

Posted on by CU27040921-4

8

I'm trying to replicate the out of the box D365 trial balance format (Opening Balance, Debit, Credit, Closing Balance) in MR but I can't get the debits and credit columns to exclude the opening balance entries when I run it for YTD so my calculated Closing balance is overstated by the Opening Balance amount. I would think there should be an option under column restrictions to suppress opening balance entries but I don't see one.

.The same MR report works fine when running monthly though (changing YTD to Periodic above).

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Robert Yao 492 on at

Like (1)

Report
Copy link

Link copied!

Change the debit & credit column Period from base to 1:base and Periods Covered from YTD to period to exclude period 0 for the beginning balance.

Hope it helps.

Rob

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 608

#2

André Arnaud de Cal... 591 Super User 2026 Season 1

#3

CP04-islander 430

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans