Dynamic Journals

Add a Dynamic Journal to post balances that fluctuate from one period to another.

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journals grid appears.

2. Click the Add icon. The Add Dynamic Journal dialog box appears.

3. On the Properties tab, specify the required information for the following fields:

   • In the Code field, enter a code of your choice.

   • In the Name field, enter a Dynamic Journal name.

   • In the Period field, select the month and year range. During the selected time period, the Dynamic Journal is active.

   • In the Posting Type list box, select the MTD or YTD posting type.

     Note:

     MTD (Month-to-date) evaluates entries based on the month’s activity; whereas, YTD (Year-to-date) evaluates the entries based on the cumulative balance of the line items.
     Note:

     To use the MTD posting type, contact the Planful support team for the additional guidance on how you can access this functionality.

   • In the Reporting list box, select whether the Journal is a Dynamic JE (CC) or a Dynamic JE (LC). A journal can be in common currency or in local currency.

     Note:

     A local currency is often used by a company's subsidiaries and then converted to a common currency for consolidated reporting purposes.

   • If you are adding an Unbalanced Journal, select the Unbalanced Journal check box. In Unbalanced Journals, debits are not equal to the total of the credits.

4. To navigate to the Journal Entry tab, click Next or click the Journal Entry tab. The grid displays segment columns based on the application configuration and user's security. To set up a journal entry, perform the following steps:

   • To add a new row, click Add.

   • To set up the values for each column, do any one of the following:

     • Specify the required values directly in the UI.

     • Paste the copied line items from an MS Excel spreadsheet to the journal entry grid.
       You can copy or paste all values, including description, segments, and debit or credit values. Use shortcut keys (Ctrl+C and Ctrl+V) to perform this action.

   • To build a formula for the journal entry, perform the following steps:

     1. Click Rule in the journal entry row. The rule pane appears.

     2. Build a formula by using Simple Rule or Advanced Rule:

        • Simple Rule —For the dimensions for which you want to select a member, open the selection pane and select the member.

        • Advanced Rule —In the left side box, expand the member hierarchy, select the member, and then click the Add icon. Repeat the same procedure to select the function in the right side box. Click the tick (√) icon to verify the syntax of the formula.

     3. To save the rule, click Save

5. Click Save.

Upload Dynamic Journals in xlsx format directly to the Consolidation module. Use the sample template (that you can download) for ease of use when performing the upload.

In Practice: Uploading Dynamic Journals

1. Access the Consolidation module.

2. Click the Dynamic Journals process. Dynamic Journals appear in the center pane.

3. If no Dynamic Journals were created or uploaded then this pane will be blank. You can opt to upload or enter journals or do a medley of both. Click the new Upload icon shown below.

   

4. When you click the Upload icon, the Dynamic Journals Upload dialog appears. It is a best practice to use the sample Excel template as it shows you exactly how you need to organize your journal data to load it successfully. Click Download sample Excel template.

5. The template is downloaded to your computer. Open the template.

6. The template displays and indicates the required fields. It also provides information to ensure the correct data is entered where needed. Copy and paste the template into a new file.

   

7. Enter a journal code, the period for which you want to load the journals, and the posting type.

8. Enter Dynamic JE (CC) or Dynamic JE (LC) for reporting and enter notes as needed.

9. Now, you’re ready to copy and paste journals to the spreadsheet. Prior to copying and pasting data to the Excel file, make sure you delete all the tips.

10. Save the xlsx file to your computer.

11. Back in the Consolidation Control Panel, click Choose File.

12. Select the file you just saved to your computer and click Submit. Once processing is complete, the uploaded Dynamic Journal will appear in the center pane.

13. If the file fails to upload, download the failed file to view the cause(s) of the failure, fix the file, and upload again.

Use copy when you want to use an existing Dynamic Journal to create a copy with new criteria for posting entries. For example, copy a Dynamic Journal with local currency to create a new Dynamic Journal to report on common currency.

