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 the new financial year. You 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 periods from one dataset and different periods from another multiple datasets and specify the accounting periods from each dataset. For example, you can copy periods 1 through 9 from the first dataset and periods 10 through 12 from the second dataset—so you are building one dataset from periods in other datasets. , 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 o (r 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

    From Dataset section, complete the following steps to define the dataset

    to

    from which information will be copied:

    In the From Dataset section, complete the following steps to define the dataset from which information will be copied:
    Info
    iconfalse
  6. From the Year drop-down list, select the year to which you will copy datasets. 
  7. From the Type drop-down list, select the type of dataset that information will be copied to.
  8. 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 a period from the drop-down listthe first period in the range of the dataset from which you are copying.
    2. Click the Last Period cell and select a period from the drop-down listselect the last period in the range of the dataset from which you are copying.
    3. Click the Year cell and select a year from the drop-down listof the dataset from which you are copying.
    4. Click the Dataset cell and select a dataset from the drop-down list.
    Optionally, to
    1. which you are copying data.
  9. (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
  10. Optionally, to (Optional) To delete a dataset, click to highlight the row and then click click Delete Dataset.
  11. 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.
  12. Select the appropriate check boxes if you want to exclude KBIs, hours, and/or rate adjustments in the new dataset.
  13. 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.

...