TX – BP Load LockBox Entries (101-tx-bp-005)

Load LockBox Entries Batch Process

Release 6.1.1912 | 6.0.1904 | 6.0.1903

Overview

This batch process will load a payment lockbox file from a third party to Govern.

Documentation

When available a link to documentation is located here.

Configuration

This Batch Process uses the standard BP configuration.

 

TECH NOTE: Process code: GWF_LOCKBOX

 

Load LockBox Entries batch process Parameters

Preload: Create a record in table AR_LOCKBOX_HEADER and load all records from selected file to table AR_LOCKBOX_DETAIL

  • Replace File: if the file already loaded, a message will show ” and won’t let you load the file. If you want to delete the previous file and reload it, you need to check this option.

Process From File: Preload the file to table and load the payments

  • Update Duplicate Bill in Mailing: after loading the payment, the field DUPLICATE_BILL will be updated to -1

Process Preload file(s): Load the payments from (Table: AR_LOCKBOX_DETAIL) from the selected batch number.

 

NOTE: The batch number is required.

 

File Validation Only: Select this option to go through all records from the file, simulate the load of payment and list all error(s).

 

Scheduler Configuration

To process a payment, the Accounts Receivable (AR) needs a department; when run in Govern the process will use the Profile department.

If the batch process is run through the Scheduler, there is no Department set. At the location indicated below, select a department configuration that the Lockbox will use when it is run in the Scheduler:

 

Applicable Business Rules

 

 

101-tx-bp-005

 

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

MA – BP Taxroll Snapshot (101-ma-bp-012)

Mass Appraisal Taxroll Snapshot Batch Process

Release 6.1

Overview

The Mass Appraisal Taxroll Snapshot batch process is designed to make a snapshot (freeze/audit) of the CAMA & Tax data.

Documentation

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

101-ma-bp-012_MATaxrollSnapshot.pdf

User Interface (UI)

The UI for the Taxroll Snapshot batch process is  similar to standard Govern batch processes.

Taxroll Snapshot batch process Parameters

Year: The Year that the snapshot will be made from.

Snapshot: The snapshot number that will be used as the FROZEN_ID. Values are taken from (Table: SNAPSHOT) System Validation table.

  • Selected from a snapshot value between -32500 and -32759

Parcels to snapshot (group)

All: When this option is selected, data is selected from all Parcels in (Table: PC_PARCEL).

Tax Map Number – Selecting this option will:

  • Only select data for Parcels included in the Tax Map Range
  • If selected, you must provide at least a From or a To tax map number
    • A partial Tax Map number can be used; the search will perform a LIKE ‘taxMapNumber%’

Saved Dataset – This option will select data only for Parcels included in the selected Dataset name

Delete destination data before snapshot – Select this option to delete the destination data for the selected Parcels before making the Snapshot.

Records by batch: Specify the number of parcels to include in each batch; system default is 50.

Business Rules for Obtaining Records

Getting Records

This process will select all distinct parcels from (Table: PC_PARCEL)

Running the Taxroll Snapshot Batch Process

This batch process can be run Synchronously or Asynchronously. Note that Asynchronous transactions are recommended for improved performance. The Transaction Mode is forced to CONTINUOUS.

Related Information

Refer to the Govern OpenForms Designer (OFD) documentation for details.
Refer to the Mass Appraisal General Information documentation for further details on frozen records.

 

 

101-ma-bp-012

 

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

Transfer Credit from One Year to Another Batch Process (101-ar-bp-013)

Transfer Credit from One Year to Another Batch Process

Overview

The Transfer Credit from One Year to another batch process is run to adjust accounts by removing credits from one year and applying them to another. This is useful if you prefer to credit accounts at year end, rather than providing refunds for overpayments.

Transfer Credits from One Year to Another new parameters

 Availability: Release6.1.1707.1303 | 6.1.1811 | 6.1.1911 | 6.1.1912

NEW! The following new option parameters are an enhancement to the existing batch process for A/R – Transfer Credits from One Year to Another.

The new modifications will allow users to…:

  • Enable a minimum/maximum value to transfer
  • Introduce the ability to select from a saved dataset

