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

WM Technical Specification and Information

Workflow Technical Specification and Information

(In Development)

Description

Generally, the workflow function can be imagined as a container with all the data related to a process (inspection, collection, verification) as well as a list of steps and tasks (activities) needed to complete this process.

What’s New

[to be validated] The same function is now used for all workflow types (kind). Prior to version 5.0, there was a different container for each kind (i.e. complaints, workflow, permits, licenses, hearings, etc.)
Workflow can be linked to a property, name, account, etc. (See key ?references? [to be validated] )

Database Modifications
The following modifications were made to the database in order to enable this feature.

  • Table PM_LK_MASTER: has been linked to Table PM_COMPLAINT in version [6.0]
  • Table PM_TYPE: 2 new fields ENTRY_KEY_TYPE and CATEGORY in version [5.1] and over [5.1 to be validated]

 

Setup Instructions

After the workflows have been created and setup, the administrator needs to MANUALLY set the following fields in the database.

TABLE = PM_TYPE

  • ENTRY_KEY_TYPE: The main KEY (root) database attribute name: p_id, na_id, account_id?, bldg_id?, user_id?, etc.
  • CATEGORY: Used to classify the workflow types. Used to populate the combo box custom control.

Use the Access Attach Table or SQL Manager to modify.

Database Diagrams

Govern for OpenForms Release 6.x – Database Diagrams

The following links to the page for Database Diagrams for Govern OpenForms modules.
Link to Land Management in the Land Management 6.1 section
PM_LK_PERMIT_TYPE

* The “KIND” field in the PM_MASTER table should determine what table to use:

KIND Description
b Building Permits (PM_BLDG_PERMIT)
bn Bonds
a Approvals (PM_APPROVAL)
bl Business License (PM_BUSINESS_LIC)
al Animal License (PM_ANIMAL_LICENSE)
e Electrical Permits (PM_ELECTRICAL)
d Decisions (PM_DECISION)
g General Permits (PM_GEN_PERMIT)
p Plumbing Permits (PM_PLUMBING)
pa Prosecution / Appeals (PM_PROSECUTION)
l License
lp License Parcel

** For license (l) there is no need to go through the PC_PARCEL and PC_LK_PARCEL_PM tables.

Product Specification

Workflow types

  • Unlimited number of workflow types can be defined
  • Unlimited user added fields can be tied to a workflow type
  • Up to 3 auto-generated unique workflow escalation numbers (Permit example: Application no. A0001, Permit no. P0001, Certificate no. C0001)
  • Steps in the processes (activities) can be auto-generated, initiated ?

Workflows can be linked to:

  • Unlimited properties (Not currently available in 6.0)
  • Unlimited names (Not currently available in 6.0)
  • Other related properties (if property base)
  • Other related names (if name base)

Activities can triggers multiple actions and interact with different groups

  • Generate inspections
  • Schedule meetings, hearings, inspections, etc.
  • Generate fees
  • Generate AR
  • Create multimedia documents
  • Run reports (Crystal Report / SSRS) – Send and Attach
  • Generate global messaging
  • Execute queries (update, validate, etc.)
  • Etc.

User actions:

  • Create, Update, Save and Delete
  • Override capabilities by security access type
  • Pre-defined information can be overridden on Create and Delete
    • ex: Link to Names, Standard emails, Fees, Inspections, etc.
  • AR and GL Accounts can be overridden on Create and Delete and also during fee override

 

101-std-frm-002-spec

 

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

ACH – Automated Clearing House Information

Automated Clearing House (ACH) Information

Version 6.0 | Version 6.1 GA Release 1609

Overview

Automated Clearing House (ACH) is a secure payment transfer system that provides a centralized clearing facility for Electronic Fund Transfer (EFT) payments occurring within the U.S. and Canada. You can use ACH for any type of electronic payment; for example, to validate authorized debits for recurring payments.

