Share
ReportClient is a holding co which has multiple companies with separate GP sites. Client wants to do FRx consolidated reporting. At one of the company GP sites, we have created GP companies for each of the separate GP sites from database backups (GL data only subledger data removed). And have created consolidated FRx reports as of the 12/31/11. The major issue that we have is how to update the different cos GL data monthly or at least quarterly. Restoring each co's GL data from database backups is very time comsuming b/c some of these co databases are 40 to 50+ gigs of data. Have tried exporting out GL transactions and importing via Integration Manager -- but still very time consuming 8+ hours to integrate and issues with reversing JEs. Clients wants to have GL transaction level data from the GP sites so importing just a summary trial balance from each co is not an option. Another option is SmartConnect/eConnect integration but still this would be time consuming. Would like to find a SQL solution to just backup from the various sites the GL data, transmit to central site, restore to individual GL databases, maybe run a couple of utitlies, then be able to run consolidate FRx reports.
We are currently considering getting a monthly/quarterly backup from each GP site's of the GL account master (GL00100) and GL open year transactions (GL20000). Restoring the individual GL tables to the FRx consolidated reporting databases -- then running GL checklinks on the account master and reconcile on the 2012 GL open year (to recreated account summary info). Does anyone have any feedback if this can be done or issues related.
Thanks for your response.
John Born
*This post is locked for comments
All responses (
Answers (
291,269