In addition to the above modifications, users can exclude any properties which have a credit over a specific amount, and have had an owner transfer as of Department As of Date of the current year.

The transferring of Open Credits (OCR) is now optional; a flag in the system registry will display or hide the Open Credit section of the Batch Process.

Users no longer have to select a Batch Number for the payments and reversals transactions, they will be auto-created as needed.

If the batch Process needs to auto-generate a RECEIPT_NO, it no longer uses (Table: usr_key_receipt), it now uses (Table: usr_key_dynamic) where the key_name is RECEIPT_NO[<alias_id>] where <alias_id> comes from (Table:usr_key_receipt.alias_id) and the key format (key_format) is “{0:D8}“, the same as it was formatted before. A verify database process will transfer necessary keys and drop (Table: usr_key_receipt) afterwards.

 

Read More...

 

Govern New Administration (GNA)

There are changes in the GNA General Settings Editor to accommodate the above described options.

To locate these parameters in GNA…

  1. On the GNA ribbon select Parameters (tab) > System Parameters (group) > General Settings Editor
  2. In the OpenForms General Setting form, in the Registry Filter parameter, select Batch Process.
  3. Under the A/R Transfer Credits section you will note two (2) parameters: Allow transfer of Open Credits from one year to another, and Real Property – Maximum Credit Owner Transfer.

OpenForms General Settings – A/R Transfer Credits (section)

Allow transfer of Open Credits from one year to another – Select this option to allow the transfer of Open Credits from one year to another.

Real Property – Maximum Credit Owner Transfer – This parameter is used only for the Real Property Tax subsystem. This enhancement will look at the property owner to determine if the effective date of ownership is as of Department As of Date of the current calendar year that the batch process is being run in.

DEV NOTE: The query used to check the owner transfer is:

SELECT * FROM pc_owner 
   WITH (NOLOCK) 
   WHERE p_id=@p_id 
      AND status = 'O' 
      AND seq_priority = 1 
      AND as_of_date>=@department_as_of_date;

If the balance of the credit is above the amount set, then the transfer is not completed. Any amount equal to or below the amount set will be transferred. The transfer will proceed even if it is outside of the Minimum / Maximum threshold.

Batch Process parameters

In the Govern batch process, there are parameters in the Criteria Selection (group). They are as follows:

Transfer Credits from One Year to Another batch process parameter

  • Saved Dataset: This dropdown selection will enable you to select from a predefined dataset built in Govern.
    • It is enabled for all subsystems
    • The dataset is a selection of P_ID-s, except for the subsystems which work by name (AC, BR, BT, MB, MV, ST). In instances where the subsystem is AC/BR/BT/MB/MV/ST, the dataset will be a selection of NA_ID’s.
  • Minimum / Maximum Amount: new options to select a range of amounts to include in the process.
    • This parameter is enabled for all subsystems. When an Minimum Amount entered, values less than the entered amount will not be processed. (i.e., Input as a Positive Value).
    • If an amount is entered into the Maximum Amount parameter, anything greater than the entered amount will not be processed. (i.e., Input as a Positive Value)
    • If the parameters are empty, all amounts will be processed.

 

Related Topics

Accounts Receivable (A/R Module)

 

 

101-ar-bp-013

 

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

MB – Lien Transfer Batch Process

Miscellaneous Billing (MB) – Lien Transfer Batch Process

Specification Overview

Purpose

Run the batch Miscellaneous Billing Lien Transfer process to transfer outstanding balances from the Accounts / Receivable to the Real Property Taxation sub-system. This process will only transfer Balances from MB Accounts that have a parcel linked to it. The balances will be transferred as an Override Levy on the Parcel so it can be included on the next Property Tax billing.

Identification

  • Process Name: MB_LIEN_
  • Requirement Number: 16117

Records to be processed:

  • See Selection Criteria

Batch Processing:

  • The batch program can be scheduled to run periodically.
  • The transaction Mode “Roll Back If One Transaction Failed” is not supported. It will be “Continue If One Transaction Failed” by default
  • Refer to the Standard Batch Process details Batch Program Setup or Govern Scheduler for more details

 

