Calculation Exception Setup
  • 1 Minute to read
  • Dark
    Light
  • PDF

Calculation Exception Setup

  • Dark
    Light
  • PDF

Article summary

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

In the image below, the Reporting Currency is EOM-Next, which is a Member of the Reporting hierarchy. 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

How to Set Up Currency Calculation Exceptions?


  1. Access the Calculation Exception Setup page by navigating to Maintenance > Multi-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 in Hierarchy Management.

    Note:
    Only members with a calculation exception marked as yes in Hierarchy Management will be available for selection.
  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)



How to Delete a Calculation Exception?


  1. Navigate to Maintenance > Multi-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.



How to Download Calculation Exceptions?


  1. Navigate to Maintenance > Multi-Currency > Currency Exceptions and click the Calculation Exception Setup tab.
  2. Click Export as Excel to download the calculation exception excel report for all the accounts in the list.



How to Upload Calculation Exceptions?


  1. Navigate to Maintenance > Multi-Currency > Currency Exception, and click the Calculation Exception tab.
  2. Click the Upload File icon.

    Notes:
    • The user should first export the existing exceptions for the structure, then make the necessary changes and upload it.
    • You can upload XLSX file types only with a maximum size of 10MB.
  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 override. If the contents do not already exist in Planful, an append is performed.

    A message will appear indicating the upload process and you can check the status in the Detail Log.

Was this article helpful?

What's Next