The combined datasets option takes data from separate datasets and combines that data to create a new set of data. Several configurable items and several assumptions are made by the system when combining existing datasets. Be sure to check the dataset's combined results because they may not be what you expect.

 

General Information

•Ideal when looking to merge certain activity in multiple datasets when the Weighted Average FX rates, Federal and State Current rates, and State Apportionment rates are the same across all the datasets.

•When the combined dataset is created, you can specify the first dataset, which is used to populate beginning rates, and the last dataset, which is used to populate ending rates.

•The new combined dataset sets all the unit's Weighted Average FX, Federal and State Current rates, and State Apportionment rates to the rates for the first dataset.

•Only entries from the first dataset for Payable, Intercompany Transactions, Trial Balance, APIC Pool, Amortized Permanent Differences, Temporary Differences - Book/Tax Basis, and After-Tax Temporary Differences - Book/Tax Basis are included in the combined dataset.

•The payable re-computes the automated posting and posts it in the payable for the combined dataset year. Other entries made to the payable, in any dataset, except the first, are not part of the combined dataset.

•Combined Datasets does not restrict a user to merging appropriate period datasets. Use care when selecting datasets to ensure that correct time frames are selected. For example, a dataset designated as Q1 2010 can be combined with a dataset designated as the 11th Month 2012.

•Due to the limitation of this functionality, please be sure to review the resulting dataset thoroughly for accuracy.