Latest from Planful! Check out this month's Release Notes.
Consolidation: Introducing Spot Exchange Rate
With this release, a new option for Spot Rate is available in Exchange Rates. Spot Rate lets users define an exchange rate for a specific combination of scenario, company, account, and currency type.
Key Benefits
This new capability allows users to:
Define spot exchange rates for edge cases, such as translating equity accounts for mergers and acquisitions.
Reduce reliance on external tools (for example, Excel) and minimize the need to create and maintain too many Currency Exceptions for special cases.
Align equity account translation with historical-rate requirements under US GAAP and IFRS.
The Spot Rate is treated as the top-priority exception for that combination by the application whenever the currency conversion process is initiated.
How to Configure Spot Rate
To configure Spot Rate, do the following:
Navigate to Administration > Exchange Rates.
Click Spot Rate.
From the drop-down menu, click Import.
In the Import Spot Rate dialog, click Download template.
Open the downloaded template.
Enter the following details in the template:
Scenario - The scenario where the spot rate is applicable.
Month - The month during which the spot rate is applicable.
Source Company - The company for which you want to define the spot rate.
Target Currency - The currency on which the defined spot rate is applicable. This cannot be the source currency (local currency) of the Source Company. It can be the application’s common currency, interim currency, or reporting currency.
Account - The account on which this spot rate is applicable during the conversion process.
Spot Rate - The exchange rate to be considered by the application to convert values. This value cannot be a zero or a negative value. Additionally, the application supports 5 values before and 15 values after the decimal point.
Save the template.
In the Import Spot Rate dialog:
Click Choose File to upload the saved template.
Select one option:
Append Data - This option identifies the same records and updates their values, and adds new records if they do not already exist.
Overwrite Data - This option clears the existing records and replaces them with new records.
Click Submit. A successful import message appears.
In case of import failure, download the error file to view and correct the errors, and then try again.
To view the existing or imported Spot Rate records, click Export in the drop-down menu. The downloaded file contains all Spot Rate records currently active in the application.
Notes:
Spot Rate is supported only for Actual and Preloaded Budget scenarios. Additionally, only the Preloaded Budget scenario which is in Forwarded state is considered.
The application checks and applies currency exchange rates in the priority Spot Rate > Currency Exception > Exchange Rate. It means that if a Spot Rate is available for a certain case, the application gives highest priority to the Spot Rate.
This enhancement is available only with Ivy configuration On.
Consolidation: Convert Balance Sheet Accounts Using Month-to-Date (MTD) Values
With this release, users can apply the month-to-date (MTD) values of balance accounts during currency conversion. The new MTD Currency Conversion field appears under Segment Properties of member configuration in Account dimension. This field appears when you select the Account Type as Balance and it is set to No by default. When selected Yes, the application uses MTD values in balance accounts whenever the currency conversion process is initiated across the application.
Key Benefits
This enhancement allows users to:
Reduce the number of currency exceptions previously created to support monthly translation for balance sheet accounts.
Set up MTD balance reporting easily, without complex configurations to view balance sheet account movement on an MTD basis.
Align MTD balance translation with historical-rate requirements under US GAAP and IFRS accounting standards.
Consider this example:
When MTD Currency Conversion is set to No, the application converts YTD first (LC to CC) by multiplying the YTD values by the rate for each period (for example, C6 = C2 × C3, D6 = D2 × D3, E6 = E2 × E3). It then derives MTD from the converted YTD values (for example, D5 = D6 − C6, E5 = E6 − D6).
When MTD Currency Conversion is set to Yes, the application converts MTD first (LC to CC) by multiplying the MTD values by the rate for each period (for example, C8 = C1 × C3, D8 = D1 × D3, E8 = E1 × E3). It then derives YTD from the converted MTD values (for example, D9 = C9 + D8, E9 = D9 + E8).
Note:
This enhancement is available only with Ivy configuration On.
Planful AI Analyst: Stacked Column Chart Support for Data Queries
With this release, we have introduced Stacked Column Charts support within AI Analyst, further enhancing the visual analysis experience for Natural Language (NL) data questions. The Stacked Column chart is effective for part-to-whole comparisons across categories.
Users can now visualize their AI-driven insights using a Stacked Column format when asking questions such as:
“What is the sale by customer and product for the last three quarters?”
“What is the net revenue by client, stacked by product line?”
Predict: Introduced AI Forecast Explanations
With this release, we have introduced an explainable AI feature in Trend Analysis that helps users understand how forecast values were predicted. The new Explain option allows users to view concise AI forecast explanations of the historical patterns and trends that influenced the prediction, improving transparency and confidence in AI-driven predictions.
Users can access the Explain option in Trend Analysis from:
Dynamic Reports
Predict-related results in the Planful AI Analyst
Note:
The Explain option is available in Trend Analysis only to users with access to Planful AI Analyst.
Clicking the Explain option in Trend Analysis generates a concise, plain-language AI forecast explanations describing:
Key historical trends.
Recognizable seasonal or repetitive patterns.
Missing data periods or significant anomalies.
How these factors contributed to the final forecasted value.
How to View AI Forecast Explanations
Dynamic Reports
Open any Dynamic Report.
Right click on any cell and select Trend Analysis.
Click Explain to view the AI forecast explanations.
Note:
The Explain option is applicable only to Planful AI Analyst users.
Planful AI Analyst
Ask a Predict-related question in the Planful AI Analyst assistant.
In the results table, right-click on any data.
Select Prediction Context.
In the Trend Analysis window, click Explain to view the AI forecast explanations.
Structured Planning: User Security Standard Report Now Displays Approval Roles from User Groups
With this release, we have enhanced the User Security Report to improve visibility into approval role assignments by introducing a new User Group Name column. This update allows administrators to clearly distinguish between access granted directly to users and access inherited from user groups.
When approval roles are assigned through User Groups, the User Group Name column will display the name of the group from which the user has inherited access. If the user is granted access directly at the user level, the User Group Name column will appear blank.
Note:
This update is applied automatically and does not require redeploying the report.
The report supports the ability to:
Display multiple rows per user if they belong to multiple user groups, with approval roles inherited from each.
Show all user and group-level access when the “All Users” option is selected.
Group access lines by individual users for easier audit and review when using the Group by User setting.
Business Value
Adds complete visibility into inherited approval roles from user groups
Clarifies the source of access through a dedicated User Group Name column
Simplifies auditing and access reviews for complex role structures
Supports scalable user management by reflecting multi-group inheritance in reporting
This enhancement also supports situations where users belong to multiple groups. Each group-based access is listed on a separate row, ensuring complete transparency into all role assignments.
Workforce Pro: Introduced Revert Functionality for Promotions and Transfers
You can now seamlessly revert Promotion and Transfer planned actions directly from the employee profile, ensuring consistency, reducing manual cleanup, and improving planning accuracy.
Read More…
With this release, we have introduced Revert functionality for Promotions and Transfers in the Actions menu in Workforce Pro. Previously, only Terminations could be reverted, leaving users to manually delete position records to undo Promotions or Transfers which was a tedious workaround. This enhancement gives a consistent experience across all planned actions.
To learn more about the Actions menu, click here.
Notes:
Reverts apply only to the latest position associated with the action.
Positions created using New Position cannot be reverted, as actions are not available on those entries.
When reverting Transfers:
You can initiate a revert only from the Transfer-Out employee profile. When reverted, the Transfer-Out label and schedule date are deleted and also the Transfer-In profile created by the action is deleted.
When reverting Promotions:
Promotion reverts must be initiated from the original position where the promotion was applied. When reverted, the Promotion label, and schedule date from the original position are deleted and also the promoted position created by the action is deleted.
How to Revert the Promotion Action
To revert the promotion for an employee, do the following:
Navigate to the employee profile associated with the Promotion. To learn how to perform promotion, click here.
You can navigate there by clicking the Inactive Position from the Expand Lineage drop down of the original Promotion profile.
Click the Revert Promotion option. The Revert Promotion pop-up appears.
Click Revert.
The action indicators are removed and deletes dependent position records created by the promotion action.
Click Save to confirm your changes.
You can perform actions again by clicking the Actions menu.
How to Revert the Transfer Action
To revert the transfer for an employee, do the following:
Navigate to the employee profile associated with the Transfer, i.e. the Transfer Out profile. To learn how to perform a Transfer, click here.
You can also navigate there by clicking Inactive Position from the Expand Lineage drop down of the original profile, Transfer In.
Click the new Revert Transfer icon. The Revert Transfer pop-up appears.
Click the Revert option.
The action indicators are removed and dependent position records created by the transfer action are also deleted.
Click Save to confirm your changes.
You can perform actions again by clicking the Actions menu.
Workforce Pro: Improved Messaging for Disabled Actions Menu
With this release, Workforce Pro now displays the specific reason why the Actions menu (Promote, Transfer, Terminate) is unavailable. Previously, you saw only a generic message but now, the updated behavior shows clear, contextual explanations across the possible use cases, improving user understanding during advanced action planning workflows.
Messages now accurately reflect the user's current state, ensuring clarity when actions cannot be performed. For example, the image below illustrates how Workforce Pro now surfaces the exact reason that the Actions menu is unavailable for promoted employees.
You can see the actual reasons for the disabled Actions menu for the following:
Adding a new employee
Employees with multiple simultaneous positions
Terminated, transferred, or promoted profiles
Unsaved Promotion or Transfer changes
Scenarios with past end dates
When the Actions menu is not enabled
View-only mode
Additionally, the Actions menu also reflects the user’s compensation security level:
Read or Hide access:
Actions menu is disabled
Edit and Delete icons are hidden
Action chips remain visible
Edit access:
Actions menu and all related icons remain enabled
This ensures users understand when restricted compensation access is the reason actions cannot be performed.
Note:
When the feature is not enabled and the page is in View Mode, the Actions menu is not visible.