Copy a Dynamic Journal :

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journals grid appears.

2. Select a journal.

3. Click Copy and select Copy Single. The Copy Dynamic Journal dialog appears.

4. Complete all the fields.

5. Click Save.

Performing a copy includes all associated entries/lines and MDX formulas/rules.

1. Access the Consolidation Control Panel.

2. Select the scenario you want to copy the Dynamic Journals from.

3. Select the Dynamic Journals process and click the checkbox next to the Dynamic Journal you want to copy.

4. Click the Copy button and select Copy Multiple. The Copy Dynamic Journal page appears as shown below.

   

5. Enter a Code and Name and select period dates.

6. Select the Target Scenario (scenario you want to copy the Dynamic Journal to). In this case it is 2016 Plan.

7. Click Next or select the Journal Entry tab. Entries for the Dynamic Journal are displayed and will be copied to the target scenario.

   

8. Click Save.

9. Select the 2016 Plan scenario and select the Dynamic Journals process. Notice the copied Dynamic Journal.

   

10. Open the Dynamic Journal in Edit mode to view entries. Click the Journal Entry tab to view the copied journal lines.

You may want to edit a Dynamic Journal prior to the posting of entry balances.

To edit a Dynamic Journal :

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journals grid appears.

2. Select the Dynamic Journal.

3. Click Edit. The Edit Dynamic Journal dialog appears.

4. Edit as needed.

5. Click Save.

You may want to delete unused or inactive Dynamic Journals. When you delete a Dynamic Journal, all the associated journal entries are also deleted.

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journal grid appears.

2. Select the Dynamic Journal.

3. Click Delete.

4. In the confirmation dialog that appears, click OK. The Dynamic Journal is deleted.

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journal grid appears.

2. Select a Dynamic Journal and click Edit.

3. Select the checkbox in the header to select all lines or select more than one line and click Delete.

4. In the confirmation dialog that appears, click OK.

Active Dynamic Journal Entries can be posted.

To post a Dynamic Journal :

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journals grid appears.

2. Select the active Dynamic Journal Entry, under Entry Actions, click Post.

   

3. The Post Dynamic Journal dialog appears. The Scenario field is read-only and indicates the selected scenario that will be used when posting Dynamic Journal Entries.

4. Select the fiscal Year by using the calendar icon.

5. Select the Period by selecting a month range.

6. Select the E-mail Notification checkbox if you want to send notification about results when the process is complete, and then enter email addresses of recipients you want to notify.

7. Click Post. The Post Dynamic Journal dialog is exited. A message appears indicating that the Dynamic Journal Entry is submitting for posting based on the selected periods, and includes a link to navigate to the Detail View for status.

When posting Dynamic Journals, undefined segments revert to the target. For example, if you define only three measures in the MDX formula, the remaining segment combinations will be retrieved from the target segment members.

You can process and post active Dynamic Journals as an independent task in Cloud Scheduler. Inactive Dynamic Journals are not available for selection via the Cloud Scheduler. You must make inactive Dynamic Journals active via the Consolidation Control Panel to make them available for selection in Cloud Scheduler.

In Practice

1. Access Cloud Scheduler by navigating to Maintenance > Admin > Cloud Scheduler.

2. Add a process and add a new task to the process. The New Task page appears.

3. Select Dynamic Journal as the Task Type as shown in the image below. When the Dynamic Journal task type is selected, Task Name + Scenario Name, Scenario, Period, and Dependencies fields are displayed.

   

4. Enter a task name and select the scenario for which you want to process Dynamic Journals. Once the scenario is selected, it will be added to the Task Name as shown below.

   

5. Select the period for which you want to process Dynamic Journals. Options include Custom Period (where you can select a specific date range), Previous Period, Current Financial Year, and Current Period.

   

6. For Dependencies, select a dependent task that must occur and complete prior to the posting of Dynamic Journals. For example, the processing of the reporting cube.

