DonorHub Lite includes a template to support Microsoft's Solomon accounting system. Using this template, you simply need to fill out a few placeholders, and you're up and running quickly. To get to this template, under the "Tools" menu, click on "System Setup", then click on the "DataSources" tab.
$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$
These placeholders are used to establish a connection to SQL Server. Provide the server name and the name of the Solomon application database, as well as the SQL Server login and password. To test this, use SQL Server Management Studio. The $LOGIN$ should not be confused with a Solomon login which has nothing to do with a SQL Server login. The SQL Server account used must have read access to the tables in the database.
$COMPANY_ID$
This is seen on the Solomon login screen.
$LEDGERID$
This is usually "ACTUAL".
$BEGINNING_BALANCE_ACCT$
This is the GL account used for carry over balances to start the fiscal year.
$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$
These placeholders may be left blank. However, if you'd like for their to appear to be sub accounts (Responsiblity Centers) for advances, then you may fill in these placeholders. For example, if there were a sub account "1000", you could have a sub account also appear to TntMPD.DataServer as "1000-Advances", and this newly generated (fake) account would contain transactions related to advances for sub account "1000".
If you prefer English, you could set $FIN_ACCT_ADV_SUFFIX$ to "Advances". Feel free to set this to whatever makes the most sense in your organization.
$ADVANCE_ACCT_PREFIX$ is whatever prefix would define the GL account(s) for advance transactions. (In Campus Crusade for Christ, this would typically be "12".)