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

CC – Cash Collection Module – What’s New

Cash Collection (CC) – What’s New

Version 6.0 | Version 6.1

Overview

As of General Availability Release 6.0 and 6.1 version 1603 and higher, the centralized Cash Collection module is available.
For more information, see also:

The following is a non-exhaustive compilation that lists recently updated topics related to the Govern for OpenFormsTM Centralized Cash Collection module.

 

What’s New

CC – Cash Collection Module

Cash Collection Module Overview Cash Collection is used for accepting and processing the following transaction types in person, usually at

Posted in Cash Collection | Tagged , , , , , | Leave a comment

CC – Cash Collection Wizard Flow

Cash Collection Form – Cash Collection Wizard Flow Version 6.0 | Version 6.1 Overview Payment ‘Monies’ Distribution The following functionality

Posted in Cash Collection, Form | Tagged , , , , | Leave a comment

CC – Batch Deposit Selection & Creation Form

Cash Collection (CC) Form – Batch Deposit Selection & Creation Version 6.0 | Version 6.1 Overview The following is a

Posted in Cash Collection | Tagged , , , , , , , , , | Leave a comment

CC – Misc. Cash Receipt Feature

Cash Collection (CC) Form – Misc. Cash Receipt Feature Version 6.0 | Version 6.1 Overview The following is a feature

Posted in Cash Collection, Feature | Tagged , , , , | Leave a comment

CC – Payor Additional Information

Cash Collection Form – Payor Additional Information Form Version 6.0 | Version 6.1 (In Development) Overview The following is a

Posted in Cash Collection, Form | Tagged , , , , | Leave a comment

CC – Deposit Payment Entry Form

Centralized Cash Collection Form – Deposit Payment Entry Version 6.0 | Version 6.1 (In Development) Overview The following is a

Posted in Cash Collection, Form | Tagged , , , , | Leave a comment

CC – Post Dated Payment Form

Cash Collection (CC) Form – Post Dated Payment Feature Version 6.0 | Version 6.1 (In Development) Overview The following is a

Posted in Cash Collection, Feature | Tagged , , , , , | Leave a comment

Old News

(101-cc-wnew)

Read More...

Changes to SY Registry

Changes to Payer Name Data Entry

6.0.1611 A change was made to the payment data entry cash collection form PAYER Name.
When creating a new payer for a payment, it is now possible to configure the controller to open the Name and Address form directly. Requires configuration to existing forms

Changes to SY Registry

Distinct separation of CSI Pay and Forte POS parameters in Cash Collection section of SY Registry (OpenForms General Settings form).

  • 6.0.1606 CSI Pay / Forte POS parameters, with switch to select POS Provider
  • 6.1.1606 CSI Pay / Forte POS parameters, with switch to select POS Provider

General

Cash Collection Module Available on OpenForms

  • 6.0.1603 Basic Functionalities are now available
  • 6.0.1511 Beta version available

Govern OpenForms

New Govern IDs

  • 6.0.1603 Batch_ID was added in the AR Batch No table
  • 6.0.1603 CC_ID was added as a Govern ID

Database Changes

  • 6.0.1603 Batch_ID (PK) will be added to CC_MASTER and AR_BATCH_NO table
  • 6.0.1603 Payer_Name added to CC_MASTER – Verify it was Added to Impact list DB changes

Standard Features

Cash Collection Payer Name

  • 6.0.1511 When you enter the name directly on the form, it will be recorded in the new payer field instead of the notes. If an existing name is selected, the Name ID will be recorded.
  • 6.0 Proportional Distribution is deprecated
  • 6.0 Administrator Log-on

Dynamic Queries

The following system search queries have been added and will be now be distributed when importing the Dynamic Queries.xml file.

  • Search Group
    • A/R Payment Data Entry
  • Search Styles
    • By Name
    • By SRT Account
    • By Tax Payer Account No.
    • By Name ID
    • By Address
    • By Names Linked to a Parcel ID
    • By Names Linked to a Current Parcel

 

 

101-cc-wnew

 

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

CC – Cash Collection Wizard Flow

Cash Collection Form – Cash Collection Wizard Flow

Version 6.0 | Version 6.1

Overview

Payment ‘Monies’ Distribution

