How to Mass Load Currency and Calculation Exceptions

You can mass load currency and calculation exceptions to save time. The documentation below provides an example.

In Practice: Currency Exception Mass Load

In this use case, a currency exception is defined for the 034 Hot Venezuela entity and mapped to accounts 11001 and 11002. Realistically, if you only had two accounts to map, you would use the Copy To action on the Currency Exception Setup page, but this is for demonstration purposes only.

As shown in the image below, account 11001 is defined with an EOM currency type. The same holds true for account 11002.

The exchange rate for Avg is two times of that for EOM as shown below. A currency exception needs to be created for the Venezuelan entity and accounts 11001 and 11002, which need to be mapped to Avg.

1. Access the Currency Exception Setup page by navigating to Maintenance, Currency, Currency Exceptions.

2. Select a Reporting Currency. Reporting currencies are available based on what you've defined in the Hierarchy Management screen for Reporting Currency.

3. In the right pane, click the Add button and select the 034-Hot-Venezuela company.

4. For Currency Exception, select Avg.

5. Click Save. The set up so far is shown below.

   

6. Instead of clicking the Copy To option and selecting account 11001 and then repeating for account 11002, click the Mass Upload icon shown below.

   

7. The Mass Load page appears. Select a file to load by clicking the Choose File button. The .xlsx file selected for this example is shown below.

   

   You can upload XLSX file types only with a maximum size of 10MB!

   

8. Click Submit to perform the upload. The system checks to see if the file contents already exists. If the contents exists, the system performs an append. If the contents does not already exist in Planful, an override is performed.

A message will appear indicating the upload processed and you can check the status in the Detail Log. Click the Output All icon to export the currency exception details to Excel.

Mass Load Exceptions - Detail View Page & Excel Error File

On the Detail View page, you can see the status of the exception file upload. Detailed information is provided in Excel output for all exceptions that occurred during the Mass Load. Open the error file that contains exception data in a table format in Excel by clicking the Click Here link in the Status column as shown below.

Example output with 2 exceptions is shown below. The purpose of viewing exceptions is to resolve them within the file (by entering a new value in this case) and upload the file again without exceptions.

Understanding File Formatting for Currency and Calculation Exception Mass Load

When you upload a file, Planful validates the Company and Account codes and the currency type. Once the upload is complete, an email is sent to the user that performed the upload. If the upload results in an error, an email is sent with an attachment that lists all errors and provides the reason why the file could not be loaded.

Files must be formatted with Account Code in the first column and Company Code in the first row. All corresponding exceptions are listed against Account-Company combinations.

In Practice: Calculation Exception Mass Load

To mass load calculation exceptions, complete the following steps:

1. Access the Calculation Exception Setup page by navigating to Maintenance > Currency > Currency Exceptions, and click the Calculation Exception Setup tab.

2. Select a Reporting Currency. Reporting currencies are available based on what you've defined in segment hierarchies. For example, because Constant Dollar is defined for the Reporting hierarchy in the Hierarchy Management screen, it is available for selection on the Calculation Exception Setup screen.

   

3. In the right pane, click the Add icon and select a company.

4. Select enter the Calculation Exception and click Save.

5. Click the Upload icon. The Mass Load page appears. Select a file to load by clicking the Choose File button.

   You can upload XLSX file types only with a maximum size of 10MB! See Understanding File Formatting for Currency and Calculation Exception Mass Load.

6. Click Submit to perform the upload. The system checks to see if the file contents already exists. If the contents exists, the system performs an append. If the contents does not already exist in Planful, an override is performed.

   A message will appear indicating the upload processed and you can check the status in the Detail Log. Click the Output All icon to export the currency exception details to Excel.