Finance | Project Operations, Human Resources, ...

Dynamics & FRX don't balance

(0) Share

Report

Posted on by shaunda

I added new sub-accounts to dynamics & when I ran my reports in management reporter, the balance sheet is off by the transactions on those subaccounts.

Can someone please send me the steps for adding them to the management reporter? I think I'm just missing a step possibly in the row or reporting tree definitions?

All responses (2)

Answers (0)

CFROTON 4,710 on at

Like (0)

Report

RE: Dynamics & FRX don't balance

Dear Shaunda,

I remember there is some problem with subs when they share their descriptions with other subaccounts, perhaps they are skipped over. I'll check on this as a possible cause.

Best Regards,

Jana MacDonald
Suggested answer

John_Joyce 1,040 on at

Like (0)

Report

RE: Dynamics & FRX don't balance

Hi Shaunda, it's likely that the Reporting Tree would need to be updated, as that is typically where Subaccounts are used in Management Reporter.

Before you make updates to the Reporting Tree, try to gather the Subaccount numbers that need to be added.

Open the report in Report Designer, go to the Tree and then open it by clicking the icon circled below:

Once you're in the Reporting Tree, determine where the new Units should be added, then you can right-click on that Row Number and insert a new Row:

Use the same logic for the Company, Unit Code and Unit Descrption that you see on existing lines. For the Dimensions in Column D, double-click on that column on the new line:

You can enter the new Subaccount values by Segment (my example has a 3-segment subaccount highlighted above).

Hit OK, then save and close the Reporting Tree, and then re-generate the report.

If you'd like, I'd be happy to give you a 15-minute walk-thru. Just send me an email.

Thanks,

John Joyce

Senior Applications Consultant

JJoyce1215(AT)gmail(DOT)com