ACH is integrated with the Name and Address module, ePayment component, Utility Billing, and all Tax Assessment and Billing subsystems: Real Property, Personal Property, and all excise tax modules.

The Accounts Receivable subsystem includes setup, user functionality, and batch processing to handle your ACH transactions. The configuration and administrative setup are performed in Govern New Administration (GNA), the Business Entity Designer (BED), and the OpenForms Designer (OFD) forms.

The ACH account information is added to a separate ACH Information entity in the Name and Address form. Separate information is maintained for each subsystem. There are three batch processes, ACH prenotification, ACH Data preparation, and ACH file generation.

Related Information

ACH Configuration and Implementation is described on the following pages:

Configuring Encryption and Security for ACH
Setting Up ACH Banking Information in Your Organization

Running Batch Processes for ACH
ACH File Layout

Complete ACH Configuration and Implementation

What’s New

ACH account Information is defined in the ACH Info by Name entity in the Name and Address form. Multiple accounts can be created for ACH. An ACH Account can be selected on the Mailing Index entity of the Real Property, Personal Property, and Self Reported Tax fomrs. It can also be selected on the Miscellaneous Billing Account entity. ACH Information has the same look and feel across all user forms.

Encryption Mode

See
Configuring Encryption and Security for ACH

 

ACH Information

Name and Address

The bank information is recorded in the Name and Address ACH Information form. It is possible to enter an unlimited number of accounts (transit and bank numbers) along with a description that will be used to select the ACH record to use for the different modules.

  • This information is encrypted.
  • The bank account type is recorded in the Validation System Table [BANKACCT]

Mailing Index

  • An ACH account can be selected on the Mailing Index entity or the General Account entity. The user selects the account by its description.

Accounts Receivable Inquiry

  • It is possible to view or override (when in pending mode) the ACH Information on the Notes Tab

Batch Processes

The batch processes generate files that can be sent to the bank for all names that have been linked to a Mailing index for a specific module.
ACH batch processes can be executed from Govern, Govbatch and the Govern Scheduler. See also general Batch Processing for more information on setup, scheduling, ftp copy…
The following batch process are used for ACH:

NOTES:

  • The bank account and bank transit no. are not encrypted in the files exported to the bank. File transfer should be over secured networks only.
  • The transaction type for this batch process is Synchronous. The transaction mode is set to Break if One Transaction Failed. Regardless of how it is defined in GNA, it always runs in this transaction type and mode. An information message is displayed on the Batch Process progress report when this process is running.

Tables & Files

The output generated from ACH batch processing includes Import/Export Text Files for the Bank (standard File Layout) and entries in the ACH User Audit Table.
See ACH Tables for the standard file layout and table attributes details.
Import/Export Text Files
The following text files are generated using the same standard ACH file layout [100-ach-layout]

  • ACH_PRENOTE_YYYYMMDD_HHMMSS.txt
  • ACH_xxx_

ACH User Log Table
For each record processed, the following information is recorded in the [USR_ACH_LOG] table

  • Payment Effective Date, Amount and A/R id
  • Last Modification Date and User stamp, effective date and A/R information It contains the detail ACH for the records processed as well as the name and ACH bank account information for each A/R id.

eGovern Configuration

Web Site Application Parameters

ePayment

The Govern New Administration (GNA) Manage Web Sites form is used for setting and maintaining the default parameters for the eGovern – Public Self Service portal. The ePayment tab contain many options including the options to enable ACH transactions. To access the form in the the GNA…

  1. Select Application Configurations (tab) > Web Configuration > Manage Web Sites…
  2. In Web Sites form, click to select the ePayment tab.

Details are available in the eGovern – Public Self Service Portal manual

eRemittance

 

Feature Product Map

Feature Product Map & Wiki Resources

