How to Add a Dynamic Journal?

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

1. Navigate to Consolidation to open the Consolidation Control Panel.

2. Click Dynamic Journals under Processes. The Dynamic Journals grid appears.
   
   

3. Click Add. The Add Dynamic Journal dialog box appears.
   
   

4. 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 additional guidance on accessing 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.
     
     

5. 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 Enter Rule in the journal entry row. The rule pane appears.
        
        

     2. Build a formula by using a 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

6. Click Save.