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

(1) Share

Report

Posted on by Maria Nastevska

177

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)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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,055 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 20,825 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 177 on at

Like (0)

Report
Copy link

Link copied!

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,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 177 on at

Like (0)

Report
Copy link

Link copied!

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,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can u apply the below I shhared?

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,055 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,809 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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 177 on at

Like (0)

Report
Copy link

Link copied!

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