23.2 Release Notes

With this release, budget managers can access the Predict Signals-related options from the top menu bar when they open a template or report. This enhancement eases the way budget managers access the Predict Signals feature. Instead of using this feature from the context menu, budget managers can now directly use the Predict option on the menu bar to access the Signals-related options.

Budget managers can select any cell in the template and do the following:

• Click Predict on the menu bar.
• Select any of the following options to generate signals:
  • Check All Lines
  • Check Selected Line(s)

To know more about Predict Signals in Business User Experience, click here.

With this release, budget managers can use the new Search option in WFP templates to find any specific employee's details. In addition to finding specific employees, budget managers can use the Search option to filter down the list of employees they view in the template using different filter options available on the Search screen.

The Advanced Search screen contains all the fields listed in the employee details as default search options.

In Practice: Using the Search Option

• After opening a WFP template, budget managers can click on the Search icon in the screen’s top right corner. The Advanced Search screen appears.
  
  
  
• To find a specific employee or to filter the list of employees, budget managers can use any of the advanced search options or a combination of these options based on their requirements and click Apply. The application will display the list of those employees who match the selected search criteria.
• Following are other options that budget managers can use while accessing the advanced search screen:
  • Reset - Use this option to clear the values provided in any Advanced Search field(s).
  • Cancel - Use this option to close the Advanced Search screen.
• To clear the search results and view the list of all employees in the template, budget managers can click Clear Search on the screen’s top-right corner.
  

To know more about workforce planning templates in Business User Experience, click here.

The Doc-Ref link in the Drill Through report is now a non-clickable text. As budget managers have access to only shared templates, they might not have access to the Doc-Ref linked source template. Therefore, to avoid any confusion, the Doc-Ref link is now a read-only text.

In Practice: Accessing Doc-Ref

• After generating Signals, budget managers can right-click on any signal and click Signal Context Screen.
• Right-click on any signal in the Signal Context table and click the Drill Through option.
• In the Drill Through report, the value in the Doc-Ref column is now a read-only text.

To know more about Predict Signals in Business User Experience, click here.

With this release, Planful has introduced an add-on for Google Sheets, which creates a sync with your Dynamic Planning modules. This is the perfect addition to any finance team's stack, providing a comprehensive, flexible, and robust tool for all your analyzing and reporting needs. You will now have the ability to easily view the updates on a view or report for complex budgeting, forecasting, and ad-hoc analysis within Google Sheets.

With the Planful Spotlight add-on, you can access data sets from the Dynamic Planning interface using your login and specifying environment details. Once connected, you can perform tasks such as

• Quick ad-hoc analysis using the Default view even if you do not have a view setup.
• Zoom in to a specific level within the hierarchy.
• Zoom out from a specific level within the hierarchy.
• Swap row and column dimensions using different Pivot options.
• Quickly segregate data and only see what you want using the Keep Only or Remove Only options.
• Customize your view and organize your data the way you like by using the different More options like Display, Suppress Rows, Indent Row Members, Number Format, etc. 
• View the reports and analyze the data further through graphs and charts available in the reports.

Previously, this feature was available only for Excel and Web, not allowing users using Google Sheets to integrate. 

With this add-on, you can quickly view the updates in model data, collaborate with colleagues in real-time, and track changes to the budget and forecast, making it easy to transfer data from SpotlightXL or Spotlight Web to Google Sheets and ensuring accuracy and consistency of data across your organization.

Additionally, you can copy and paste the Google Sheets data into Google Slides by linking it to the spreadsheet. When you make any changes to the Google Sheets, you will be notified to refresh the Google Slides to refer to the latest changes. For more information, please refer to the Planful Spotlight for Google Sheets.

A new Sort Order option has been introduced to quickly sort data before generating a Journal Entry Report, making it convenient for you to analyze and review the data. The following new Sort Order options are now available:

• By Period: By selecting Period, you can choose a range that displays the entries in that particular range. 

• By Status: By selecting Status, you can generate a Journal Entry report for a specific status by choosing any of the below options: 
  • All (Status)
  • In Process
  • Pending Review
  • Approved
  • Posted
  • Unposted
  • Rejected

Let’s consider you have multiple entries in a given period, and you want a report with entries of a specific status. You can fetch that data by selecting any of the above options.  

• By Period & Status: By selecting both you can have greater control over the accuracy and completeness of the reports that you generate.

Previously, the Journal Entry Report did not display or export data based on any order, making it difficult to read the report on the screen or in the exported excel.

Overall, the Sort Order option in the Journal Entry Report allows you to review and analyze the organized data in reports quickly, reducing the time and effort spent to sort or organize the data.

In Practice: To run and view the Journal Entry report

1. In the Consolidation Control Panel, under Processes, select a process. The grid for the process you have selected appears.
   
2.  Under Reports, click Journal Entry Report. The Journal Entry Report dialog appears. 
3. Select the Scenario.
4. Select the Period by selecting a date range using the calendar icon.
5. Select the Journal Types. Available values are Standard Journals, Dynamic Journals, and All Journal Types.
6. Select the Status for journal entries. Available values are:
   • All (Status)
   • In Process
   • Pending Review
   • Approved
   • Posted
   • Unposted
   • Rejected
7. Select the required Journal.
8. Select the Display for journal entries in report results, available options are:
   • Code
   • Name
   • Label
9. Select the Sort Order, available options are:
   • By Period
   • By Status
   • By Period & Status
     