The following functionality is a feature of the standard Cash Collection Form. The Payment Data Entry Monies Collection form or popup modal – or dockable window -activated by xx, or entity group is used to process the PAYMENT COLLECTION workflow. Note: Big percent of money to collect (75-90%) is probably by bar code and credit card.
The primary purpose is to finalize the payment collection process, by distributing/allocating the TOTAL TO BE PAID by different or multiple payment type source (cc-type). e.g 500 in Cash, a remaining portion or 500 on a Credit Card and a remaining balance settled on a secondary Credit Card or debit card.

Under construction. See Developer’s Page

Specification and Features

Features includes:

  • Workflow wizard processing
  • Credit Card processing
  • Check Validation and more ….

Configuration

The following configuration must be setup:

Security

Details to be supplied.

 

 

101-cc-frm-006

 

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

CC – Batch Deposit Selection & Creation Form

Cash Collection (CC) Form – Batch Deposit Selection & Creation

Version 6.0 | Version 6.1

Overview

The following is a feature of the Cash Collection Form. See also the standard A/R Deposit Form (stand-alone) that is used throughout the Accounts Receivable module.

Batch Deposit Management

The Cash Collection Form root entity AR_DEPOSIT is the entry point and it is used to create or select an existing batch deposit number.
This is a standard OpenForms (added fields, calculated amounts, etc. can be created and added to the form).

General Information

  • Deposit Number: This field displays the current cashier’s Deposit Number.
  • User ID: This field displays the current user id
  • Cashier ID. This field displays the Cashier’s identification code as previously defined on the Cash Collection Parameters in Govern Admin. – to be validated
  • Linked Deposit Number:
  • Transaction Type:
  • First Receipt: This field displays the first Receipt number used by the cashier for the deposit. – deprecated
  • Last Receipt: This field displays the last Receipt number used by the cashier for the deposit. – deprecated

Deposit Totals

This section displays the total deposit breakdown previously saved by the cashier, before they are posted. See 101-cc-OFR System Queries:

  • Total Collected: This field displays the total amount collected (system query)
  • Total A/R: This field displays the total amount of the collected Accounts Receivable (system query)
  • Total Pen / Int. This field displays the total collected penalties and interest. (system query)
  • Total Charges : This field displays the total charge amounts collected (system query)
  • Total Over/Dup: This field displays the total amount of Overpayment or Duplicate payment that are accrued and collected
  • Total Discount: This field displays the total discount amounts (system query CC)

Search by Receipt Number Feature

  • Under Review – See 101-cc-fea-005
  • Action Button to search by Receipting Group for a specific Receipt Number – replaced by the standard browse/Entity Search
  • Receipting Group drop down table (Tables: USR_KEY_RECEIPT and USR_USERFILE). deprecated

OpenForms Action Buttons

  • Browse: OF Standard Browse used to list all the NON POSTED Batch Deposits. Fields appearing in the list and position of the scrolling grid can be customized.
  • Delete: A deposit that contain payments or other transactions CANNOT be deleted – to validate
  • New: A deposit can be created by the user (all users can – validate security?).
    • Note: Depending on the Default Deposit Management options, the number is normally generated automatically.
    • The default deposit number is normally made up of a UserID and appended with an optional date.

Parameters

Deposit Management General Parameters

  • Configured in Govern Administrator, Application Settings, AR Deposit General Parameters
  • Prevent Override Option

    • If the Prevent Override of the Deposit Number option is selected in …. BEHAVIOR to be validated

 

Setting Up Security

The security setup is performed in the OpenForms Designer (OFD).
101-cc-frm-007-ui.png

Deposits

  • In OpenForms Designer (OFD), Select the CC001 Cash Collection Form, Click on the Deposit Management Entity (TAB), Click on the Security Mode
  • Select the Role or User, Profile and Security Mode (Regular)

On the Deposit Management Entity, the following standard security options are available:

  • View (eye): To view or not this entity or form TAB
  • Create (plus): To create new deposits
  • Modify (pen): To modify deposit information
  • Delete (garbage bin): Ability to delete deposits (if no payments are recirded)
  • Browse (list): Ability to show the browse screen

Special Security

  • Special (down arrow): Abiltity to see ALL deposits (default is deposits created by the user)

 

Cash Collection Form (Security Manager)

You can restrict the use of the Form

  • By profile (form is not linked to it)
  • By roles
  • By users

 

 

101-cc-frm-007

 

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

 

CC – Misc. Cash Receipt Feature

Cash Collection (CC) Form – Misc. Cash Receipt Feature

