Before you Begin

This 20-minute hands-on tutorial shows you how calculate periodic movement from closing balance input.

Background

Your business process may require you to load period-end account balances, rather than current period movements. If you enable the Calculate Movements system rule, you can load period end closing balances to the Closing Balance Input member, and the rule will calculate a specified current period movement. The Calculate Movement rule runs during the consolidation process. The existing Closing Balance plus the current entry for the specified movement are subtracted from Closing Balance Input to calculate the current period movement value. It writes the result to a specified movement member, replacing any existing values. After the Calculate Movements rule executes, the Closing Balance member is recalculated using the default consolidation process, and will match the entered closing balance value.

What Do You Need?

An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.

Modifying Member Attributes

  1. From the Home Page, click Application, then Overview, then Dimensions.
    overview dimensions
  2. Select the Movement dimension to open it.
    movement dimension
  3. Locate the member Mvmts_ChangesInBalanceSheet.
    member mvmts_changes in balance sheet
  4. Optional: Select the Member Name column, then click freeze (Freeze). This keeps the Member Name column on the screen as you scroll to the right to locate the Is Default Movement attribute.
  5. Select Default_Mvmt_Yes for the attribute Is Default Movement.
    Is Default Movement
  6. Locate the member Mvmts_ChangesInWorkingCapital.
    Mvmts changes in working capital
  7. Select Default_Mvmt_Yes for the attribute Is Default Movement.
    Is default movement attribute
  8. Click Save, then Cancel.
  9. Select the Account dimension to open it.
    account dim
  10. Locate the member FCCS_Balance Sheet.
    balance sheet account member
  11. Optional: Select the Member Name column, then click freeze (Freeze). This keeps the Member Name column on the screen as you scroll to the right to locate the Default Movement attribute.
  12. Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInBalanceSheet. Click Save.
  13. Locate the member Accounts Receivable Trade.
    AR Trade
  14. Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInWorkingCapital.
    Default movement attribute
  15. Click Save.
  16. Locate the member Obsolete Inventory.
    obsolete inventory member
  17. Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInWorkingCapital. Click Save, then Cancel.
    default movement attribute
    Note: This attribute can be selected only for “FCCS_Balance Sheet” and level 0 accounts.
  18. On the Application page, click Actions, then Refresh Database.
    Application page
  19. Click Create, then Refresh Database.
    refresh database
  20. Click Refresh, then Finish.
    Finish Button
  21. Click Close twice.

Managing Ownership

  1. From the Home page, click Application, then Consolidation. Verify the Manage Ownership tab is open.
    Manage Ownership tab
  2. Verify the Point of View is Actual, FY18, Jan. Select Actions, then Recompute Ownership Data.
    recompute ownership
  3. Verify the POV, then click Recompute.

Importing Data

  1. Open the RefApp_MovementsCalc_DataLoadFile_Data.csv file. Note the accounts for which a Closing Balance amount will be loaded in February. They are:
    • Cash
    • Accounts Receivable Trade
    • Other Accounts Receivables
    • Obsolete Inventory
    csv file contents
  2. Navigate to Application, then Overview.
  3. From the Actions Menu, select Import Data.
    import data
  4. Click Create. For source file, click Browse, and select the file RefApp_MovementsCalc_DataLoadFile_Data.csv.
    import csv file
  5. Click Import. Click OK, then click Close twice, and select the Jobs card. Verify the job completed, then click Home.
    verify job

Consolidating Data

  1. From the Home page, select Data.
    data card
  2. Expand the Reference_Application folder, then select (to open) the Movement Calculations form.
    movement calc form
  3. Closing balances have been loaded to the Closing Balance - Input member for February (you may need to scroll the columns to see the February data). Right-click a cell in the Feb column and select Consolidate.
    consolidate
  4. In the Enter Period field, select Feb, then click Launch.
    feb consolidate
  5. Note that the Feb Closing Balance does not yet reflect the Feb Closing Balance Input entries.
    closing entries
  6. Click Close to close the form, then click Home.

Modifying Calculation Settings

  1. From the Home page, select Application, Consolidation, then Consolidation: Process -> Local Currency.
    consol process: local currency
  2. Select the Calculate Movements row, then enable the Calculation Settings by changing the No to Yes.
    calc setting to Yes

Reviewing and Reloading Data

  1. Re-open the Movement Calculations data form.
    movement calc form
  2. Right-click a cell in the Feb column and select Consolidate. In the Enter Period field, select Feb, then click Launch.
    consolidate feb
  3. Note that the calculated movements for the two level 0 accounts for which a default movement was entered are posted against “Changes in Working Capital” while for the other two the movements are posted to “Changes in Balance Sheet”.
    movement form
  4. Manually enter the following data:
    • Cash -> Changes in Balance Sheet = 50 (replacing the existing entry)
    • Accounts Receivable -> Changes in Balance Sheet = 50
    • Other Accounts Receivable -> Changes in Working Capital = 50
    • Obsolete Inventory -> Changes in Working Capital = 50 (replacing the existing entry)
    manually entered data
  5. Click Save.
  6. Right-click a cell in the Feb column and select Consolidate, and in the Enter Period field, select Feb. Then click Launch.
  7. Note that the default movement amount is replaced but other data entered is not replaced.
  8. adjusted amounts

Modifying Calculation Settings

  1. From the Home page, select Application, then Consolidation, then Consolidation: Process -> Local Currency. Select the Calculate Movements row.
  2. calc settings
  3. Disable Calculation Settings by changing Yes to No. At the verification screen, click OK.
    disable calc setting
  4. Reopen the Movement Calculations form.
  5. Enter 400 for Closing Balance Input for all accounts.
  6. Click Save. Right-click a cell in the Feb column and select Consolidate. In the Enter Period field, select Feb, then click Launch.
  7. Note that the movements data does not change. All movement amounts are treated as if they had been manually entered, and as a result, the derived Closing Balance no longer matches the entered Closing Balance.
    movement calculations final screen

Learn More