Area Description Product Code Supporting Information Developer (internal)
General OpenForms – ACH Specification & Links 100-ach 100-ach-install
AR Feature – ACH Feature Summary 101-ar-fea-006
Forms AR Form – A/R Inquiry ACH Information 101-ar-frm-004 101-ar-frm-004
NA Form – Name & Address ACH Information 101-na-frm-016 101-na-frm-016
NA Form – Mailing Index ACH Information 101-na-frm-004
Batch Processes AR Batch Process – Prenotification 101-ar-bp-060 101-ar-bp-060
AR Batch Process – Prepare Data 101-ar-bp-061 101-ar-bp-061
AR Batch Process – Create ACH File 101-ar-bp-062 101-ar-bp-062
AR Batch Process – Lockbox 101-ar-bp-036
Parameters AR General Parameters 103-ar-parm-General
eGovern Web Site Parameters 103-ap-004
System Registry 100-sy-registry
Wiki Map Name and Address 101-na-map
Wiki Map Accounts Receivable 101-ar-map

 

 

100-ach

 

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 – Inquiry ACH Information

Accounts Receivable (AR) Inquiry ACH Information

Overview

The A/R Information tab of the A/R Inquiry form includes a section for ACH Information.

This is updated automatically when you run the Prepare Data for ACH and the ACH Generate File batch process. For details, see
ACH Batch Processes

 

 

101-ar-frm-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...

AR – Refunds Data Entry Form

Refunds Data Entry Form

Overview

Typically, refunds are created when there is an overpayment or duplicate payment. The Refunds screen includes the following sections:
General Information: showing the subsystem, fiscal year, bill, invoice, and check number
Detail: for the entry date, effective date, A/R Class code, installment, amount and discount date
Comment: for the justification code and any notes applicable to the adjustment.
Payer Information: displaying the name of the taxpayer and a code to identify the type of letter to be sent.

Accessing the Refunds User Form

To access the Refunds form.

  1. Launch Govern.
  2. Open a Profile that includes the A/R Inquiry.
  3. Open the A/R Inquiry form.
  4. Perform a search and select the required record.
  5. Right-click on the required record in the Summary section.
  6. Select Refunds from the drop-down list
    The Refund Selection form opens.
  7. Select the record you are refunding and click OK.
    If the record is for an overpayment, a message appears:
  8. Click Yes to display only the overpaid portion in the Amount text box.
    Click No to display the full amount of the payment.
    The Refunds form appears:

Icons

Save: Click Save to save a new or modified adjustment record.

Cancel / Exit: Click Cancel or Exit to close the form. A confirmation message is displayed.

Click Yes to save your changes. Click No to close the form without saving your changes. Click Cancel to stay on the form.

General Information

Subsystem: This field displays the subsystem for the record selected on the A/R Inquiry form.
Year: This field displays the fiscal year of the transaction.
Bill Number: The bill number for the selected A/R Inquiry record.
Invoice No.: Enter an invoice number for the adjustment.
Check No.: Enter the check number for the refund.

Check numbers for refunds can be created in any of the following ways:

  • Generated by the Generate Refund Check Numbers batch process
  • Automatically generated when a new refund transaction is saved in Govern
  • Manually entered when a new refund transaction is created in Govern

The Check No. field is displayed if the check number is created either automatically or manually from the Govern user form.
You can enter a check number in this field or leave it blank. If it is left blank, this field is automatically populated when the record is saved.

The Check No. field is not displayed if you are using the Generate Refund Check Numbers batch process to create numbers for refunds. In this case, you must run the Generate Refund Check Numbers batch process in order to create check numbers for your refunds. A setup is required if you are using the batch process. See Generate Refund Check Numbers.

If the check number is created automatically either when the record is saved or when the batch process is run, it comprises the previous check number and the cycle. To create a new check number, one is added to the previous number.

Cycle Code: The Cycle Code associated with the record (Table: VT_USR_ ARCYCLE).

It is mandatory to create A/R Cycle Codes for Real Property and Personal Property tax billing. This is used for tax billing cycles and is linked to the A/R Class Code in GNA. You need to set up at least one Cycle Code, but you can create multiple codes. For example, you could have one cycle for municipal tax and a second for school tax.

