Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Financial Reporter

Status
Not open for further replies.
Mar 28, 2007
66
GB
On Financial Reporter is it possible to report from more than one company ?
 
At the same time? No, it's built to only do the company you're in. You need G/L Consolidations or Insight to do multiple companies.
 
I have tried F9 earlier and prefer Financial Reporter.

On that I don't think F9 does consolidation either. You need to set up the database before it starts reporting and you can set up only one database.

I was wondering if someone has done some tricks with Financial Reporter.

I have the consolidation package but have never used it. I wonder if it is straight forward to use from the guides. Any advice on situations that I need to be careful with consolidations would be appreciated.
 
If the COA's are the same in all companies, then the G/L consolidations module is a piece of cake. Even if they're not, it's just one more step in the process to build the consolidated COA before importing the transactions.
 
GL Cons is easy, setup a new consolidation company in Accpac, export from the subsidiary companies and import into the consolidated company. Then you can report using FR on the consolidated company. The only tricky part with GL Cons is if you have multi currency companies with different functional currencies.
 
Ettienne,
We do have different functional currencies. What should I be careful about. I think I should make sure that I export using the right currency or the currency of the consolidated company.
Sorry if this sounds a stupid question. I'll do this once to know the results.
 
1. You need to setup the exchange rates, and it needs to be the opposite way you think it should be. If you are exporting from a USD company to a CAD company, then you need rates for CAD -> USD, not the other way around.
2. You must use the mapping table, with multi currency exports you do not have a choice.
3. In the export setup you say which currency you are exporting to, this must match the currency of the consolidated company.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top