ISolved Keystone Integration

Overview

GivenHansco has developed an integration between iSolved Payroll and Keystone financials (G/L, C/M and J/C.) This integration makes use of the iSolved API to allow transfer of payroll data directly from iSolved into Keystone transaction batches. Once transferred these batches can be reviewed and/or posted.

This integration requires Keystone 4.7.12 or higher.

Configuration

iSolved Information

The first step in configuring the integration is to obtain the following information from iSolved for the customer:

• Client Code

There is a spreadsheet containing the client codes for Keystone customers located here. If the customer is not on this list obtain their Client Code from iSolved and add it to the list.

• URL

For customers who were already on Keystone prior to signing up with iSolved, they will use the GivenHansco URL which is built into the integration.

For customers who were signed up with iSolved prior to becoming a Keystone customer, they will use a different URL which must be provided by iSolved.

• Client Credentials (Client Id/Client Secret)

For customers who were already on Keystone prior to signing up with iSolved, they will use the GivenHansco client credentials which are built into the integration.

For customers who were signed up with iSolved prior to becoming a Keystone customer, they will use a unique set of credentials which must be provided by iSolved.

• Other

(TBD)

Keystone System Options

There are several system options that must be configured. These options are located under General Ledger->Import Payroll Options.

For most configurations only two options need to be specified:

• ISolved API Credentials (client_code)
• ISolved Default JC TrxType

Option Name	Required	Type	Allowed Values	Default	Comment	Keystone Version
ISolved API Credentials	client_code	Memo	base_url=<Base URL> client_code=<Customer Client Code> client_id=<Customer Client Id> client_secret=<Customer Client Secret>	base_url=<GH Base URL> client_id=<GH Client Id> client_secret=<GH Client Secret>	(see below)
ISolved Default JC TrxType	Yes	Lookup (J/C Trx Types)		(none)	Default J/C Trx Type for J/C transactions
ISolved JC Hours U/M		Lookup (A/R Units of Measure)		HR	J/C Unit of Measure
ISolved GL Category (Check)		String		Check	Item Category representing check G/L items
ISolved GL Category (DirDep)		String		DirDep	Item Category representing direct deposit G/L items
ISolved GL Category (Earn)		String		Earn	Item Category representing earning G/L items
ISolved GL Category (Impound)		String		Impound	Item Category representing impound G/L items
ISolved GL Category (Invoice)		String		Inv	Item Category representing invoice G/L items
ISolved GL Category (Other)		String		Other	Item Category representing other G/L items
ISolved GL Consolidation by Item Category		List	None,All,All except Check/DirDep,All except Check/DirDep/Earn,Only Impound/Inv/Other	All except Check/DirDep/Earn	Controls consolidation of G/L transactions
ISolved Labor Code		String		EARN	Labor Code to process when importing J/C transactions
ISolved Labor Title (Asset)		String		Job Asset	Labor Title containing J/C Asset Id
ISolved Labor Title (BudCat)		String		Job Budget Category	Labor Title containing J/C Budget Category
ISolved Labor Title (Job)		String		Job	Labor Title containing J/C Job Id
ISolved Labor Title (TrxType)		String		Job Trx Type	Labor Title containing J/C Trx Type

Keystone Security Options

Users must have certain security options enabled to be able to import transactions to the three modules (G/L, C/M and J/C):

• To import G/L transactions, the General Ledger Active and General Ledger Installed system options must be True.
• To import C/M transactions, the Cash Management Active and Cash Management Installed system options must be True. Additionally, the user must have security permission for the Cash Management menu.
• To import J/C transactions, the Job Cost Installed system option must be True. Additionally, the user must have security permission for the Job Cost menu.