Frozen IDs are created for cycle billing. A new Frozen ID is assigned when you run the Posting to A/R batch process. This is called a Certified Record. It is displayed in the Govern History Panel with the Cycle Code. The first Certified Record is assigned Frozen ID -1, the second -2, the third is assigned -3, and so on if there are multiple cycle codes.

A new Tax Audit record is created for all the parcels included in the batch process. The Entry Code for these records is set to Original. The Frozen ID is updated and a new entry is listed in the History Panel. For further details, refer to the Govern Real Property Tax documentation.

Detail

Date: The entry date for the refund. By default, this is the current date. To change the date, click the calendar beside this field and select a new date.
Effective On: The date the refund becomes effective. To enter a date, click the calendar beside the field and select a new date.
Amount: Enter the value of the refund.
If the refund is for an overpayment, this field displays either the overpaid portion or the entire payment, depending on the option selected on the initial screen
Interest: This field displays interest accumulated on the amount.
Total to Refund: This field displays the total amount to refund. By default, it displays the value in the Amount field. Enter a new value if required.
Class Code: Select an A/R Class Code from the drop-down list (Table: VT_ USR_AR_CLASS).
From Installment Number: Select the installment period for the refund: first, second, third, fourth installment or total (Table: VT_SY_ INSTALL).
Due Date: Click the calendar icon beside the Due Date field and select the date the refund is due, if applicable.
Discount Date: Click the calendar icon beside the Discount Date field and select the final date for a discount on the refund.

Comment

Justification Code: Select the Justification Code to explain the reason for the refund(Table: VT_USR_ARREASON).
Deposit Number: Depending on the options selected in GNA, deposit numbers can be automatically generated or user-defined.

Automatically generated deposit numbers are composed of one or two of the following fields: date, last deposit, and user ID. This number can be modified if security permissions allow.

If Deposit Management is activated, a drop-down list is added to the Deposit Information parameter. This is populated by the deposit numbers created in the Deposit Management form. See Deposit Management.
Do one of the following:

  • Enter a new deposit number required.
  • Select a deposit number from the drop-down list.

Notes

Enter any notes or comments applicable to the adjustment.

Payer Information

By default, the Payer information fields display the name of the taxpayer and a code that identifies the type of letter to be issued with the bill.
To modify the payer information:

  1. Click C beside the Payer information field to change the name. This displays the Search screen with the following options: By Name ID, By Tax Payer Account Number, By Name, By Phone Number, From NA_External
  2. Enter the required information on the search screen. Then select the applicable record.
  3. Select a code from the Letter Code field to identify the type of letter the payer receives, such as, duplicate payment, over payment or payment reversal (Table: VT_USR_LETER_C).
  4. Click Save.

A/R Inquiry for Refund

The record is displayed on the A/R Inquiry form when the transaction is complete.
The Amount and Payer Name fields under Cash Flow displays further details when you hover the mouse over a specific transaction:

 

101-ar-frm-025

 

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 – Automated Clearing House (ACH) Information

Accounts Receivable (A/R) Automated Clearing House (ACH) Information

Overview

Automated Clearing House (ACH) is a secure payment transfer system that provides a centralized clearing facility for Electronic Fund Transfer (EFT) payments occurring within the U.S. and Canada. It is used widely for payroll and a variety of recurring payments.
The ACH account is defined on the Name and Address form in Govern. It is linked to the following through the Mailing Index:

  • Real Property Tax
  • Personal Property Tax
  • Self Reported Tax
  • Miscellaneous Billing

The configuration and administrative setup are performed in the following applications:

  • Govern New Administration (GNA)
  • Business Entity Designer (BED)
  • OpenForms Designer (OFD)

There are three batch processes:

  • ACH Pre-notification
  • ACH Data preparation
  • ACH File Generation

Configuration

In order to configure ACH Information in your organization, follow the instructions in the document that you can download in the Documentation section..

Documentation