Read More...

 

Batch User Interface

The following parameters and options are available:

Selection Criteria

Year

  • Enter the year by which the records are saved.
  • Note: This field appears only if A/R Master by Fiscal Year is selected for the Miscellaneous Billing subsystem on the A/R General Parameters form in Govern Admin.

Minimum Balance Due

  • Enter the minimum balance due. Accounts with a balance due less than this amount are not transferred.

Billed Up to

  • Enter the last billing date that will be able to be transferred. Any invoices billed after that date will not be included.

A/R Class Code

  • Select an A/R Class Code from the drop-down list (Table: VT_USR_AR_CLASS) to be used to Add a Lien charge to the existing balance. The default amount in the AR Class code setup it used for the Charge. Would be nice to have a parameter to enter the Charge amount on the Batch screen.

 

Batch Variables

A/R Reason Code

  • Select a justification for the transfer, from the drop-down list (Table: VT_USR_ARREASON). This will be included in the AR_DETAIL records created on the MB subsystem for the credit charges.

 

Batch Execution

The batch program can be executed on demand or scheduled with Govern Scheduler.

During the execution, warning and error messages will be presented in the batch result grid.

  • On error, the misc. billing account id will be displayed in the message – to verify
  • For any error, double-click on the message to access the full text

Once completed, information will be displayed, that includes:

  • A unique batch audit ID
  • Application name and version, such as Govern Batch Processing, 6.0
  • Batch process name with any additional notes, such as parameters loaded
  • User ID
  • Date and time the process was started
  • Date and time the process was completed
  • Parameters and Options used
  • Total number of records read
  • Total number of records processed
  • Indication as to whether the process was successful or not

Lien Transfer Log
A log of Miscellaneous Billing Accounts Transferred will be generated.

 

Batch Processing (Technical)

Before Executing Subprocesses:

  • Select all parcel ID and frozen ID related to the year (or all year if none selected) the jurisdiction, or the neighborhood or the saved dataset if chosen.

Execute Subprocess

  • For each batch process

Error Reporting
In addition to the standard Batch Processing standard error reporting, any additional validations will be listed below:

 

Troubleshooting

The following is to help troubleshoot the batch process.

  • After changes, it is always best to compute for a single year and small dataset
  • The parcel id is listed in the error message
  • Turning on the Govern Diagnostic Tool
  • Turning on the SQL Profiler Tool (system administrator)

 

Related Topics

The following information may be of interest:

 

 

 

 

101-mb-bp-003

 

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

 

Batch Process Definition Setup V5

Batch Process Definition Setup – Version 5

Version 6.x | Version 5 and lower

Overview

The GNA Batch Process Definitions form is used to define how you want your batch processes to appear and run in Govern. This includes setting up the menus and submenus for organizing your batch processes, configuring whether each process is run on a single server or on multiple servers, associating one or multiple reports, and synchronizing the batch process definitions and adding permissions. When complete, the batch processes are displayed in Govern.
This procedure has two major steps:

  • Configuring Batch Process Definitions
  • Adding Batch Processes Definition to Govern.

 

Read More...

 

Configuring Batch Process Definitions

Configuring Batch Process Definitions describes the following topics:

Batch Process Definitions User Interface

This section provides a tour of the Batch Process Definitions UI. The interface is comprised of a treeview, the definition form, and a secondary window for creating the menus and submenus or categories.
To access the Batch Process Definitions form:

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.

Once you create menus and define batch processes, the selected items are listed in a treeview on the left of the form. You can display or hide the treeview according to your preference.

About Batch Process Definitions

You can view, add, or modify a batch process definition, as described later in this section.
To display or hide the English and French long and short descriptions, click on the arrow beside the text box at the top of the form.

About the Menu Manager

The Menu Manager form is used for creating the menus and submenus for organizing your batch process definitions in Govern.NET.
To access the Menu Manager

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.
  3. Click the ellipsis button beside the Category text box.