Version 6.0 | Version 6.1

Overview

The following is a feature of the Cash Collection Form.

Miscellaneous Cash Collection

A Miscellaneous Cash Receipt (MCR), is a receipt of cash that is paid as a penalty or a fee, that is not covered by other categories.

This payment can be applied toward a customer’s balance or an individual invoice.
An example of an MCR might be a fee for an Non Sufficient Fund (NSF) check, an administrative handling charge, a vehicle rental surcharge, a late return fee, a report charge, etc.

Expand the MCR section of the form to create a new Miscellaneous Cash Receipt entry.

  • Class Code: This field allows the User to select a Class Code for a miscellaneous cash receipt item (Table: VT_USR_AR_CLASS).
  • Class Amount: Enter the miscellaneous cash receipt value to be added to the payment.
    • Note: Depending on the Class Code selected and the Transaction Type associated with it, there may be a Default Amount displayed.
      The Default Amount is used in combination with only two of the Transaction Types: Blank or Adjustments. (Miscellaneous Cash Receipt type to be verified)

Configuration

The following information needs to be con figured in order to use Miscellaneous Cash Receipt:

Miscellaneous A/R Class Codes Groups
To speed up data entry, it is possible to add a group of miscellaneous cash receipt charges.
The groups are setup in a user validation table (Table MCR_GRP).
The A/R Class Codes are then linked to this group in the A/R Class parameters.

A/R Class Codes
The class codes must be defined by year with a transaction type of Miscellaneous Cash Receipts. à
General Ledger distribution accounts are linked to the A/R class.

 

 

101-cc-frm-008

 

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

CC – Payor Additional Information

Cash Collection Form – Payor Additional Information Form

Version 6.0 | Version 6.1 (In Development)

Overview

The following is a feature of the Cash Collection Form.

Payer Additional Information

The following information can be entered.

  • Letter Code

    • Select a code that identifies the type of letter the payer will receive, such as, duplicate payment, over payment or payment reversal (Table: VT_USR_LETER_C).
    • Use to record and process payment paid under protest or payment requiring a follow-up letter ….
  • Payor Notes

    • Unlimited notes can be entered

Configuration

In order to use the letter codes, the following information needs to be setup.

T/C

 

 

101-cc-frm-009

 

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

CC – Voluntary Payments in Cash Collection

Voluntary Payments in Cash Collection

Version 6.0 | Version 6.1 Scheduled for 6.0.1611

Overview

Use the Govern OpenForms Cash Collection user form to accept advance or voluntary payments on Real Property and Personal Property tax accounts.

An Advance Payment or Voluntary Payment (VP) is an amount that is paid before a bill is received. This type of transaction can be useful for taxpayers who would like to cover bills during a predicted absence.

When a voluntary payment is saved, an Open Cash Credit (OCH) is automatically generated. When you post the Voluntary Payment (VP) using the Cash Collecting Posting batch process, the Open Cash Credit (OCH) is also posted. It is applied on the next bill generated for the account. The VP and OCH transactions can be viewed in the Detail section of the A/R Inquiry form, both before and after they are posted.

This wiki page describes the following:

  • Administrative Setup
  • Configuration
  • Setting Security on Cash Collection Parameters
  • Processing a Voluntary Payment
  • Viewing the Voluntary Payment Transaction in A/R Inquiry
  • Posting the Voluntary Payment

 

Documentation

To view the information on this page in pdf format, click on the following link.

CashCollectionVoluntary.pdf

Related Information

For further information, see the Cash Collection Form

Business Rules

Accounts

In Govern OpenForms, a Voluntary Payment can be applied on an account from any year, regardless of whether there is a balance or not.
An AR_ID must already exist for the person or property associated with the payment.

In Govern OpenForms, a Voluntary Payment can be applied on a transaction from any year, regardless of whether there is a balance or not.

Subsystems

The voluntary payment option is available to Real Property and Personal Property tax.

Administrative Setup

General Parameters

The following User Registry parameters are specific to Cash Collection:

  • Show Only Accounts with Balance
  • Year to Collect

These parameters are available on the User Registry Manager in Govern and in GNA > Application Configurations > Accounts Receivable > Cash Collection Parameters.

Showing Transactions for a Specific Year Only