For complete information on the configuration, administrative setup, ACH user forms, and ACH Batch Processing, open the following guide:
ACH ConfigurationImplementation

Govern OpenForms ACH Information

To use ACH for bill payments in Govern OpenForms, you need to complete the ACH Information in the Name and Address form.
Then, complete the ACH Information for each applicable subsystem, as described in this section.

Name and Address ACH Information

ACH Information is added to a separate entity in the Name and Address form. You can set up multiple ACH accounts for any name and address account.

To access the ACH Information by Name entity:

  1. Launch Govern.
  2. Open the Name and Address from.
  3. Perform a search and load the results to the tree view.
  4. Select the required Name and Address record in the tree view.
  5. Select the ACH Info by Name entity.
    The selected Name and Address record is displayed at the top of the form.
    The required fields are outlined in red.
  6. Select an option from the Account Type drop-down list.
  7. Enter a description for the account.
    For example, both a personal and commercial Checking Account may be associated with the name record.
  8. Enter the bank transit and routing number in the Bank Transit No. field.
  9. This is a unique nine digit number used to identify the financial institution.
    The first two digits identify the district in which the bank is located. The remaining numbers are unique.
  10. Enter the bank account number in the Bank Account No. field.
    The bank transit and account numbers are cloaked when you enter them on the user form.
    You can click the icon on right of the text to view these numbers in plain text, provided you have the access permissions.
  11. Click Save.
  12. Repeat the procedure to create multiple name and address accounts.

ACH Information in Tax Forms

  • ACH Information is added to the following Govern user forms:
  • Real Property Tax
  • Personal Property Tax
  • ACH Information in Self-Reported Tax

Real Property Tax

The ACH Information is added to the Mailing Index entity in the Real Property Tax form.
The following rules apply to the Making Index:

  • The ACH Information is only available for the Primary Index.
  • The Primary Index receives all original bills and other mailings. All other recipients receive duplicates of the originals. Also, the Primary Index is listed on all reports. Select this option for the property owner or the person to whom you are sending original bills.

The following conditions apply:

  • There can be only one primary index per property.
  • The property owner must be defined as the primary index, even when the Mortgage Company is paying the bills.
  • If a primary index is not manually selected, the first name and address you enter automatically becomes the primary index.
  • All original bills and other mailings are sent to the primary index.
  • If the Status Information of the primary index is set to inactive, a duplicate bill is sent to the Primary Index and the original bill is sent to the Temporary Owner.
  • All other recipients receive duplicates of the originals, unless the Do Not Send Bill option is selected.
  • If Do Not Send Bill is selected for the Mortgage Company, an electronic bill is sent.

To access the Mailing Index entity in the Real Property Tax form:

  1. Launch Govern.
  2. Open a Profile that contains Real Property Tax.
  3. Open the Real Property Tax from.
  4. Perform a search and load the results to the tree view.
  5. Select the required record in the tree view.
  6. Select the Mailing Index entity.
  7. Select the Primary Index option.
  8. Click Save.

Personal Property Tax

Follow the instructions for adding information to the Real Property Tax Mailing Index.

Self-Reported Tax

Follow the instructions for adding information to the Real Property Tax Mailing Index.

Miscellaneous Billing

ACH Information is added to the Miscellaneous Billing Account entity. This information populates the Mailing Index table.
To access the Miscellaneous Billing Account:

  1. Launch Govern.
  2. Open a Profile that contains Miscellaneous Billing.
  3. Open the Miscellaneous Billing form.
  4. Select the Miscellaneous Billing Account entity.
  5. Select the description for the ACH Account that you want to associate with the selected Miscellaneous Billing Account from the ACH Account drop-down list.
  6. Double-click in the date fields and select a range of dates from the pop-up calendar if the ACH is to be used during a specific time only. You can enter a date in the From field or the Until field only.
  7. Click Save.

For further details, refer to the Miscellaneous Billing documentation.

 

 

101-ar-fea-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...