If categories are already created, they are listed on the left. You can expand a category to view secondary levels if they exist. The name of selected menu is displayed on the right. You can expand the name to view the English and French short and long descriptions.

Creating a Batch Process Category

The first step is to create categories for your batch processes. The categories are used for displaying the batch processes in the Govern .NET menu. Create as many categories as required in order to facilitate user input.
To create a Batch Process:

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.
  3. Click the ellipsis button beside the Category text box. This opens the Menu Manager.The Menu Manager is used for creating categories for the batch processes. You can have multiple levels. For example, you could group batch processes by module, such as: Accounts / Receivable, Tax Billing, and Mass Appraisal. Then, you could add another level that groups processes according to when they need to be run; i.e., daily, monthly, or yearly. You can create any type of category that is useful for your organization.
  4. Enter a name for the category in the text box at the top right. This is automatically added to the English Long Description field.
  5. Click the button to the left of the text box where you entered the category name. This expands a menu with additional descriptions.
  6. Add an English Short Description and French Short and Long Description as required. These fields are optional.
  7. Click Save to add the category to the menu.

If you click the Select button without saving your new category, a confirmation message appears:

Deleting a Menu Category

To delete a menu category from the Menu Manager:
1. Launch Govern New Administration (GNA).
2. Select Batch Process > Definitions.
3. Click the ellipsis button beside the Category text box to open the Menu Manager.
4. Expand the applicable menu.
5. Select the category from the Menu list on the left.
6. Click the Delete button in the menu at the top right.
7. When the confirmation message appears, click Yes to delete the record.

Selecting a Category for the Batch Process

You need to define the processes under the categories to which they are assigned and will appear in Govern. Before defining a batch process, select the menu category where it will be saved.
To select a Batch Process:

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.
  3. Click the ellipsis button beside the Category text box to select the category for the batch process. This opens the Menu Manager.
  4. Expand the root menu to display the submenus.
  5. Select the applicable submenu or category.
  6. Click the Select button .

The root menu and all submenus are displayed in the Category text box and in the Parent Path text box. The existing batch processes are listed on the left.

Defining a Batch Process

Use the following process to name the definition and to associate it with a Govern Batch process.

NOTE: You need to define the processes under the category to which they are assigned and will appear in Govern.

To define a Batch Process:

  1. Select the category where you are defining the process as described under Selecting a Category for the Batch Process. The batch processes already defined for the category are displayed in the treeview on the left.
  2. Click the New button.
  3. Enter a code for the new batch process definition. This is a required field.
  4. Select a Govern batch process from the Process drop-down list. This is a required field.
  5. Enter a name for the record in the text box at the top right. This is automatically added to the English Long Description field.
  6. Click the button to the left of the text box where you entered the name. This expands a menu with additional descriptions.
  7. Add an English Short Description and French Short and Long Description as required. These fields are optional.
  8. Click the Save button to add the category to the menu.
    If you click the New button without saving your modifications, a confirmation message appears:

Defining the Transaction Type
The Govern batch processes can be run synchronously or asynchronously. If they are run synchronously, they are run on the same server. If run asynchronously they are run on multiple servers at the same time.
Select Synch or Asynch as required. For processes with multiple transactions, it is recommended to use asynchronous processing as this spreads the load over multiple servers and makes for faster processing time.
Pool #: For Asynchronous processes only, enter the maximum number of transactions to be handled by the client servers at any one time.
This works as follows: If you are running asynchronous batch processing, there is one master server that manages all the transactions and is responsible for sending them to the client servers. The value In the Pool # field indicates the maximum number of transactions to send out by the master server at any one time.

Scenario: Running a Batch Process Asynchronously
The following scenario illustrates how asynchronous batch processing works.
The parameters are as follows:

  • Master server: one
  • Client servers: five
  • Transactions: 50,000
  • Pool #: 50

The master server sends out the first 50 transactions to the client servers. Each server is responsible for ten transactions. As soon as a server completes one transaction, the master server sends it another. This continues until all transactions have been processed. However, there are never more than 50 transactions being handled by the client servers at any given time.

Defining the Transaction Mode

