Finance | Project Operations, Human Resources, ...

Management reporter: debit/credit columns show opening balances

(1) Share

Report

Posted on by JuleWergne

Hello,

in Mangement reporter we want to create a report, that should show also Opening balance of year, Debit or Credit movements in the year and then the end balance. A trial balance as a report, in other words.

But we have a problem with Debit/Credit columns in the report:

we chose YTD as column restrictions, but it shows then also opening balances in these columns, which is not correct.

Is there some possibility to display only Debit/Credit transactions in the year, without opening balances?

Thank you!

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi,

To address this issue, consider the following steps:

Use Periodic Columns for Opening Balances:

Instead of relying solely on YTD columns, consider using Periodic columns for the opening balance. You can have a separate column for the opening balance, followed by YTD columns for Debit and Credit movements, and finally, an end balance column.

Modify Row Definitions:

Review and modify your row definitions to ensure that they are set up to display the correct balances. You may need to adjust the row conditions or filters to exclude opening balances where necessary.

Check Account Structures:

Verify that your account structures in Dynamics 365 Finance and Operations are correctly configured. Opening balances are often associated with the initial setup of accounts, and adjustments may be needed to ensure they align with your reporting requirements.

Consider Using Reporting Trees:

Reporting Trees in Management Reporter allow you to define hierarchical relationships among financial dimensions. You can leverage reporting trees to consolidate or filter specific accounts, which may help in presenting the data more accurately.

Best regards,

Kevin

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

For debit and credit you need to select periodic. Also you can check/review from standard system trial balance report to understand the process.

Was this reply helpful? Yes No
JuleWergne 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @BillurSamdancioglu

PERIODIC doesn't suit for me, because it gets only month(period) debit and creadit. What I need is debit/credit of YTD, e.g. from 1.January till 30.Sept 2023.

Thank you.

Was this reply helpful? Yes No
Suggested answer

JuleWergne 12 on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Update to this topic: I found a soultion in this thread:

https://community.dynamics.com/forums/thread/details/?threadid=9820b03d-4c8d-4a50-9947-902e8a8bcb47

Thanks to all.

Was this reply helpful? Yes No