Dynamics Community Forum Thread Details

MR Report issue: link to worksheet for eliminations w-multiple columns

I am attempting to create a Balance Sheet report that will consolidate multiple periods with eliminations to one report at the consolidated level for our companies. I've successfully run this report as each period individually with the link to an excel file with the elimination amounts for the specific period, but when I try & build the row/column/tree format that pulls multiple periods together it fails to process.

I'm trying to convert a standard report built in excel using 'F9 from Infor' that we've used for years. Management now wants to know if we can convert to using only MR or MR w/Excel. Columns I'm pulling are: 'Current Period', Prior Fiscal Year End (12/2013), and 'Prior Year Current Period' with links to a single worksheet with 4 columns & 6 rows (A=Description, B=Current Period, C=PYFYE, D=PYCP) for the elimination amounts at the Consolidated Company level, the report fails each time.

I've included some partial screen shots if it helps. I feel I'm close but just missing some piece that hasn't been shown in any training video or document I've read yet. Unfortunately, no training docs give examples of eliminations for multiple periods in the same report. If there are examples out there I'd love to get them.

Once I've got the BS working, I will be creating an Income Statement & Cash Flows with the same basic roll-up to the Consolidated level.

6507.Row-Definition-Consol-BS-w_2D00_Elim-link.png

Format for wks link is D=B2, G=C2, J=D2 On investment in affiliates Elim line. Additional lines are below but of same structure. I do have the link to the line on the tree definition but no column restriction as it wasn't necessary when I ran the report a each individual period.

0842.Column-Definition-BS-w_2D00_wks-link.png