7. Now, select the Dynamic Journals you want to process by clicking the Selected link. The Active Journals/Selected Journals pane appears. Active Journals for the current period are displayed based on actions performed in the Consolidation Control Panel. If there is a journal not displayed, navigate to the Consolidation Control Panel and change the period of the journal to the same period selected in Cloud Scheduler. Navigate back to Cloud Scheduler and the journal will appear in the Active Journals pane. Selected Journals displays the journals selected.

   

8. Select all journals you want processed/posted. Click Save.

Here is an example of how the task name (Task Name + Scenario) appears in the process flow once processed.

Dynamic Journals can be processed for both the Actual scenario and other scenarios. If you select Custom Period for the Period field, additional From and To fields are displayed. This allows you to select specific dates for which to process Dynamic Journals.

How to process multiple Dynamic Journal entries dependent on previous entries

To post multiple Dynamic Journal entries dependent on the previous entries, you should manually create a Process Flow task in the Cloud Scheduler. The process flow task must contain one dynamic entry followed by a Cube process, the next dynamic entry, and so on.

Perform the following steps to create Dynamic Journal entries dependent on the previous entries:

1. Go to the Cloud Scheduler and select the Process Flow tab. 
2. Click Add Process Flow and select the Dynamic Journals you want to process by clicking the Tasks link. The Active Journals/Selected Journals pane appears. 
3. Active Journals for the current period are displayed based on actions performed in the Consolidation Control Panel. If no journal is displayed, navigate to the Consolidation Control Panel and change the journal period to the same period selected in the Cloud Scheduler.
   
   Note

   Inactive Dynamic Journals are unavailable for selection via the Cloud Scheduler. You must make inactive Dynamic Journals active via the Consolidation Control Panel to make them available for selection in Cloud Scheduler.
4.  Navigate back to Cloud Scheduler, and the journal will appear in the Active Journals pane. Selected Journals displays the journals selected. 
5. Process and post the active Dynamic Journals as an independent task. Dynamic Journals can be processed for both the Actual scenario and other scenarios.
6. You can select Custom Period for the Period field; additional From and To fields are displayed. This allows you to select specific dates for which the Dynamic Journals need to be processed.
   
   Note

   If you delete a Dynamic Journal from the Consolidation Control Panel that is part of a process flow in Cloud Scheduler, the Dynamic Journal will be deleted from the process flow along with all the data.
7.  Select Dependencies, an optional field in Process Flow configuration. Select tasks which must be executed in sequence with the task you are creating. 
8. Add one Dynamic Journal entry followed by a Cube process, then the next Dynamic Journal entry, and so on.

For more information, refer to How to add a Process Flow.

Data in the previously posted Dynamic Journals can be cleared.

1. In the Consolidation Control Panel, under Processes, click Dynamic Journals. The Dynamic Journals grid appears.

2. Select the processed Dynamic Journal, under Entry Actions, click Clear Data.

   

3. The Clear Dynamic Journal dialog appears.

4. The Scenario field is read-only and indicates the selected scenario that will be used when posting Dynamic Journal Entries.

5. Select the fiscal Year by using the calendar icon.

6. Select the Period by selecting a month range.

7. Select the E-mail Notification checkbox if you want to send notification about results when the process is complete, and then 8. enter email addresses of recipients you wish to notify.

8. Click Clear Data. The Clear Dynamic Journal dialog is exited. A message appears indicating that the Dynamic Journal Entry is submitted for clearing of data based on the selected periods and includes a link to navigate to the Detail View for status.

An opt-in configuration item allows you to process Dynamic Journals and Non Controlling Interest outside of the Consolidation Process. This configuration removes the steps associated with posting and clearing data for Dynamic Journals and Non Controlling Interest from the Consolidation Process and enables the functionality to allow users to post and clear Dynamic Journals and Non Controlling Interest within the processes themselves. If you are interested in this item being configured for your application please contact Planful Support for assistance.

