SMI Consolidating companies w/different fiscal years
Can SMI handle consolidating companies with different fiscal years? When using the cannned container, it consolidates period 1 for one company and period 1 for the other company when in fact we'd like it to combine period 12 for one company and period 2 for another company for example and in some instances the years may be different. One company has a fiscal year 2012 that begins on 2/27/11 and the other has a calendar fiscal year for 2012 that begins on 1/1/2012. What tools can I use to setup consolidating based on different fiscal years? Thanks.
Tags: Consolidating, SMI, companies, different, fiscal, years
Views: 50
Replies to This Discussion
-
Permalink Reply by Stephen Coull on -
My suggestion would be to union 2 separate versions of the Financial Report to the same Excel worksheets i.e. Financial Report 1 (2/27/11) run into Sheet 1 of the workbook and Financial Report 2 (1/1/2012) run into Sheet 1 too.
-
Permalink Reply by Dana Halpin on -
Thank you for your reply. Once all data for both companies are in sheet 1, I then can create another sheet 2 for the actual financial report? On this new sheet create formulas adding period 01 for one company and corresponding period 03 for the other company? Also when I add 2 financial reports to a union, will I need to create a company parameter to get one report for one company and one for the other company? This is my first attempt with SMI and have alot of questions.
-
Permalink Reply by Dana Halpin on
-
I have a union report that combines 2 reports, one for each company. I have all data going into sheet 1. Why when I run the union report does the raw data only appear for the company I'm logged into. If I log out and log into the other company it prints only for that company. Is there a way to get the raw data for both companies on sheet 1?
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
