When migrating a BVE database to Spire, sometimes you can arrive at an error described as "NoneType object has no attribute opening_balance" which is related to the "rollup currency revaluations" phase of the migration.  The problem is orphaned revaluation accounts that are no longer needed.

Step-by-step guide

Please attempt to migrate the BVE data to Spire before following these steps (i.e. you should have arrived at the error message already).

  1. If you need to, please see documentation on Google for more information about running SQL commands in pgAdmin against a PostgreSQL database.
  2. Open the partially migrated database in pgAdmin and run the following SQL command:

    delete from gl_accounts where translation = 'R';

  3. Open the Spire Tray app and select the italicized (partially upgraded/migrated) database.
  4. Select the "File" menu's "Upgrade Database" option to continue the migration process.