Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In

Include Page
Budgeting module name
Budgeting module name
, you typically copy a dataset to create a new instance of existing budget lines in the dataset for an the accounting year with which you are working. You can copy one full dataset (from periods 1 to 12) or you can add multiple datasets and specify the financial accounting periods from each dataset. For example, in your first datasetif you are creating a budget for next year, you might only use periods 1 through 3. You might want to add a second dataset that contains periods 4 through 7 and a third dataset that contains periods 8 through want to use this year's Budget from periods 1 to 4, last year's 30/60/90 from periods 5 to 7, and this year's End of Year Forecast from periods 8 to 12. In this example, you are building your new dataset from periods of multiple datasets.

Copying a dataset creates an exact copy of the dataset (or the selected periods in a copied dataset) so that  you you do not have to manually reconfigure all budget line items. 

To create a new budget dataset by copying existing datasets:

  1. Main menu 9x icon 20pxMain menu 9x icon 20pxIn the toolbar, click the Main Menu icon (  Include PageImage Added ).
  2. From the drop-down list, under the Financial section, select Budgeting.
    The Budgeting screen appears in a separate tab.
    For more information, see Budgeting.
  3. Click the Utilities (gear) button ( 
    Include Page
    Gear menu icon 30px
    Gear menu icon 30px
     ).
  4. From the drop-down list, select Copy Dataset.
    The Copy Dataset dialog box appears.
    For more information, see Copy Datasets Dataset dialog box
  5. In

    the To Dataset section, complete the following steps to define

    the

    dataset to which information will be copied:

    From

    the Year drop-down list, select the year to which you will copy datasets. 
  6. From the Type drop-down list, select the type of dataset that information will be copied to.
  7. In the From Dataset section, complete the following steps to define the dataset from which information will be copied:

    Info
    iconfalse

    Note: The From Dataset section defaults to periods 1 to 12. This default setting assumes you are copying one complete dataset to the To Dataset. If you are copying from more than one dataset, you can change these periods to specify which periods to include.

    1. Click the First Period cell and select the first period in the range of the dataset from which you are copying.
    2. Click the Last Period cell and select the last period in the range of the dataset from which you are copying.
    3. Click the Year cell and select a year of the dataset from which you are copying.
    4. Click the Dataset cell and select a dataset from which you are copying data.
  8. Optionally, to (Optional) To add another dataset from which to copy, complete the following steps:
    1. Click Click Add Dataset.
      A new row appears.
    2. Repeat steps 6a 5a to 6d5d
  9. Optionally, to (Optional) To delete a dataset, click to highlight the row and then click click Delete Dataset.
  10. In the To Dataset section, complete the following steps to define the dataset to which information will be copied:
    1. From the Year drop-down list, select the year to which you will copy datasets. 
    2. From the Type drop-down list, select the type of dataset to which the information will be copied.
  11. Select the appropriate check boxes if you want to exclude KBIs, hours, and/or rate adjustments in the new dataset.
  12. Click OK.
    The dialog box closes, and the dataset is created. It is named using the year and type that you selected in the To Dataset section.

     

Info
iconfalse

Notes:

  • If there is mismatched data, an error message appears. You must correct the data and resubmit.
  • You cannot copy into a Dataset that is locked dataset.
  • You cannot copy from the same dataset you are copying into.
  • You cannot overlap ranges. You must copy all periods 1 through 12/13 depending on the Financial Year type of accounting year.
  • 30/60/90 will only show in the selection list when a single period is being copied.

  • EPEP Current (Profit) will only show if a single period is selected and it matches the period of the Current Profit.

...