Roll forward datasets automatically
In addition to Manual Roll Forward, ONESOURCE has a feature to automatically roll forward datasets.
You must manually create a dataset for the first period. After the data set is created, ONESOURCE Indirect Tax Compliance rolls forward the datasets to succeeding periods at a set date, the last Saturday of the month.
Automatic roll forward is based on the periodicity and the dates provided when creating the dataset for the first period. For example, if periodicity is selected as Monthly and last date is set to 31 Jan, it automatically rolls forward the dataset to February for the date range 1 Feb – 28 Feb.
- With auto roll forward, all the calculations in a dataset will be rolled forward at once and not per calculation.
- With manual roll forward, all the calculations in a dataset will be rolled forward at once and not per calculation.
Auto roll forward works for datasets when the periodicity is monthly, bi-monthly, quarterly, or annual.
Automatic Scheduling of Roll Forward Jobs
Datasets will roll forward on the last Saturday of every month. This applies for datasets with an end date in the current month, regardless of whether these are monthly, bimonthly, quarterly or annual. Datasets will be rolled forward with the periodicity set in the dataset parameters for the current month.
note
- Roll forward through IMPORT is blocked. (Existing auto roll forward case does not work.)
- If a client does not want a particular dataset to be rolled forward, such as a test dataset, check the checkboxNo auto roll forwardfor the relevant dataset.
Conditions that Prevent Datasets from Being Rolled Forward Automatically
Datasets will not be rolled forward at the end of the month if
Enable automatic roll forward
is not checked in Settings
or if any of the following are true:- The dataset is weekly or bi-weekly.
- The dataset purpose is a corrective return or Other return.
- The dataset hasNo Auto roll forwardflag as true.
- The dataset does not have an end date in the current month.
note
This means that datasets used for reconciliation during UAT for prior periods will not be rolled forward automatically. These must instead be rolled forward manually during UAT until live data starts to be imported.
You will now see datasets in the system before you import data for the relevant month. This is due to the scheduled job having run.
Enabling Auto Roll Forward Using the Scheduler
You can enable datasets to roll forward automatically.
- From theAdministrationtab, selectSettings.
- Check the Enable Automatic Roll Forward checkbox.
- SelectSave.
Disabling Auto Roll forward
We understand some customers may want to disable automatic roll forward and manually roll forward instead. If you would like to disable automatic roll forward for your database and manually roll forward all datasets, please contact the ONESOURCE Customer Support team or your super user to configure this.
- From theAdministrationtab, selectSettings.
- Uncheck the Enable Automatic Roll Forward checkbox.
- SelectSave.
Adding an Entity to a Dataset
You can add an entity once the dataset is created.
- Create a new entity.
- Select the particular Group Structure.
- On the Returns screen, selectEdit Datasetand add the entity.
- SelectRefreshto show the new entity.
Removing an Entity from a Dataset
You can remove the entity after the dataset has been rolled forward.
- On the Returns screen, highlight the dataset.
- Uncheck the checkbox for the return you want to remove.
- SelectRefresh.
Changing the filing date or periodicity of a dataset
You can change the periodicity of a dataset. For example, you can change from monthly to quarterly, monthly to bi -monthly. Once you have changed the periodicity (for example from 1st Jan to 29th Feb for a monthly to bi-monthly case), you must be sure to change the filing date as well.
Changing the Auto Roll forward setting
- Select the dataset.
- SelectNo Auto Rollforwardto uncheck it.
- SelectFinished.
Roll Forward Audit Details
From the
Administration
tab, select Roll Forward Audit details
to show all the datasets that do not have No Auto Roll forward set to True on the Returns screen for the relevant database. This screen also shows the status (completed, in progress, done) for each of the datasets.Rerunning Failed Roll Forwards Jobs
If a dataset has not rolled forward (the job has failed for that particular dataset), it will be shown as
Failed
in the Roll Forward Audit Details screen.If this is the case, an option has been provided for Support to be able to re-run the dataset roll forward job in question.
Changes to the User Experience from Older Versions
- Datasets are no longer rolled forward on import of data. This means that datasets that do not have an end date in the current month needs to be rolled forward manually (such as for UAT when the prior period's data is imported).
- Users see datasets for a period prior to data for the relevant period being imported. This is to enable the best user experience for clients who import on a daily/weekly basis, as well as for monthly importers.
Changes to the Returns Screen
On the Returns screen, a new column
NO AUTO R/F
has been added to indicate whether datasets should be rolled forward automatically. You can use this feature to automatically roll forward some datasets but not others.note
Enable automatic roll forward must still be enabled (set to True) in Settings for automatic roll forward to apply.
- The default setting is False. (The dataset will roll forward automatically.)
- The setting is per dataset, not per return.
- This checkbox is set underEdit datasetand result is shown on the Returns screen.
Related Content
-
Datasets
Format:
Article,
1 min read
-
Roll forward datasets manually
Format:
Article,
3 min read