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.

Google Online Preview   Download