Select one of the following transaction modes for the process.

  • Break If One Transaction Failed: the process terminates when the transaction fails.
  • Roll Back If One Transaction Failed: the process terminates when a transaction fails and all the transactions that were completed are cancelled. Computations are returned to the starting point.
  • Continue If One Transaction Failed: Continue to run the process even if a transaction fails.

Adding a Report

Use the following procedure to associate one or more reports with the selected batch process.
To add a report: to the batch process:

  1. Launch the Batch Process Definitions form.
  2. Select the category for the process as described under Selecting a Category for the Batch Process.
  3. Select the batch process from the treeview on the left.
  4. Click Add Reports.
  5. Select one or more reports from the Choose the Reports menu.
    TIP: You can select multiple reports using the left mouse button.
  6. Click Select Reports.

The selected reports are displayed in the List of Reports text box. The parameters for the report are displayed in the Report Parameters list box.
The List of Parameters text box displays the parameters that can be included in the report and that can be used to build an external report; for example, these could include Date To and Date From fields. The purpose is to give you the exact reference and wording of these fields.

Deleting a Batch Process Definition

To delete a batch process:

  1. Launch the Batch Process Definitions form.
  2. Select the category for the process as described under Selecting a Category for the Batch Process.
  3. Select the batch process from the treeview on the left.
  4. Click the Delete button .

 

Adding Batch Processes Definition to Govern

When you have defined your batch processes, you need to add them to Govern.NET. In order to do this, you need to launch the Govern Security Manager and synchronize your new processes between GNA and Govern. Then, you need to assign access permissions.

Synchronizing Batch Process Definitions

When you have synchronized your new batch process definitions, they appear on the Govern.NET menu.
To synchronize the new batch processes:

  1. Launch the MSGovern Security Manager (GSM).
  2. Select your database connection key.
  3. Right-click on Applications and select Synchronize menu from the dropdown list. A confirmation message appears.
  4. Click Yes on the confirmation message.

Permissions and Batch Processes

Use the following procedure to assign access permissions to the new batch process definitions. You can grant permissions by batch process, batch process menu, or by batch process definition.

  1. Launch the MSGovern Security Manager (GSM).
  2. Select your database.
  3. Expand Applications > MSGovern.NET > Batch Process > Batch Process.
  4. Continue to expand the menus until you are the level where you want to grant permission.
  5. Right-click on the item that you want to secure.
  6. Define the permissions and exclusions as required and as described in the Govern Security Manager.

See Also

Govern New Administration (GNA)

 

 

103-ed-013-v5

 

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

GNA – Batch Process Definition Editor

Batch Process Definition Editor

Version 6.x | Version 5 and less

Overview

The GNA Batch Process Definitions editor is used to define how you want your batch processes to appear and run in Govern. This includes setting up your batch processes, configuring each process, associating one or multiple reports, and synchronizing the batch process definitions and adding permissions. When complete, the batch processes are displayed in Govern.
This procedure has two major steps:

  • Configuring Batch Process Definitions
  • Adding Batch Processes Definition to Govern.
  • Configuring Sequential Batch Processes (101-std-fea-046)
  • Configuring Sequential Batch Processes (101-std-fea-046)

 

Read More...

Configuration

Configuring Batch Process Definitions

Configuring Batch Process Definitions describes the following topics; locate the appropriate sections on this page:

  • User Interface
  • Defining a Batch Process
  • Defining the Transaction Type
  • Defining the Transaction Mode
  • Adding a Report
  • Deleting a Batch Process Definition

Batch Process Definition – User Interface

This section provides a tour of the Batch Process Definitions UI. The interface is comprised of a treeview (left hand side), the definition form (main central area), and a secondary window for creating the menus and submenus or categories.
To access the Batch Process Definitions form:

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.

Once you create menus and define batch processes, the selected items are listed in a treeview on the left of the form. You can display or hide the treeview according to your preference.

About Batch Process Definitions

You can view, add, or modify a batch process definition, as described later in this section.
To display or hide the English and French long and short descriptions, click on the arrow beside the text box at the top of the form.

About the Menu Manager