You can also post and clear Dynamic Journals and Reclassifications in the cloud so that you can continue working while processing takes place. Once complete, you will be notified via email as well as an in-application notification.

Consolidation Process Changes

The steps within the Consolidation Process associated with calculating Dynamic Journals and Non Controlling Interest in Local and Common Currency will be removed from the Consolidation Process. These steps will post Active Dynamic Journals and Non Controlling Interest as established by the Status, which is set by journal or rule for the time period selected. Inactive journals or rules will clear data for the time period selected.

Dynamic Journals Module Changes

Dynamic Journal List Screen

• A checkbox to select journals to Post or Clear Data from is available for updated Entry Actions.

• The Status column is removed.

Entry Actions will be updated with the following options:

• Active/Inactive – these options will not be visible as users will determine which journals they would like to execute Entry Actions for and leverage the Start and End Period to determine which journals are active or inactive.

• Post:

  • To post a Dynamic Journal, select the Post checkbox next to the Dynamic Journal and click the Post Entry Action.

  • The Post Setup page is opened. Select the periods for which you wish to post and click the Post button.

    • Scenario - Displays the Actual scenario for which the Dynamic Journals will post.

    • Year - Select the fiscal year for which you want the Dynamic Journals to post.

    • Period - The months available for processing are displayed. You can only post to unlocked months.

    • Post - Execute the process.

  • Once Dynamic Journal data is posted, a status page provides you with information as to whether the posting was successful or not.
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  
  

• Clear Data:

  • Delete previously processed Dynamic Journal data.

  • To clear Dynamic Journal data, select the journal in the middle pane (by selecting the Post/Clear checkbox) and click on the Clear Data Entry Action. This action opens a dialog page, which allows you to clear Dynamic Journal data for the selected period(s).

    • Scenario - Displays the Actual scenario for which the Dynamic Journals will clear.

    • Year - Select the fiscal year for which you want the Dynamic Journals to clear.

    • Period - The months available for clearing are displayed. You can only clear data for unlocked months.

    • Clear Data - Execute the process.

  • Once Dynamic Journal data is cleared, a status page provides you with information as to whether the clear was successful or not.
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  
  

Non Controlling Interest Module Changes

Non Controlling Interest List Screen

• A checkbox to select rules to Post or Clear Data is opened for the updated Entry Actions.

• The Status column is removed.

Entry Actions will be updated with the following options:

• Active/Inactive – use to determine which rules you would like to execute Entry Actions for and leverage the Start and End Period to determine which rules are active or inactive.

• Post:

  • To post Non Controlling Interest, select the Post checkbox next to the Non Controlling Interest entry and click the Post Entry action.

  • The Post Setup page is opened. Select the periods for which you wish to post and click the Post button.

    • Scenario - Displays the Actual scenario for which the Non Controlling Interest will post.

    • Year - Select the fiscal year for which you want the Non Controlling Interest to post.

    • Period - The months available for processing are displayed. You can only post to unlocked months.

    • Post - Execute the process.

  • Once Non Controlling Interest data is posted, a status page provides you with information as to whether the posting was successful or not.
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  
  

• Clear Data:

  • Delete previously processed Non Controlling Interest data.

  • To clear Non Controlling Interest data, select the entry in the middle pane (by selecting the Post/Clear checkbox) and click on the Clear Data Entry Action. This action opens a dialog page, which allows you to clear Non Controlling Interest data for the selected period(s).

    • Scenario - Displays the Actual scenario for which the Non Controlling Interest will clear.

    • Year - Select the fiscal year for which you want the Non Controlling Interest to clear.

    • Period - The months available for clearing are displayed. You can only clear data for unlocked months.

    • Clear Data - Execute the process.

  • Once Non Controlling Interest data is cleared, a status page provides you with information as to whether the clear was successful or not.
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  • 
    
  
  

These Entry Actions will captured in the Audit Log under the Non Controlling Interest Audit Area for more detailed analysis, if required.