10. Click Apply & Open. The report details appear within the Journal Entry Report dialog at the bottom.
    
    

An enhanced workflow version to post Standard Journals is now available, reducing the required process time. Users with full permission can skip the workflow actions, such as Forward, Approve, etc., and directly post the Standard Journals. Now, you can select different statuses and post them in a single action, eliminating the need for multiple clicks and making the process more efficient.

Previously, posting any Standard Journals required multiple clicks, and users with full permission needed to perform different actions, such as:

• In Process
• Forwarded
• Approved 
• Rejected
• Posted
• Unposted

This made the entire procedure tedious and time-consuming. Also, the application did not allow users to select and post multiple journals in different process states or carry out additional workflow tasks.

Overall, this new enhancement in the workflow to post Standard Journals makes the process easier and faster. Furthermore, the reduced number of clicks will help minimize the chances of errors and provide a better user experience by making the process simpler and easier to understand.

In Practice: To Post Standard Journals 

1. In the Consolidation Control Panel, under Processes, click Standard Journals. The Standard Journals grid appears.
2. Select the required Standard Journals that you want to Post.
3. Under the Entry Actions, click Post. The Post Status dialog box appears. The Status column displays Success if the journal entry is posted successfully. Otherwise, the Status column displays Failure.
   
4. Click OK to exit the Post Status dialog. The Standard Journal status is changed to Posted.

With this release, we have introduced an Import option in the Currency Exchange Rate screen. This option allows you to import the exchange rates from the exported file format consisting of the updated exchange rates from one scenario to another.

Once the file is imported you can see the updated exchange rates on the Currency Exchange Rate screen. Previously, users had to edit currency exchange rate data on the screen and there was only an option of Exporting the data.

Business Value:

This feature eases the process of exporting currency exchange rates file from one scenario and importing it to another scenario. It allows you to edit the data of an exported file with errors and import it again.

In Practice: How to Import Currency Exchange Rates

1. Navigate to Maintenance> Exchange Rates> Currency Exchange Rate tab.
2. Select the Scenario, Currencies, Year, and Apply Currency Conversion checkboxes. 
3. Click the Excel icon from the menu bar.
   
4. Select the Export option from the drop-down list. Currency Exchange Rates visible on the screen will be downloaded in an excel file format.
   
5. Edit the file and save it.
6. Select the Import option from the excel icon drop-down list. Import Exchange Rates pop-up will appear.
   
7. Upload the edited excel file and click Submit.
   
8. You will receive a notification once the import is successful.
   

Now, you can manage the display of currency types in the currency exchange rates screen. Previously, all the unused currency types were displayed while defining the exchange rates in the currency exchange rates screen. So, with this option you can hide the currency types you no longer wish to use it. The List in Exchange Rates option is available in the Currency type tab.

Business Value:

This feature limits the display of currency types on the Exchange Rates screen, thus making it easy for the users to choose the required currency type instead of long scrolling. It also helps in organizing the display of data on the screen.

In Practice: How to Delist Currency Types

1. Navigate to Maintenance > Multi-Currency > Currency Setup > Currency Type tab.
   
2. Select the Currency types you want to delist.
3. Click List in Exchange Rate option in the menu bar.
4. Select No from the drop-down list.
   

With this release, you no longer have to wait on the Standard Journals screen while multiple standard journals are under the posting process. Previously, while a user was processing multiple standard journals, they had to wait on the screen until the posting process was complete. Now, when a user starts the post process for journals, an async task gets triggered in the background and the user is notified once the process is complete.

With this release, the revamped admin screen allows you to perform all Predict administrative configurations from a single page. A new General Settings pane has been introduced to the admin screen, enabling you to configure common settings for both Signals and Projections.

In Practice: Enabling Predict Signals 

To enable Predict Signals, do the following:

1. Go to Maintenance > Admin > Configuration Tasks > Planful: Predict.
   The Planful: Predict configuration page appears.
   
2. Click Enable Signals.
   The Enable Predict: Signals popup appears.
3. Enter the passcode in the given text box and click Verify.
   The configuration screen appears.
   
4. Select the years from the General Settings pane.
   Note:

   You can now select the years that will be excluded from Model Training. You need at least 3 years of historical data for Signals and Projections.
5. In the Signals Configuration pane, select the Scenario(s) for Pre-computation and choose the Active Scenario from the respective fields to generate the Signals Overview Report.
6. Click Scenario Pre-computation.
7. You can choose to adjust the Signals Range and the Current Month as per your requirement from the respective fields.
   Note:

   The current Calendar month will be considered as the value of the System Default option. You can select 3 months before and after the current month using the drop-down menu.
8. You can also select the dimensions you want to ignore.
   Note:

   You can ignore a maximum of two dimensions.
9. Once you have configured the required fields, click Train Model.

In Practice: Enabling Predict Projections

To enable Predict Projections, do the following:

1. Go to Maintenance > Admin > Configuration Tasks > Planful: Predict.
   The Planful: Predict configuration page appears.
   
2. Click Enable Projections checkbox. 
3. Enter the passcode in the given text box and click Verify.
   The configuration screen appears.
   
4. In the Projections Configuration pane, click the Add GL Combinations link to exclude unwanted GL combinations.
   The Add GL Combinations screen appears.
   
5. Select the dimension members from the respective fields, and click Save.
   Note:

   You can add a maximum of 10 rows to the list.