The Menu Manager form is used for creating the menus and submenus for organizing your batch process definitions in Govern.NET.
To access the Menu Manager

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.
  3. Click the ellipsis button beside the Category text box.

If categories are already created, they are listed on the left. You can expand a category to view secondary levels if they exist. The name of selected menu is displayed on the right. You can expand the name to view the English and French short and long descriptions.

Defining a Batch Process

Use the following process to name the definition and to associate it with a Govern Batch process.

NOTE: You need to define the processes under the category to which they are assigned and will appear in Govern.

To define a Batch Process:

  1. Select the category where you are defining the process as described under Selecting a Category for the Batch Process. The batch processes already defined for the category are displayed in the treeview on the left.
  2. Click the New button.
  3. Enter a code for the new batch process definition. This is a required field.
  4. Select a Govern batch process from the Process drop-down list. This is a required field.
  5. Enter a name for the record in the text box at the top right. This is automatically added to the English Long Description field.
  6. Click the button to the left of the text box where you entered the name. This expands a menu with additional descriptions.
  7. Add an English Short Description and French Short and Long Description as required. These fields are optional.
  8. Click the Save button to add the category to the menu.
    If you click the New button without saving your modifications, a confirmation message appears:

Defining the Transaction Type
The Govern batch processes can be run synchronously or asynchronously. If they are run synchronously, they are run on the same server. If run asynchronously they are run on multiple servers at the same time.
Select Synch or Asynch as required. For processes with multiple transactions, it is recommended to use asynchronous processing as this spreads the load over multiple servers and makes for faster processing time.
Pool #: For Asynchronous processes only, enter the maximum number of transactions to be handled by the client servers at any one time.
This works as follows: If you are running asynchronous batch processing, there is one master server that manages all the transactions and is responsible for sending them to the client servers. The value In the Pool # field indicates the maximum number of transactions to send out by the master server at any one time.
Scenario: Running a Batch Process Asynchronously
The following scenario illustrates how asynchronous batch processing works.
The parameters are as follows:

  • Master server: one
  • Client servers: five
  • Transactions: 50,000
  • Pool #: 50

The master server sends out the first 50 transactions to the client servers. Each server is responsible for ten transactions. As soon as a server completes one transaction, the master server sends it another. This continues until all transactions have been processed. However, there are never more than 50 transactions being handled by the client servers at any given time.

Defining the Transaction Mode

Select one of the following transaction modes for the process.

  • Break If One Transaction Failed: the process terminates when the transaction fails.
  • Roll Back If One Transaction Failed: the process terminates when a transaction fails and all the transactions that were completed are cancelled. Computations are returned to the starting point.
  • Continue If One Transaction Failed: Continue to run the process even if a transaction fails.

Adding a Report

Use the following procedure to associate one or more reports with the selected batch process.
To add a report: to the batch process:

  1. Launch the Batch Process Definitions form.
  2. Select the category for the process as described under Selecting a Category for the Batch Process.
  3. Select the batch process from the treeview on the left.
  4. Click Add Reports.
  5. Select one or more reports from the Choose the Reports menu.
    TIP: You can select multiple reports using the left mouse button.
  6. Click Select Reports.

The selected reports are displayed in the List of Reports text box. The parameters for the report are displayed in the Report Parameters list box.
The List of Parameters text box displays the parameters that can be included in the report and that can be used to build an external report; for example, these could include Date To and Date From fields. The purpose is to give you the exact reference and wording of these fields.

Deleting a Batch Process Definition

To delete a batch process:

  1. Launch the Batch Process Definitions form.
  2. Select the category for the process as described under Selecting a Category for the Batch Process.
  3. Select the batch process from the treeview on the left.
  4. Click the Delete button.

Adding Batch Processes Definition to Govern

When you have defined your batch processes, you need to add them to Govern.NET. In order to do this, you need to launch the Govern Security Manager and synchronize your new processes between GNA and Govern. Then, you need to assign access permissions.

Synchronizing Batch Process Definitions

