Rules of operation when importing balance sheet movement data

The selection of Balance Sheet Account Amounts - Period Movement instructs OpenLink to accumulate Balance Sheet movement data to produce Period End Balances that are written to the database. These rules are used to produce Period End Balances.

These rules are for data loads using the Overwrite Stored Data that are reading from a source table. This option replaces the value in the database with the value found in the source table or view for the period.

• When the source table only contains one period, OpenLink reads the prior period's balance, adds the current period import value and writes the result to the database.
• When loading an individual period from a source table, OpenLink cannot identify a missing schedule line because of no period activity and does not update the database. To have an account's Period End Balance calculated, include it in the source table with a movement value of Null or zero (0).
• When loading multiple periods including the first period from a source table, OpenLink requires a P0 value representing the opening balance amount. This could also be referred to as the sum of all prior years' activity for the balance sheet amount.
• When loading a multiple periods from a source table, OpenLink identifies every period contained in the table. It then uses the available movement values for each schedule line contained in the table to calculate the period end balances for each period encompassed in the source table.
  • A schedule line has to have at least one entry in the source table to be updated.
  • Every target period must have one entry in the source table.