[trimblee]

I’ve run a consolidated BS by Accounting Period. Retained Earnings and Cumulative Translation Adjustment are way off. It’s as though the report is cumulatively summing the entire retained earnings balance for the current fiscal year every period, e.g.:

BS by Accounting Period:

Jun 2012 Retained Earnings: 180

July 2012 Retained Earnings: 250

Compare to the BS as of July 2012

Retained Earnings: 70

As far as the CTA balances, I can’t make any sense of them. Anyone seen this before? I’ve filed a case with support, and will update if I learn anything, but any insight would be great.

Thanks,

Evan
This is a cached copy. Click here to see the original post.

[trimblee]

RE: Consolidated Balance Sheet by Accounting Period – Some balances way off

Turns out this isn’t supported.

[Olivier Gagnon NC]

RE: Consolidated Balance Sheet by Accounting Period – Some balances way off

What isn’t supported?

[trimblee]

RE: Consolidated Balance Sheet by Accounting Period – Some balances way off

While the UI allows one to generate a consolidated balance sheet by accounting period, it’s inaccurate, and so thus ‘not supported’.

Enhancement # – 130536 SIC Reporting > Please allow to run Consolidated Balance Sheet by Accounting Period, Week, and etc.

Summary: Ability to generate the Consolidated Balance Sheet by Accounting Period.

[dhevelone]

RE: Consolidated Balance Sheet by Accounting Period – Some balances way off

Was “While the UI allows one to generate a consolidated balance sheet by accounting period, it’s inaccurate, and so thus, ‘not supported’.” the official NetSuite answer to your case?

Any word on the status of the Enhancement Request (#130536)? We really need this report!

Thanks.

DeWayne Hevelone

Fleetmatics USA

Wellesley, MA

[trimblee]

RE: Consolidated Balance Sheet by Accounting Period – Some balances way off

The enhancement is still “Open-Accepting Votes”, which is the first stage I believe, i.e. not yet “Under Review” or “Under Investigation”, whatever comes next.

The wording was mine, NetSuite didn’t make the first part explicit. It was more something like:

[It doesn’t work. Therefore] it’s not supported, at this time.

[J.Mark]

Please try this alternate solution on the consolidated balance sheet::

-customize the report

-click Edit Columns

-change Alternate Period Range Type to relative to today’s date

-change Alternate Period Range to Custom

-under Period select one period only (Ex. Jan 2013).

To expose Feb 2013, expand the Financial folder and click Amount. Do the same steps above.

[daveweez]

That solution ****s.

[Lilla P]

I love how getting NetSuite to perform what the UI permits is considered an enhancement request.

It’s either a defect in the report or a defect in the UI.

Any updates on this defect?

[Author]

Posts