DonorHub ®
Bridging the information gap between you and your staff...

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

Table of Contents

Page Details

First published by:
Troy Wolbrink
on 14 Sep 2009
Last revision by:
Troy Wolbrink
on 23 Sep 2016
0 people found this article useful.

0% of people found this useful
What do all the placeholders in the Solomon IV 4.x data source template mean?

Filed under: [Edit Tags]

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

Recent Comments

By: TereAlvarez Posted on 15 Jun 2010 11:14 AM

When we click on tools there is no system set-up as a possibility in this menu, nor anywhere we have looked.....We are using TNTMPD.Dataserver 1.0.44

By: Troy Wolbrink Posted on 24 Aug 2011 6:47 PM

You must be a member of the roles: "Security Admin" or "Database Setup".

© 2018 TntWare | Privacy | Terms of Use