When you have synchronized your new batch process definitions, they appear on the Govern.NET menu.
To synchronize the new batch processes:

  1. Launch the MSGovern Security Manager (GSM).
  2. Select your database connection key.
  3. Right-click on Applications and select Synchronize menu from the dropdown list. A confirmation message appears.
  4. Click Yes on the confirmation message.

Permissions and Batch Processes

Use the following procedure to assign access permissions to the new batch process definitions. You can grant permissions by profiles and grant permissions to the Batch Process Editor application in Govern Administrator.

  1. Launch the MSGovern Security Manager (GSM).
  2. Select your database.
  3. Expand Applications > MSGovern.NET > Batch Process > Batch Process.
  4. Continue to expand the menus until you are the level where you want to grant permission.
  5. Right-click on the item that you want to secure.
  6. Define the permissions and exclusions as required and as described in the Govern Security Manager.

What’s New

 

Related Topics

Govern New Administration (GNA)
Batch Processing in OpenForms

 

 

103-ed-013

 

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 – Delinquency Collection Batch Processes

Delinquency Collection Batch Processes

Overview

The Delinquency & Collections modules includes the following batch processes.
  • Transfer A/R to Delinquency
  • Delinquency Posting

Prerequisites

Before running the batch processes for Delinquency & Cash Collection, verify the following:

  • All A/R records to be transferred to Delinquency must be associated with a Delinquency A/R Class Code.

Defining Security Permissions for the Delinquency & Collections Batch Processes

Security for all batch processes in Govern OpenForms are defined in the Govern Security Manager (GSM) as follows:
To define security permissions for a batch process:

  1. Launch the Govern Security Manager (GSM).
  2. Expand Applications > Govern > Profiles > <name of the Profile> Batch Processes <name of the batch process>.
  3. Right-click on the batch process.
  4. Select Edit.
  5. Assign permissions by role.
  6. Select Exclusions.
  7. Define the exceptions.
  8. Click Save.

Transfer A/R to Delinquency

The Transfer A/R to Delinquency batch process is run in order to automate the process of transferring delinquent A/R records to the Delinquency and Collections module. It performs the same tasks as transferring individual records one by one on the Delinquency form.

Only records that are associated with an A/R Class Code that is linked to a Delinquency Collection A/R Class Code can be included in the process.

There are two procedures contained on this batch process.

  • Process Delinquent A/R: This is the first step. Run this procedure to transfer the delinquent A/R records to Delinquency and Collections.
  • Finalize Delinquent A/R: This is the second step. Run this procedure to finalize the A/R records.

A separate batch process is required in order to post the delinquent records that were included in the two Transfer A/R to Delinquency batch process procedures.
Posting to A/R: Once records are finalized, you can run the Posting to A/R batch process. This procedure is described in the following section.

Running the Process Delinquent A/R Procedure

To run the Process Delinquent A/R batch process from Govern:

  1. Launch Govern.
  2. Open a Profile that contains the Transfer A/R to Delinquency and Collections process.
  3. Select the Batch Processing Explorer.
  4. Select the Transfer A/R to Delinquency and Collections* batch process.*
    The name of the batch process can vary according to the administrative setup.
  5. Select the subsystem under which the delinquent A/R records are saved from the Subsystem drop-down list.
  6. Select a Cycle Code from the A/R Cycle drop-down list.
    The A/R Cycle parameter appears only for the Real Property and Personal Property Tax subsystems.
  7. Select the Process Delinquent A/R option.
  8. Enter a range of years in the From Year and To Year parameters.
    Only the records within the selected range are processed.
    The range of years appears for year-based subsystems only.
    It is used to ensure that the current bills are not accidentally transferred to Delinquency & Collections.
  9. Select a department from the Department drop-down list.The fiscal year from this department is displayed in the Fiscal Year parameter.
    This year is used to create the Delinquency account in the table AR_MASTER. It is also used for all records in AR_DETAIL.
  10. Select a date from the Filing Date drop-down list.
    This is the date of the transfer (Table: DC_MASTER.FILING_DATE)
  11. Enter a unique number in the Claim Number parameter.
    The claim number is applied on all records included in the batch process.
    It is a required field on the Delinquency & Collections user form, as well as on the Transfer A/R to Delinquency & Collections batch process form.
    This Claim Number is selected when you run the process to finalize the records.
  12. Select a warning flag in the Exclude A/R Warning Flag list box if you want to exclude certain records from the batch process.
    Records with the selected warning flag are excluded from the process.
    For example, you may want to exclude all records that are included in the Bankruptcy module from the process.
  13. Enter the minimum balance due on the records that you are transferring to Delinquency in the Minimum Balance Due field.
    Only the records that are greater than or equal to the Minimum Balance Due are transferred.
  14. Select an A/R Reason Code from the drop-down list (Table: VT_USER.TABLE_NAME = ‘ARREASON’)
    The A/R Reason Code is displayed by long description.This reason code is associated with the original record by AR_ID.
    For the delinquency record, it is used for informational purposes only.
  15. Click Execute.

