Building a TB in Management Reporter Designer - cannot get the right Opening Balances.

(1) Share

Report

Posted on by Maria Nastevska

171

Hi MS community!

I am relatively new to creating and building reports within the MR tool. Recently, I've been tasked with generating a Trial Balance report that includes all main accounts, even those with a balance of $0.

After conducting research, I realized that I need to construct this report in MR. Currently, I am nearing completion of the report and have initiated a reconciliation process between the MR report data and the Standard Trial Balance Report in the GL module.

However, I have encountered a discrepancy specifically regarding the Opening Balances. Is there a recommended approach or solution to rectify this issue?

Thanks in advance,

Maria

I have the same question (0)

All responses (11)

Answers (2)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

Hi Maria,

Can you check the period covered option in column definition you took ?

There will YTD, BB, periodic, check if you took the correct option.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (1)

Report

Hi,

I think on your column defination formula has some issue , please try using following formula

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Hi,

There are reports examples that are given by Microsoft. You can check them to help you in your report generation.

Was this reply helpful? Yes No
Maria Nastevska 171 on at

Like (0)

Report

Hi @Billur, @Saurabh and @Ramit,

Please see below a screenshot of the column definitions in MR.

I'm unsure what am I missing in this setup.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

The reason it is coming as opening balance because it is running for period wise, not yearly wise, meaning in TB D365 report, you have run as yearly but in MR this works as period wise, means monthly wise.

Was this reply helpful? Yes No
Maria Nastevska 171 on at

Like (0)

Report

Hi Ramit,

That’s my question..

how do I do this report to run yearly wise , as oppsed to period wise ?

thanks

Was this reply helpful? Yes No
Verified answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Can u apply the below I shhared?

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi ,

To run yearly , what if you just select the last date of that year?

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

Hi Maria,

Please let us know if the answers solved your issue, kindly help to verify the answer if the same is solved your issue.

Was this reply helpful? Yes No
Verified answer

Maria Nastevska 171 on at

Like (0)

Report

Hi all,

I have been trying to flag the below answer as verified, however, the page is always loading with no result.

The solution for this was changing the OB period from 'BASE' to '1'

Thx so much all.

Maria

Was this reply helpful? Yes No