Automating the Balance Updates

Use Transfer Desk (TRD) to set up a process that refreshes the ledger balances and publishes them if necessary. You can create a different profile for each ledger or business unit as required. Then, create an automation that runs all the refresh processes you have created.

Note:  It is also possible to set up an automation that reconstructs the ledger balances; however, if the balances are to be published to a downstream system, the Reconstruct process is not recommended because the downstream system must always have its corresponding balances removed prior to receiving the reconstructed balances.
  1. In Transfer Desk (TRD), select File > New Process Profile.
  2. Enter a name for the profile, for example, Refresh Balances for BU1. Enter a description if required.
  3. For the Target Component, select Ledger Balances Refresh.
  4. On the General tab, either select Yes for all business units, or select No then choose the required business unit.
  5. To notify you (or another recipient) by email when the process is run, in the Email Notification tab enable email notification, then enter the email address, then any text you want to be sent in email content.

    For more details, see Creating Process Profiles in Transfer Desk help.

  6. Also in Transfer Desk (TRD), to create an automation, select Yes for each ledger (A - K) that you want to be included in the balances refresh process.
  7. Select File > New Automation.
  8. Enter a name for the automation, for example, BalRefresh.
  9. Enter a description if required, for example Nightly Balances Refresh, then click Next.
  10. Select the required profiles and click Add to include them in the automation. Click Next.
  11. Edit the error handling settings as required, then click Next.
  12. Edit any required runtime parameters, or leave them as they are configured in the profiles. Click Finish.

    For more details, see Creating Automations in Transfer Desk help.

  13. Set up a task schedule on the computer being used for the refresh process. For example, in Windows 7 select Start > All Programs > Accessories > System Tools > Task Scheduler. Create a schedule, and enter the command line and parameters for the automation, as appropriate. For example: 
    C:\SunSystems\ssc\bin\AutomationDesk.exe -a BalRefresh -n -u UID -x PASSWORD

    For more details, see Scheduling Automations, Running Automations from a command line, both from Transfer Desk help.