Integration Configuration for Microsoft Dynamics GP (RIS ...
Integration Configuration for Microsoft Dynamics GP
This document intends to describe the above module / functionality of the CRIS System.
Author: Steve Jennings
Version: v1.2
Issue Date: 1st August 2014
Copyright 2014 Healthcare Software Systems. All Rights Reserved
These materials are or comprise restricted and proprietary confidential information of Healthcare Software Systems. Disclosure to or use by the recipient shall not convey any intellectual property rights in these materials. The right to use these materials by the recipient is subject to restrictions and limitations contained in the Provision of Integrated Care Record System and Associated Services Agreement and related agreements.
Document Control
|Title |Integration Configuration for Microsoft Dynamics GP |
|Author |Steve Jennings |Date 21/12/2011 |
|File Ref. |RIS_PD164_20910_MSGP_Integration Configuration.doc |
|Approval Sign-off (For formal issue) |
|Owner |Role |Signature |Date |Issue |
|Steven Verdon |Integration Services Manager | |13/04/13 | |
|Approver |Role |Signature |Date |Issue |
|Dr Julia Paul |Software Developer | |13/04/13 | |
| | | | | |
|Review Panel |
|Name |Role |
|Nick Woods |Integration Specialist |
| | |
|Change History |
|Issue |Date |Author / Editor |Details of Change |
|0.1 |21/12/2011 |Steve Jennings |First Draft |
|1.0 |01/05/2012 |Steve Verdon / Erik Simonsen |Standardised document control and contents. Approved for release |
|1.1 |13/04/2013 |Steven Verdon |Document review |
|1.2 |01/08/2014 |Steven Verdon |Document review |
Contents
1 Document Information 4
1.1 Scope 4
2 Configuration 5
2.1 Introduction 5
2.2 Installation 5
2.2.1 Required Hostname 5
2.2.2 Jar Files 5
2.2.2.1 Java 6 5
2.2.2.2 Java 5 6
2.2.3 Service.xml file 6
2.2.3.1 Available attributes 6
2.2.3.2 Example service.xml file 7
2.2.3.3 Example messages in xml format 8
2.2.3.3.1 Create Sales Invoice 8
2.2.3.3.2 Create Sales Return 10
2.2.3.3.3 Create Payables Invoice 13
2.2.3.3.4 Create Payables Credit Memo 15
3 Related Documents 17
4 Glossary 18
Document Information
1 Scope
This document contains the information required for configuring and maintaining the integration between CRIS and Microsoft Dynamics GP.
Configuration
1 Introduction
An interface between CRIS and Microsoft Dynamics GP has been developed, such that contractual information, including costings for items such as examinations, consumables, fees and commissions can be managed from within CRIS, and passed to GP each time the contract is invoiced.
2 Installation
The communication between the CRIS and MSGP systems takes place on the application server using JBoss, therefore all configuration is required to take place on the application server.
1 Required Hostname
The jar required for the integration has been packaged up with IMSDEV as the hostname of the webservice box.
Therefore IMSDEV needs to be added to the hosts file of the CRIS server, or be available on the DNS.
If there are ever any issues with IMSDEV as a hostname, the gplegacy.jar will need to be repackaged for a different name. Instructions on how to do this are
Compile the wsdl as follows
pathtometrobin\wsimport.sh -d destinationdirectory
Then package up the contents of the destination directory in the jar file gplegacy.jar
2 Jar Files
1 Java 6
If the server is running under Java 6, the following jar will need to be in the 05-hsslibs directory within the JBoss deploy directory.
gplegacy.jar
In addition the following jars
stax-api.jar
webservices-api.jar
webservices-extra-api.jar
webservices-extra.jar
webservices-rt.jar
webservices-tools.jar
wstx-services.war
should be placed in the endorsed directory, which can be found using the command
find / -type d -name "endorsed" 2> /dev/null
2 Java 5
If the server is running under Java 5, the following jars will need to be in the 05-hsslibs directory.
gplegacy.jar
stax-api.jar
webservices-api.jar
webservices-extra-api.jar
webservices-extra.jar
webservices-rt.jar
webservices-tools.jar
wstx-services.war
In addition, the following jars need to be removed from the default/lib directory of JBoss (You may just want to move them to a backup location).
jboss-jaxrpc.jar
jboss-saaj.jar
3 Service.xml file
A new service.xml file needs to be installed into the deploy directory of the JBoss running on the application server, in order to start listening and acting on SEND_INVOICE messages posted by the CRIS clients. These triggers are fired from the client whenever a new invoice is created or the user requests the trigger to be resent, which is an option in the IMS module.
The documents listed in the related documents section detail how and when this is done by CRIS.
1 Available attributes
|Attribute Name |Attribute Description |Mandatory |
|GPURL |The URL of the MSGP webservices installation |Yes |
|GPUserName |The user name for the MSGP webservices user |Yes |
|GPPassword |The password for the MSGP webservices user |Yes |
|Sites |The list of sites that should have the intregration to MSGP applies to. Leave|No |
| |blank if all sites should be affected. | |
|DefaultModality |The default modality to use when no modality can be obtained for a billed |No |
| |item. This may be a generic modality code and does not have to be in line | |
| |with a CRIS modality, it just makes up part 5 of the distribution code for | |
| |each SalesLineItem in MSGP. | |
|SalesBatchKeyPrefix |The prefix to use for the SalesDocument created within MSGP. |No |
| |This can be left blank, in which case the sales batch key will be a date | |
| |format in the form ddMMyy–dd. | |
|PayablesBatchKeyPrefix |The prefix to use for the PayablesDocument created within MSGP. |No |
| |This can be left blank, in which case the payables batch key will be a date | |
| |format in the form ddMMyy–dd. | |
|FeeNominalCode |The nominal code (3rd part of the distribution code) to use for all fees. |Yes |
| |This is mandatory as if not present, the distribution code for the fees with | |
| |not be created. | |
|CommissionNormalCode |The nominal code (3rd part of the distribution code) to use for all |Yes |
| |commissions. This is mandatory as if not present, the distribution code for | |
| |the commissions with not be created. | |
|SalesTaxScheduleKey |The key of the tax schedule to be used for normal SalesLineItems |No |
|SalesTaxExemptScheduleKey |The key of the tax exempt schedule to be used for SalesLineItems with a zero |No |
| |tax value | |
|PayablesTaxScheduleKey |The key of the tax schedule to be used for a normal PayablesDocument |No |
|PayablesTaxExemptScheduleKey |The key of the tax exempt schedule to be used for a PayablesDocument with a |No |
| |zero tax value | |
3 Example service.xml file
GPErrors
GPFromCris
HSS User
HSS Password
GPOUT
java:/LiveDBDS
HSS01
GM
SIMP
PMIM
70403
70401
5 Example messages in xml format
1 Create Sales Invoice
SD842IDC
1
GBP
210.00
2
GBP
252.00
2
1
0
CT 3 part scan
true
Each
GBP
42.00
2
SS
I-D-60103-11302-CT
false
NON IV
SALES
SS
1
20
I-D-90103-11302-CT
false
1
0
9
O-B-30201-00000-GM
false
GBP
42.00
2
2
O-B-20201-00000-GM
false
34
GBP
252.00
2
2012
2
2
-2147483648
0
0
0
GBP
42.00
2
UAT CUST 3 - INSURANCE
Abdomen,Ankle
INVOICE
UAT003
34
SIMP-020212-2
Uat - Harry Uat - Test Patient 1
CLAREWOOD HOUSE
CLAREWOOD DRIVE
CAMBERLEY
SURREY
GU15 3TE
1966
6
25
-2147483648
0
0
0
2012
2
2
-2147483648
0
0
0
MILTON KEYNES DIAGNOSTIC CENTRE
Mike - INSURANCE
UAT003
Uat - Harry Uat - Test Patient 1
12345TEST
BAIRD-SMITH SV
TEST12345
2 Create Sales Return
SC841IDC
1
GBP
210.00
2
GBP
252.00
2
1
0
CT 3 part scan
true
Each
GBP
42.00
2
SS
I-D-60103-11302-CT
false
NON IV
SALES
SS
1
20
I-D-90103-11302-CT
false
1
0
9
O-B-30201-00000-GM
false
GBP
42.00
2
2
O-B-20201-00000-GM
false
34
GBP
252.00
2
2012
2
2
-2147483648
0
0
0
GBP
42.00
2
UAT CUST 3 - INSURANCE
Abdomen,Ankle
INVOICE
UAT003
34
SIMP-020212-2
Uat - Harry Uat - Test Patient 1
CLAREWOOD HOUSE
CLAREWOOD DRIVE
CAMBERLEY
SURREY
GU15 3TE
1966
6
25
-2147483648
0
0
0
2012
2
2
-2147483648
0
0
0
MILTON KEYNES DIAGNOSTIC CENTRE
Mike - INSURANCE
UAT003
Uat - Harry Uat - Test Patient 1
12345TEST
BAIRD-SMITH SV
TEST12345
3 Create Payables Invoice
PD31IDC-1
PD31IDC-1
2011
10
24
-2147483648
0
0
0
GBP
708.00
2
Reporting Fee
PD31IDC
2 B Direct
PMIM-020212-2
2BD001
34
PS
6
24/10/2011 Uat - Mary Uat - Test Patient 5
a-D-70403-11303-MR
false
GBP
708.00
2
10
O-B-30201-00000-GM
false
34
GBP
141.60
2
2
O-B-30101-00000-GM
false
34
GBP
849.60
2
PS
GBP
141.60
2
4 Create Payables Credit Memo
PD33IDC-1
PD33IDC-1
2011
10
25
-2147483648
0
0
0
GBP
70.80
2
Reporting Fee
PD33IDC
2 B Direct
PMIM-020212-2
2BD001
34
PS
6
24/10/2011 Uat - Mary Uat - Test Patient 5
a-D-70403-11303-MR
false
GBP
70.80
2
10
O-B-30201-00000-GM
false
34
GBP
14.16
2
2
O-B-30101-00000-GM
false
34
GBP
84.96
2
PS
GBP
14.16
2
Related Documents
RIS_CRIB299l_02.09.10i_IMS_v1.0
RIS_CRIB299m_02 09 10i_Invoice_Management_System_User_Guide_v1.0
Glossary
|CRIS |The HSS RIS client interface application |
|GP / MSGP |Microsoft Dynamics Great Plains finance system. |
|IMS |The invoice management module of the HSS RIS Client interface application. |
-----------------------
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- microsoft dynamics 365 for finance
- microsoft dynamics 365 for finance and operations
- microsoft dynamics for operations
- microsoft dynamics 365 for financials
- microsoft dynamics 365 for operations
- microsoft dynamics gp 2018
- microsoft dynamics training for free
- microsoft dynamics tutorials for beginners
- microsoft dynamics crm for dummies
- dynamics gp vs business central
- microsoft dynamics gp review
- microsoft dynamics for sales