What do all the placeholders in the Solomon IV 4.x data source template mean?

Troy Wolbrink — Sat, 01 Jun 2019 20:08:09 GMT

Current revision posted to Frequently Asked Questions by Troy Wolbrink on 6/1/2019 8:08:09 PM

What do all the placeholders in the Solomon IV 4.x data source template mean?

Filed under: IntegrationIntegrations

DonorHub 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.

These are the placeholders to fill out to make the connection:

$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 DonorHub 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 many organizations, this would typically be "12".)

What do all the placeholders in the Solomon IV 4.x data source template mean?

Troy Wolbrink — Sat, 01 Jun 2019 20:07:57 GMT

Revision 5 posted to Frequently Asked Questions by Troy Wolbrink on 6/1/2019 8:07:57 PM

What do all the placeholders in the Solomon IV 4.x data source template mean?

Filed under: TemplatesIntegration

DonorHub 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.

These are the placeholders to fill out to make the connection:

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$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$

What do all the placeholders in the Solomon IV 4.x data source template mean?

Troy Wolbrink — Sat, 01 Jun 2019 19:57:11 GMT

Revision 4 posted to Frequently Asked Questions by Troy Wolbrink on 6/1/2019 7:57:11 PM

What do all the placeholders in the Solomon IV 4.x data source template mean?

Filed under: Templates

DonorHub Liteincludes 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

These are the "Tools" menu, click on "System Setup", then click on placeholders to fill out to make the "DataSources" tab.connection:

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$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 DonorHub as "1000-Advances", and this newly generated (fake) account would contain transactions related to advances for sub account "1000".

What do all the placeholders in the Solomon IV 4.x data source template mean?

Troy Wolbrink — Fri, 23 Sep 2016 04:03:53 GMT

Revision 3 posted to Frequently Asked Questions by Troy Wolbrink on 9/23/2016 4:03:53 AM

What do all the placeholders in the Solomon IV 4.x data source template mean?

Filed under: Templates

TntMPD.DataServer

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$

$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".

What do all the placeholders in the Solomon IV 4.x data source template mean?

Troy Wolbrink — Mon, 14 Sep 2009 18:04:46 GMT

Revision 2 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2009 6:04:46 PM

What do all the placeholders in the Solomon IV 4.x data source template mean?

Filed under: Templates

TntMPD.DataServer 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$

$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 account(s) for advance transactions. (In Campus Crusade for Christ, this would typically be "12".)

What do all the placeholders in the Solomon IV 4.x data source template mean?

Troy Wolbrink — Mon, 14 Sep 2009 18:02:00 GMT

Revision 1 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2009 6:02:00 PM

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$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 for advance transactions. (In Campus Crusade for Christ, this would typically be "12".)

What do all the placeholders in the Solomon IV 4.x data source template mean?

What do all the placeholders in the Solomon IV 4.x data source template mean?

What do all the placeholders in the Solomon IV 4.x data source template mean?

$SERVER$$APP_DATABASE$$LOGIN$$PASSWORD$

$COMPANY_ID$

$LEDGERID$

$BEGINNING_BALANCE_ACCT$

$FIN_ACCT_ADV_SUFFIX$$ADVANCE_ACCT_PREFIX$

What do all the placeholders in the Solomon IV 4.x data source template mean?

What do all the placeholders in the Solomon IV 4.x data source template mean?

$SERVER$$APP_DATABASE$$LOGIN$$PASSWORD$

$COMPANY_ID$

$LEDGERID$

$BEGINNING_BALANCE_ACCT$

$FIN_ACCT_ADV_SUFFIX$$ADVANCE_ACCT_PREFIX$

What do all the placeholders in the Solomon IV 4.x data source template mean?

What do all the placeholders in the Solomon IV 4.x data source template mean?

$SERVER$$APP_DATABASE$$LOGIN$$PASSWORD$

$COMPANY_ID$

$LEDGERID$

$BEGINNING_BALANCE_ACCT$

$FIN_ACCT_ADV_SUFFIX$$ADVANCE_ACCT_PREFIX$

What do all the placeholders in the Solomon IV 4.x data source template mean?

What do all the placeholders in the Solomon IV 4.x data source template mean?

$SERVER$$APP_DATABASE$$LOGIN$$PASSWORD$

$COMPANY_ID$

$LEDGERID$

$BEGINNING_BALANCE_ACCT$

$FIN_ACCT_ADV_SUFFIX$$ADVANCE_ACCT_PREFIX$

What do all the placeholders in the Solomon IV 4.x data source template mean?

What do all the placeholders in the Solomon IV 4.x data source template mean?

$SERVER$$APP_DATABASE$$LOGIN$$PASSWORD$

$COMPANY_ID$

$LEDGERID$

$BEGINNING_BALANCE_ACCT$

$FIN_ACCT_ADV_SUFFIX$$ADVANCE_ACCT_PREFIX$

What do all the placeholders in the Solomon IV 4.x data source template mean?

$SERVER$$APP_DATABASE$$LOGIN$$PASSWORD$

$COMPANY_ID$

$LEDGERID$

$BEGINNING_BALANCE_ACCT$

$FIN_ACCT_ADV_SUFFIX$$ADVANCE_ACCT_PREFIX$

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$

$SERVER$
$APP_DATABASE$
$LOGIN$
$PASSWORD$

$FIN_ACCT_ADV_SUFFIX$
$ADVANCE_ACCT_PREFIX$