In Govern OpenForms, Voluntary Payments can be accepted for any year. If you want to display existing transactions for a specific year only, perform the following set in the Cash Collection Parameters available in Govern.
To create a filter by year:

  1. Launch Govern.
  2. Open a Profile that contains the Cash Collection form.
  3. Select the Payment Data Entry tab.
  4. Click the Cash Collection Cashier icon.
    The Cash Collection Options form opens.
  5. Enter the year that corresponding to the transactions that you want to display in the Year to Collect parameter.
  6. Click Save.

Print Receipt

Follow the instructions for setting up the Print Receipt report as described in the Cash Collection documentation. See Print Receipt.

Configuration

The Cash Collection form contains custom search parameters for Real Property and Personal Property voluntary payments.
To view or modify the configuration for these custom searches:

  1. Launch the Govern OpenForms Designer (OFD).
  2. Open the Cash Collection form (CC01).
  3. Select the Payment Data Entry entity.
  4. Select the CCPaymnetDataEntry_Control.
  5. Expand Properties > Misc in the Properties explorer.
  6. Select AR008 – Accounts Receivable in the A/RInquiryForm parameter.
  7. Select arPayment – A/R Payment Data Entry in the SearchGroup parameter.
  8. Select ppPersonalP – Personal Property Search in the VpSearchGroupForPP property.
  9. Select pcProperty – Property Search in the VpSearchGroupForPP property.
  10. Click Save if you have made any changes.

Setting Security on Cash Collection Parameters

The security settings for Voluntary Payments are the same as for any Cash Collection transaction. This section describes those settings:
To view the security settings for Cash Collection:

  1. Launch the Govern OpenForms Designer.
  2. Open the Cash Collection form (CC01).
  3. Select the Payment Data Entry entity.
  4. Select the Security icon.
  5. The Payment Data Entry form includes the Cash Collection Payment Data Entry custom control, CCPaymentData_Control.
    As with all security permissions in the OFD, the majority of these settings are enabled by default. The option to Apply Late Charges is the exception.
    The settings are as follows:
    Can Edit Payment
    Can Edit Principal
    Can Edit Interest
    Can Edit Penalty
    Can Edit Fee
    Can Edit Discount
    Can Edit Change
    Can Edit Demand
    Allow Misc. Cash Receipts
    Allow A/R Cash Distribution
    Allow Apply Late Charges: This setting is disabled by default.
  6. Modify these permissions as described in the OpenForms Designer documentation.
    Note: Permissions must be defined separately for every combination of Security Type, Profile, and Role or user.
  7. Click Save if you have made any modifications.

Creating a Voluntary Payment

Voluntary Payments are created on the Cash Collection > Payment Data Entry form. The steps to creating a voluntary payment transaction are similar as those for a standard payment. The following difference applies.

When you create a Voluntary Payment, you need to enter the subsystem (either Real Property Tax or Personal Property Tax), the year, and the cycle code for the payments that you want to create.

For example, the following parameters could be entered for an advance or Voluntary Payment for Real Property taxes.

  • Subsystem: Real Property Tax
  • Year: 2018
  • Cycle Code: Municipal Tax

If a record matching the search criteria exists, it is displayed under Distribution. If no record exists for the year, one is created. A Voluntary Payment can be created for any year.

The record is displayed under Distribution.

Overview of the Voluntary Payment Transaction Process

The steps for creating a Voluntary Payment transaction are:

  • Selecting the Deposit Number for the Voluntary Payment
  • Performing the Search
  • Completing the Payment Parameters
  • Running the Cash Collection Wizard
  • Viewing the Payment in A/R Inquiry
  • Posting the Payment
  • Viewing the Posted Payment in A/R Inquiry

Selecting the Deposit Number for the Voluntary Payment

The following procedure is mandatory. All A/R transactions in Govern OpenForms must be associated with a deposit number.

  1. Launch Govern.
  2. Open a Profile that contains Cash Collection.
  3. Open the Cash Collection form.
  4. Select the Deposit Management tab.
  5. Create a new deposit number or select an existing one.

The Transaction Type must be Payments.

Creating the Voluntary Payment

To create the Voluntary Payment transaction on the Cash Collection form:

  1. Select the Payment Data Entry tab on the Cash Collection form.
  2. Click New.
    The deposit number you selected on the Deposit Management tab is entered automatically in the Deposit Number field.
  3. Select Voluntary Payment from the Transaction Type field.
  4. Select the subsystem from the Subsystem drop-down list.
  5. Only Real Property Tax and Personal Property Tax are available.
    Enter a year in the Year parameter.
    This is the year of fiscal year during which the transaction is applied.
    For example, if you are creating an advance or Voluntary Payment for a 2018 tax bill, enter 2018.
  6. Enter the cycle code in the Cycle Code parameter.