If you are running the batch process from Govern, the status of the process is displayed in the Processing tab. If errors or warnings occur, messages are displayed.
You can run the batch process again in order to include records not included in the first claim. For example, if records are not associated with an A/R Class Code that is linked to a Delinquency A/R Class Code, they are not transferred to Delinquency.

Running the Finalize Delinquent A/R Batch Process

The Finalize Delinquent A/R Batch Process sets all records with the selected Claim Number to Finalized.
Once records are finalized, you can run the Posting to A/R batch process.

To run the Process Delinquent A/R batch process from Govern:

  1. Launch Govern.
  2. Open a Profile that contains the Transfer A/R to Delinquency and Collections process.
  3. Select the Batch Processing Explorer.
  4. Select the Transfer A/R to Delinquency and Collections* batch process.*
    The name of the batch process can vary according to the administrative setup.
  5. Select the subsystem under which the delinquent A/R records are saved from the Subsystem drop-down list.
  6. Select Cycle Code from the A/R Cycle drop-down list.
  7. Select the Finalize Delinquent A/R option.
  8. Select a claim number for the Claim Number drop-down list.
  9. Only the claim numbers that contain records that are not finalized appear in the list.
  10. Click Execute.

Transfer A/R to Delinquency Log Files

The log files for the Transfer A/R to Delinquency batch processes includes the following information:

  • Start and End time of the process
  • List AR_ID and balances being transferred
  • Sum of each class code being transferred to DC
  • Count of AR_ID being transferred to DC

Delinquency Posting

The Delinquency Posting batch process posts the delinquency records to the Govern Accounts/Receivable subsystem.
You can run this process at any time from Govern or create a schedule and run it at a later time or on a regular basis. For details about scheduling batch processes, refer to the Govern Scheduler guide.

The Delinquency Posting form has two sections.
The top section lists all the delinquency records with deposit numbers, by deposit number and A/R balance. The lower section provides the following details about those records:

  • Delinquency Claim Number
  • Balance
  • Finalized status: If the record is finalized, the check box is selected.

Only the Delinquency and Collection records that are Finalized can be posted to A/R.

To run the batch process from Govern:

  1. Launch Govern.
  2. Open a Profile that contains the Delinquency Posting batch process.
  3. Select the Batch Processing Explorer.
  4. Select the Delinquency Posting* batch process.*
    The name of the batch process can vary according to the administrative setup.
  5. Select the record or records that you want to post in the top section of the form.
  6. Click Execute.

If you are running the batch process from Govern, the status of the process is displayed in the Processing tab. If errors or warnings occur, messages are displayed.

Viewing Posted Delinquency and Collection Records

The posted Delinquency and Collection records are displayed in the Balance Forward Detail grid on the A/R Inquiry form.

Refer to the Govern Accounts Receivable documentation for details about the A/R Inquiry form.

Troubleshooting

You can only run the Delinquency Posting process on records that are finalized.
In the following screen shot, some of the records under the selected deposit number are not finalized. Therefore, you cannot run the batch process on this deposit number until you finalize the records.

Documentation

To view the documentation for this feature, click on this link to https://kb.harrisgovern.com/101-ar-bp-039/.

Related Topics

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