308-icloud

Integration – Invoice Cloud

Version 6.0

Overview

Governs’ Invoice Cloud integration provides an invoice presentation / payment solution using Invoice Cloud. With Invoice Cloud integration Govern users have 24/7 access to on-line bills and flexible payment options that include all major credit/debit cards and eChecks.
Invoice Cloud consists of 2 major areas. Batch Functions that can be scheduled to send Billing Information reports to Invoice Cloud and the AR & CC Cash Collection Service.

Requirement

Integration needed with invoice cloud. We need to make a new service that:
1. Allows Payments
2. Allows Payment Reversal
3. Update Paperless status for Mailing Index
4. GetArBalances
See AR/CC Web Service

The following actions are also needed:
1. Generate a Summary Account Balance and send it to an FTP
2. Generate a Detail Account Balance (bill) and send it to an FTP

Tax & UB Bill

Tax and Utility Billing PDF Bill

Account Balance Extract

Account Balance Extract is created and push to the FTP.
Work Order for Code: WALGOL1202
Crystal reports that show the balance for each NA_ID

Batch Processes

Consists of 2 batch process that generate reports in CSV format.

1) Batch process – Invoice Cloud Balance :
UI : ComboBox SubSystems (only RE, PP, UB)
Nb. Activity days Add to the report all entries in AR_Master having activities (all activities in AR_DETAIL except payment from InvoiceCloud) in the X last days of activity.

2) Batch Process – Invoice Cloud Invoice :
. UI : ComboBox SubSystems (only RE, PP, UB) ComboBox SubSystems (only RE, PP, UB)

a) subsystems : RE, PP :
UI : Year, Installment
File Name to generate : XXXXXX_RE_TimeStamp.csv or XXXXXX_PP_TimeStamp.csv

b) Subsystem : UB :
UI : ComboBox : Posting ID – Posting Date (From table UB_POST_MASTER)
File Name to generate : XXXXXX_UB_TimeStamp.csv

The Total Billed should be the Sum of Amounts from AR_DETAIL where type = ‘INV’ and having Creation_Date = Posting_Date

Supporting Documents

Click on the links below to view the .PDF document.

Right-click on the links below to down the view the .PDF document.

To download the Excel files below, either right click on the link and select “Save Link As…” from the menu, or click directly and select the option to open in Microsoft Excel.

To download the .CSV files below, right click on the link and select “Save Link As…” from the menu. The file may then be opened in an application like Microsoft Excel.

SQL for the INVOICE

SELECT "AR_MASTER"."SUB_SYSTEM", "AR_MASTER"."YEAR_ID", "AR_SUMMARY"."INSTALLMENT", "AR_SUMMARY"."AR_ID", "NA_MAILING_INDEX"."NA_ID", "NA_NAMES"."FREE_LINE_1", "NA_NAMES"."STREET", "NA_NAMES"."CIVIC", "NA_NAMES"."PRE_DIR", "NA_NAMES"."S_SUFFIX", "NA_NAMES"."POST_DIR", "NA_NAMES"."SEC_ADD_IND", "NA_NAMES"."UNIT", "NA_NAMES"."CITY", "NA_NAMES"."STATE", "NA_NAMES"."ADD_LINE_A", "NA_NAMES"."ZIP_POSTAL", "NA_NAMES"."EMAIL", "NA_NAMES"."NAME_2", "AR_MASTER"."SORT_KEY", "AR_SUMMARY"."PRINCIPAL", "NA_MAILING_INDEX"."SUB_SYSTEM", "NA_MAILING_INDEX"."PRIMARY_INDEX"
FROM (("Waltham"."dbo"."AR_MASTER" "AR_MASTER" INNER JOIN "Waltham"."dbo"."AR_SUMMARY" "AR_SUMMARY" ON "AR_MASTER"."AR_ID"="AR_SUMMARY"."AR_ID") LEFT OUTER JOIN "Waltham"."dbo"."NA_MAILING_INDEX" "NA_MAILING_INDEX" ON ("AR_MASTER"."P_ID"="NA_MAILING_INDEX"."REF_ID") AND ("AR_MASTER"."SUB_SYSTEM"="NA_MAILING_INDEX"."SUB_SYSTEM")) LEFT OUTER JOIN "Waltham"."dbo"."NA_NAMES" "NA_NAMES" ON "NA_MAILING_INDEX"."NA_ID"="NA_NAMES"."NA_ID"
WHERE "NA_MAILING_INDEX"."PRIMARY_INDEX"=-1 AND "NA_MAILING_INDEX"."SUB_SYSTEM"='UB'
ORDER BY "AR_SUMMARY"."AR_ID"

