Contents x
    Calculation Exception Setup
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Calculation Exception Setup

    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    This functionality instructs the system to make exception currency calculations based on the accounts selected. The setup performed on this page and associated with the Reporting member on the Segment Hierarchy page will apply to all scenarios and all budget entities.

    In the image below, the Reporting Currency is EOM-Next, which is a Reporting Member of the Reporting Main hierarchy shown below. The Calculation Exception field in Hierarchy Management is set to Yes for the EOM-Next reporting member. Calculations will be performed when the Consolidation Process is executed.

    currency exception

    Set Up Currency Calculation Exceptions


    1. Access the Calculation Exception Setup page by navigating to Maintenance > Currency > Currency Exceptions and clicking the Calculation Exception Setup tab.
    2. Select a Reporting Currency (which represents a reporting dimension). This list is populated based on the name and code assigned to the reporting member defined on the Segment Hierarchies page. Select the reporting member defined, then set up exceptions for that member.
      reporting currency(1)
      The Currency Exceptions you assign to accounts on this page will populate in the Currency Exception field of segment hierarchies for reporting members.
       segment properties
    3. Click the Add icon in the right pane.
      Add icon
    4. Select companies to add and click Add. You can add multiple companies using the shift/ctrl key.
      click add(2)
    5. Select the Calculation Exception from the dropdown.
      select(3)
    6. Click Save.
      click save(3)
    7. Click Copy To to copy the calculation exception to accounts.
    8. The Copy To Accounts page displays. Select the accounts and click Copy.
      copy to accounts(1)



    Delete a Calculation Exception


    1. Navigate to Maintenance > Currency > Currency Exceptions and click the Calculation Exceptions Setup tab.
    2. Select a row or multiple rows of exceptions that you want to delete. The Delete Rows icon is enabled.
    3. Click the Delete Rows icon. A confirmation message appears.
      delete a row(1)
    4. Click Delete.



    Output All


    1. Navigate to Maintenance > Currency > Currency Exceptions and click the Calculation Exception Setup tab.
    2. Click Output All to download the currency exception excel report for all the accounts in the list.
      output%20all(1)



    Upload File


    1. Navigate to Maintenance > Currency > Currency Exceptions and click the Calculation Exception Setup tab.
    2. Click the Upload File icon to upload the calculation exception excel report from your system.
      mass%20upload
    3. Click Submit to perform the upload. The system checks to see if the file contents already exist. If the contents exist, the system performs an append. If the contents are not already present in Planful, an override will occur.
      click submit
    Was this article helpful?
    What's Next

      Planful. 150 Spear Street, Suite 1850, San Francisco, CA 94105

    • Copyright © 2024 Planful. All Rights Reserved.

    Terms of Use - Privacy Policy