The Cycle Code is mandatory for the Real Property Tax and Personal Property Tax subsystems.

Performing the Search

You need to perform a search using a Dynamic Search group and criteria.
To perform the search:

  1. Select a Search group in the Search section.
  2. Enter the required criteria in the Criteria section and click Enter on your keyboard.

If a record matching all the search criteria is found, it is displayed under Distribution. If no record is found, one is created and displayed under in the Distribution section.
An A/R barcode is created for the transaction.

Completing the Voluntary Payment Distribution Parameters

To complete the transaction, you need to enter the effective date and the amount. The effective date is the date that the payment is effective. By default, this is the current date.
A voluntary payment is effective before it is applied on a tax bill.

To complete the Payment Distribution parameters:

  1. Select the effective date of the transaction in the Effective Date parameter.
  2. Select a transaction and enter the amount of the voluntary payment in the Amount field.

Completing the Payment

Once you enter an Amount in the Amount field beside the record, it is automatically entered in the Money section. You can select the method of payment, such as cash, check, certified check, credit or debit.
You can enter multiple payment types. For example, a payment can be made partially by credit card and partially by check.
To complete the payment:

  1. Select a method of payment in the Type drop-down list.
  2. Enter an amount if it is different from the displayed amount.
  3. Enter a reference, such as the check number in the Reference field.
  4. Repeat steps 1 to 3 as required if there are multiple payment types.

Payer

All Cash Collection transactions must include payer information.
To add payer information to the transaction:

  1. Click the ellipsis button in the Payer Name section of the Cash Collection form.
  2. Do one of the following:
    Click Search to search for a name in the database.
    Click New Name to add a name that is not in the database.
    If you want to add the name and address account directly, the Name and Address form must be included in the Profile.
  3. Click New Payer Name to a new payer.

Launching the Cash Collection Wizard

The Cash Collection Wizard launches automatically when you click the Save button.
To launch the Cash Collection Wizard:

  1. Click the Save button on the Cash Collection form after completing the payment.
    The Cash Collection Wizard opens.
    The payment amount and type are displayed.
  2. Collect the payment and click Next.
    The full amount and payment type are displayed.
  3. Click the Print button to print the receipt.

Print Receipt

The Print Receipt can be customized. The default receipt is shown in the following screen shot.

Finishing the Payment

To finish the transaction:

  1. Click Finish. on the Cash Collection Wizard once you have printed the receipt and the transaction is complete.
    The completed transaction is displayed on the Cash Collection form.
  2. Hover your mouse over the transaction to view the barcode.

Viewing the Voluntary Payment Transaction in A/R Inquiry

You can view the Voluntary Payment transaction, once it is saved, directly in the A/R Inquiry form.
To view the Voluntary Payment transaction in A/R Inquiry:

  1. Do one of the following, according to your setup:
    Open the completed transaction in the Cash Collection form and double-click on the transaction.
    Launch the A/R Inquiry form and perform a search using the barcode of the transaction.

The Voluntary Payment and Open Cash Credit transactions are displayed in the A/R Inquiry Detail.

Posting the Voluntary Payment

A Voluntary Payment can be posted, as any other Cash Collection Payment, with the Cash Collection Posting batch process.

Prerequisites

Ensure that you have access to the Department responsible for the A/R transaction.

Running the Batch Process

To post a voluntary payment:

  1. Launch Govern.
  2. Open a Profile that contains the Cash Collection Posting batch process.
  3. and through which you can access the required A/R transaction.
  4. Select the Batch Process Explorer.
  5. Select the Cash Collection batch process.
  6. Select the Voluntary Payment.
  7. Click Run.
  8. Click the Processing tab to view the batch process logs.

For details, see Cash Collection Posting.

Viewing the Posted Payment

Once the payment is posted, you can view the Voluntary Payment and Open Cash Credit transaction on the A/R Inquiry form.
To view the Voluntary Payment transaction in A/R Inquiry:

  1. Do one of the following, according to your setup:
    Open the completed transaction in the Cash Collection form and double-click on the transaction.
    Launch the A/R Inquiry form and perform a search using the barcode of the transaction.

 

 

101-cc-frm-011

 

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