SQL for the BALANCE

SELECT "AR_MASTER"."SUB_SYSTEM", "AR_MASTER"."YEAR_ID", "AR_SUMMARY"."INSTALLMENT", "AR_MASTER"."AR_ID", "AR_SUMMARY"."AR_ID", "NA_MAILING_INDEX"."NA_ID", "NA_MAILING_INDEX_1"."NA_ID", "AR_SUMMARY"."BALANCE", "NA_MAILING_INDEX"."SUB_SYSTEM"
FROM (("Waltham"."dbo"."AR_MASTER" "AR_MASTER" INNER JOIN "Waltham"."dbo"."AR_SUMMARY" "AR_SUMMARY" ON "AR_MASTER"."AR_ID"="AR_SUMMARY"."AR_ID") LEFT OUTER JOIN "Waltham"."dbo"."NA_MAILING_INDEX" "NA_MAILING_INDEX" ON ("AR_MASTER"."P_ID"="NA_MAILING_INDEX"."REF_ID") AND ("AR_MASTER"."SUB_SYSTEM"="NA_MAILING_INDEX"."SUB_SYSTEM")) LEFT OUTER JOIN "Waltham"."dbo"."NA_MAILING_INDEX" "NA_MAILING_INDEX_1" ON ("AR_MASTER"."UB_ID"="NA_MAILING_INDEX_1"."REF_ID") AND ("AR_MASTER"."SUB_SYSTEM"="NA_MAILING_INDEX_1"."SUB_SYSTEM")
WHERE "NA_MAILING_INDEX"."SUB_SYSTEM"='RE' AND "AR_MASTER"."YEAR_ID"=2012 ORDER BY "AR_MASTER"."AR_ID", "AR_SUMMARY"."INSTALLMENT"

Installation of Web Services

Invoice Cloud Web Service (Release 5.1)

