Versions Compared

Old Version 4

changes.mady.by.user Frank Gambino

Saved on

compared with

New Version Current

changes.mady.by.user Carissa Warnock (Unlicensed)

Saved on

Key

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

Copying datasets/budgets can save time and/or preserve data for reference purposesIn

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 the accounting year with which you are working. You can copy one full dataset (from periods 1 to 12) or you can add a second dataset and copy specific multiple datasets and specify the accounting periods from one dataset and different periods from another dataseteach dataset. For example, you can copy periods 1-9 from the first dataset and periods 10-12 from the second dataset. If the end period for dataset 1 overlaps with the start period for dataset 2, the overlapping periods will be summed. In essence, you are merging two datasets into one new dataset.if you are creating a budget for next year, you might 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 do not have to manually reconfigure all budget line items. 

To create a new budget dataset by copying existing datasets:

  1. In the toolbar, click the Main Menu icon ( Image Modified ).
  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 button ( Image Removed (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 Dataset dialog box. 
  5. Choose the appropriate Year and Type of the dataset you wish to copy (From Dataset).
  6. Select Add 2nd Dataset if desired and complete Steps a-c. If you do not select Add 2nd Dataset, proceed to Step 4.
  7. Select the type of dataset from the Type 2 drop-down.
  8. Select the end period for Dataset 1.
  9. Select the start period for Dataset 2.
  10. Choose the appropriate Year and Type of the dataset you wish to create (To Dataset).
  11. Click OK. The new dataset will be

    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.
  12. (Optional) To add another dataset from which to copy, complete the following steps:
    1. Click Add Dataset.
      A new row appears.
    2. Repeat steps 5a to 5d. 
  13. (Optional) To delete a dataset, click to highlight the row and then click Delete Dataset.
  14. 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.
  15. Select the appropriate check boxes if you want to exclude KBIs, hours, and/or rate adjustments in the new dataset.

  16. Click OK.
    The dialog box closes, and the dataset is created. It is named using the year and type that you

    designated

    selected in the To Dataset

    (i.e. 2005 Original).

    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.

...