Automatic Journal How-To Guide

Create a new rule - Automatic Journal Method

1. Go to Calculations under Drives on the left side panel of the navigation pane.

2. From the list of Rule Actions, select the newly created Automatic Journal Action Rule Type and go to the level 2 header and click on the Plus icon to create new Automatic Journal rule group details. A right-side panel of the Automatic Journal Detail will open.

3. Enter the Automatic Journal Group Rule Description.

   Output Dataset Field

4. Click on the Output Dataset field member selection to be used in the calculation. A member selection window popover will open.

5. Select the member. The selected member will be shown on the right side of the box as current member (CM).

6. Click on Okay to save the selection or Cancel to disregard the selection.

   Applicable to Field: Follow the same process for Version and Currency type Group Subtype field selection.

7. Click on the Version or Currency type Group Subtype field filter icon to select the field member selection to be used in the calculation. A member selection window popover will open.

8. Select the member. In addittion to the selection, the following relationships are available for the user: current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. Selected member and relationship will be shown on the right side of the window.

9. Click Okay to save the selection or Cancel to disregard the selection.

10. Click Save to save the creation or Cancelto disregard the creation. A popup confirmation will appear showing that the new Automatic Journal calculation group was created.

    

11. Select the newly created Automatic Journal group to add more details to the rule. Action icons of Plus, Copy, Edit, and Trash will be shown on mouseover.

12. Select the Plus (+) icon to create the details. The right-side panel of Automatic Journal Detail will open for the user to populate with the required information.

13. Enter the Description.

    Input Dataset:

14. Select the Input Dataset by clicking the Click to Select box. A member selector of the Dataset field will open.

15. Select member. In addittion to the selection, the following relationships are available for the user: current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. Selected member and relationship will be shown on the right side of the window.

16. Click Okay to save the selection or Cancel to disregard the selection.

17. From the switch button, activate whether Debit or Credit.

    Input: Applied to both Account and Flow fields.

18. Select Account and Flow member. In addittion to the selection, the following relationships are available for the user: current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. Selected member and relationship will be shown on the right side of the window.

19. Click Okay to save the selection or Cancel to disregard the selection.

20. Activate by clicking and showing a check mark on Apply to Periodic if required.

    Formula Field

21. Enter the required formula to be applied on the calculation in the text box.

    Debit: Please do the same for both Account and Flow.

22. Select the field member by clicking the Filter icon. A member selector for the field will open.

23. Select the member. The selected member will be shown on the right side of the box as current member (CM).

24. Click Okay to save the selection or Cancel to disregard the selection.

    Credit: Please do the same for both Account and Flow.

25. Select the field member by clicking the Filter icon. A member selector for the field will open.

26. Select the member. The selected member will be shown on the right side of the box as current member (CM).

27. Click Okay to save the selection or Cancel to disregard the selection.

    Relationship:

28. Select the relationship for the Entity and Intercompany based on the Ownership structure model tagged on the model to be calculated. A member selector Ownership structure method list will appear. Select the method to be used for Entity and intercompany. The selected member and relationship will be shown on the right side of the window.

29. Click Okay to save the selection or Cancel to disregard the selection.

30. Check the Swap Entity - Intercompany if the relationship requires swapping (Optional).

31. Check the Post to Interco Balances as required (Optional).

32. Click Save to save the creation or Cancel to disregard the creation. An information popup will appear that the Rule detail was saved successfully.

A new Automatic Journal rule detail will be created.

Edit rule - Automatic Journal Method

1. Go to Calculations under Drives on the left side panel of the navigation pane.

2. From the list of Rule Actions, select the created Automatic Journal Action Rule Type. Go to the created Automatic Journal rule group details to be edited. From the created Automatic Journal group, select Edit from the Action icons that will be shown on mouseover: Plus, Copy, Edit, and Trash. A right-side panel of the Automatic Journal Detail will open.

3. Edit if required the Automatic Journal Group Rule Description.

   Output Dataset Field

4. Click on the Output Dataset field member from the selection to update the member to be used in the calculation. A member selection window popover will open.

5. Select the member. The selected member will be shown on the right side of the box as current member (CM).

6. Click Okay to save the selection or Cancel to disregard the selection.

   Applicable to Field: Follow the same process for Version and Currency type Group Subtype field selection.

7. To edit, click on the Version or Currency type Group Subtype field filter icon and select the field member selection to be used in the calculation. A member selection window popover will open.

8. Select member. In addittion to the selection, the following relationships are available for the user: current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. The selected member and relationship will be shown on the right side of the window.

9. Click Okay to save the selection or Cancel to disregard the selection.

10. Click Save to save the editing or Cancel to disregard editing. A popup confirmation will appear showing that the Automatic Journal calculation group was saved.

Edit rule - Automatic Journal Rule

1. Select from the existing list of Automatic Journal groups to start editing. The list of rule details will be expanded.

2. Select the rule details to edit and the right-side pane of the details will open.

3. Edit the Description if required.

   Input Dataset:

4. Select the Input Dataset to be edited by clicking the Click to Select box. A member selector of the Dataset field will open.

5. Select member. In addittion to the selection, the following relationships are available for the user: current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. The selected member and relationship will be shown on the right side of the window.

6. Click Okay to save the selection or Cancel to disregard the selection.

7. From the switch button, activate whether Debit or Credit.

   Input: Applied to both Account and Flow fields.

8. Select Account and Flow member to be edited. In addittion to the selection, the following relationships are available for the user: current member, leaf member, children, descendants, current member and leaf member, current member and children, and current member and descendants. The selected member and relationship will be shown on the right side of the window.

9. Click Okay to save the selection or Cancel to disregard the selection.

10. Activate by clicking and showing a check mark on Apply to Periodic if required.

    Formula Field

11. Enter or update the required formula to be applied to the calculation in the text box.

    Debit: Please do the same for both Account and Flow.

12. To edit, select the field member by clicking the filter icon. A member selector for the field will open. Select the member.

13. The selected member will be shown on the right side of the box as current member (CM).

14. Click Okay to save the selection or Cancel to disregard the selection.

    Credit: Please do the same for both Account and Flow.

15. To edit, select the field member by clicking the filter icon. A member selector for the field will open.

16. Select the member. The selected member will be shown on the right side of the box as current member (CM).

17. Click Okay to save the selection or Cancel to disregard the selection.

    Relationship:

18. If required, edit the Relationship for the Entity and Intercompany based on the Ownership structure model tagged on the model to be calculated. A member selector Ownership structure method list will appear. Select the method to be used for Entity and intercompany. The selected member and relationship will be shown on the right side of the window.

19. Click Okay to save the selection or Cancel to disregard the selection.

20. Check the Swap Entity - Intercompany if the relationship requires swapping (Optional).

21. Check the Post to Interco Balances as required (Optional).

22. Click Save to save the editing or Cancel to disregard editing. An information popup will appear that the Rule detail was saved successfully.

The Automatic Journal rule detail update will then be saved.