To install the following are the installation steps for the Invoice Cloud Web Service:

  1. Deploy the Release 5.0.9 of the Resources Files.
  2. Install and configure the WCF Accounts Receivable API [Filename: WCFAccountsReceivableAPI.zip].
  3. Modify the web.config file to use the GoverNetConfig.xml of the deployment [Location: In the root of the specific deployment folder]
  4. When installing Release 5.1 of the web service, administrators will need to manually create the following table in (Table: NA_NAMES: WEBPROFILEACCESSRT (Smallint, Allows Null). This field was added to provide support for the eGov and is used in the business rules of the Names.

Verification of the Service

The WcfTestClient.exe application is used to test the web service. This application can be obtained on the Govern FTP site or from Govern Technical Support: WCF Test Application.zip. For additional details regarding testing Govern Web Services

What’s New!

Release 6.0
The two (2) Govern batch processes that are associated with the Invoice Cloud process for Real Property and Personal Property modules have been modified to allow them to identify required InvoiceTypeID’s that match with AR Cycle codes for Real Property (RE) and Personal Property (PP). Release 1703.06

Prior to release 6.0 of the Govern Web service, manual changes were required to be made during the installation of the Invoice Cloud Web Service:

  • Modify the web.config to use the GovernNetConfig.xml file located in the deployment root directory.
  • Create (Table: NA_NAMES.WEBPROFILEACCESSRT), with properties set to (smallint, allow NULLS).

The above steps are no longer required, they are automatically created when the Database Verification process is run in the Govern New Administration (GNA).

Related Topic(s)

Govern API and Service

 

 

308-icloud

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

 

Govern – API and Services

Govern API & Services

Overview

Standard API Web Services

Govern’s standard API Web Services provide a communication and data exchange protocol to Govern Applications:

These services are distributed with a program called Mock-Up, to help the programmer test and make sure the correct information is received from the services.

Other Govern Web Services

Web services are used in OpenForms for:

Specification

In general:

  • Windows Communication Foundation (WCF) is an API in the .NET Framework.
  • Govern PC Web Services supports JavaScript Object Notation (JSON) serialization format to WCF.
  • Minimum System Requirements for IIS Servers and .NET Framework
  • IIS Server must be configured for each deployment (production, training, staging, tests…)
  • Govern Services are stand-alone programs that need to be installed separately.
  • API services downloads are zip files and a zip converter is required to install.
NOTE: Although the WCF PC Web Services supports (JSON), Harris Govern does not provide technical developer support for this type of implementation.

Configuration

In the Windows setup screen “Turn Windows features on or off”, accessible from the Control Panel, there are some IIS options to activate:

1. NET Framework WCF Services HTTP Activation

IIS WCF Services HTTP Activation.png

2. Internet Information Services (IIS)

IIS Config 1.png

IIS Config 3.png

3. Next, run the Govern WcfServices exe:
X:Install Package6.1WCF Services Setup

MS Govern WCF Services Setup.png

MS Govern WCF Services Installation.png

4. The IIS Application is installed and can be browsed:

IIS Browse.png

When clicking Browse, the service web page is open at the address:
https://localhost/GovernWcfServices_CMSDEMO_CAMA_60_2ZR8CZ1_SQL/

Click on the service name PropertyControlService.svc, you go to the service page. Copy-paste the link
https://localhost/GovernWcfServices_CMSDEMO_CAMA_60_2ZR8CZ1_SQL/PropertyControlService.svc

IIS Service Hyperlink.png

inside the WCF Test Client, located at: C:Program Files (x86) Microsoft Visual Studio 14.0/Common 7/IDE/WcfTestClient.exe:

WCF Test Client.png

You can then test any method from the service contract by clicking on it and set its parameters up.

Download and Install

As of 6.0, Deploy-EZ, can be used to download the standard Govern API WCF bundle (PC&GIS, AR&CC) and the Govern Scheduler Service.

  • Download Binaries for the required release (4.7, 5.1, 6.0., 6.1…)
  • Install for each Deployment (Production, Test, Train, Stage…)

For Govern e-Government or other Custom Services

  • Contact Harris Govern for FTP download information

For Harris Govern Employees, packages are located in GOVERN’s DEPLOYMENT SERVER, in the INSTALL folder by version.

What’s New

  • [6.0] New Govern Batch Scheduler Service (403) installation and automatic Service stop and restart for updates.
  • [6.0] The PC/GIS (401) and AR/CC (402) web services installation package have been bundled together.
  • [6.0] The installation pack can be downloaded via DeployEZ.

PC & GIS Web Service (401)

This service is used to load or create information in property control. It also establishes communication between Govern and a GIS system.
Click here for more information.

A/R & CC Web Service (402)

This service is used when cash is collected via a third party software.
Click here for more information.

Batch Scheduler Services (403)

Govern OpenForms Scheduler uses the following services:

  • Batch Scheduling
  • Batch Execution (Windows Services)

Click here for more information.

 

 

400-api

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR / CC – API Web service

Accounts Receivable (A/R) & Cash Collection (CC) API WEB Service

Overview

The Govern Payment Notification Web Service service is mainly used when cash is collected via a 3rd party software.

Installation and Setup

In Deploy-EZ:

  • Download the Binaries for the required release (4.7, 5.1, 6.0., 6.1…)
  • Deploy and Install the Govern WCF Service (Standard bundle with PC&GIS, AR&CC) for each deployment

For more information, see Download and Install on Govern API and Services main page.

What’s New!

AR Web Service for Key Bank (TM)

Key Bank’s web-based CSR Application (Payment Center) is used to process credit card transactions from cashiering stations. Govern provides a Payment Notification Web Service that can be utilized by Key Bank’s payment processing applications; Govern is used for Cash/Check transactions. In order to accommodate this process, a new method (AR_ExecutePaymentKeyBank) was added to the Govern A/R Web Service to support the Key Bank payment notification. This method uses key-value pairs as input parameters. For method details, refer to the updated Govern Accounts Receivable and Cash Collection API Web Service document. See Documentation section below.

Documentation

 

 

402-arccservice

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Web Browser Integration

Web Browser Integration (WBI)

Overview

The OpenForms Application Browser form technology is a form that is based on the Web Browser OpenForms technology. This form can be used as a container for simple, e.g. Web Browser, to complex integrations such as MATIX, a GIS solution from Harris Govern.
An unlimited number of forms can be set up to meet the requirements for displaying spatial, and tabular content of profile users. In addition, an unlimited number of Application Browsers can be configured in a form. Forms can be set up with options that can include the following Key Types, e.g. Parcel ID, Name ID as well as Unformatted Tax Map). Other options include configuration by GIS Server URL, through Synchronization Options, and by Viewing Tabular Data.

Form basic integration, Web Browser Integration (WBI) can be used for adding an interactive website to Govern OpenForms. For example, you could use WBI to add a Geographic Information Services (GIS) web browser interface, such as the Govern GIS Explorer, to a Govern user form and Profile. You could then select records in Govern and view them on the GIS interface. You could also select records on the GIS interface and load them to the Govern Treeview, with the option to set up manual or automatic synchronization between Govern and the website.

The WBI control is added to a custom entity in the Govern OpenForms Designer (OFD). All the configuration is performed in the OFD including any related security settings.

WBI is supported by most websites. It is fully integrated with Govern. It implements predefined commands to add the following functionalities:

  • Loading all records from the Govern treeview to the website
  • Loading the active record in Govern to the website
  • Replacing all records in the Govern treeview with a list provided by the website
  • Replacing the active record in Govern with a list provided by the website

Configuration

Custom entities are used for adding specific predefined controls to a Govern form. In this case, a custom entity is used for adding Web Browser Integration (WBI) functionality. A custom entity cannot stand alone. It needs to be added to an existing form. The form must be added to Profile.
You can add the same custom entity to multiple forms, and add the forms to multiple Profiles, if required.

You need to select a Parent Entity for your new custom entity. Usually, this is the Root Entity.

The following rules apply:

  • The WBI control must be added to a custom entity.
  • The custom entity must be added to an existing form.
  • The form must be added to a Profile.
  • The Dataset Type Code for the Profile must be set to Parcel ID (P_ID) or the Name ID (NA_ID), and must correspond to the value set for the SelectedKeyType.
  • The Dataset Type Code is shown in the following screen shot:

Documentation

Click on the link below to view a .PDF containing details about Web Browser Integration and configuration procedures.
Adding and Configuring WBI

Video Demonstrating Test Tool

A video demonstrating how to test the  integration will be be posted below shortly.

Click here to view the How To demo video

What’s New!

Web Browser Integration (WBI) was introduced in Govern 6.0. As of Govern OpenForms version 6.0.1405, it is used for integrating the Govern GIS Explorer with Govern.

NOTE: The WBI control is used for integrating GIS functionality with Govern as of Govern OpenForms 6.01.1405

Troubleshooting

Any issues that may be related to the Web Browser Integration form will be listed below.

No Access to the Wiki (Log In Error)

Symptom

This error displays a Script Error screen which appears on top of a Wikispaces sign in screen.

Resolution

A solution to resolving this error is to log in to the Wiki prior to launching Govern. When you have successfully logged into the Wiki, start Govern and open the form with the Web Browser Integration form.

Related Topics

 

 

101-std-frm-003-WebBrowserIntegration

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Web Site Manager

Web Site Manager

Overview

With the GNA Web Site Manager or Manage Web Site form, you can create a look and feel for each of your Web sites by assigning WebSkins to the eProfile and the eComponents. Each application can be assigned a different skin to provide a different look and feel.
For details about using the Web Site Manager, refer to the eGovern Public Self Service Portal Release 5.1 user guide. See e-Government (Public Web Portal)

 

 

103-ap-004

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...