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

N/A

Personal Property Assessment

Overview

The property assessment form is used to maintain general information and tax appraisal and assessment total values.

Total Appraisal (AP) and Total Assessment (AS) Values as setup in General Parameter Function
Category Amounts (AP) and (AS) as setup in the Category and Items parameter
Additional Taxation Base Amounts (VA) as setup in the Personal Property Levy parameters

Value Setup Options

Category Amounts can be included or not in the Totals
Assessment values can be derived from an Equalized Appraisal Value (i.e. Assessment = 80% of the Appraised Value)
Manual data entry or System generated totals based on the inventory

Features

Assessment:
- Set Account Inactive
- Do Not Copy to Next Year
- Override Assessment
- Transfer Account Action Button
- Copy to Next Year, Create A/R, Rounding, Assessment % of Appraisal …

NOTE: *Same controller different configuration. For more information on the setup see OpenForms Reference items.

101-pp-form-007

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

PP – Copy to Year

Personal Property Copy Parameters to next Year

Note: Functionality available in version 6.0.1505

Overview

The main purpose of this option is to copy all Year base parameter to another year. It will validate if the destination year exist, and if so, the user will have a warning message to override the data before executing the copy.

Furthermore, the copy will be refused if an Original Audit record is found in the AUDIT information (Entry_code = ‘original’).

103-pp-parm-copytoyear

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

Personal Property – Adjustment

Personal Property Adjustment

Adjustment Parameters

Unlimited adjustments, % or Amounts, applied in a waterfall methodology based on the computation sequence.

NOTE: If Formulas or Logical Expressions are used, the NO LOCK function needs to be added since this is used in the compute and batch programs.

Personal Property Adjustments

Standard Accounts Receivable (A/R) Controller – Create A/R

Overview

This new standard controller can be setup on different Account Forms (Real Property, Misc. Billing, Self-Reported Tax…) in order to provide the user with an Action Button to create an A/R summary record on demand. With the A/R record, it will be possible for the users to enter deposits or voluntary payments against this Account.

The Create A/R button can be used for all Sub-Systems (Real Property, Self-Reported Tax, Personal Property, Miscellaneous Billing, etc.)
The Create A/R button is only available after an Account is created and saved where no A/R records associated to the account exists.
Once the Create A/R action has been executed, the button becomes disabled.
The A/R record created will match the System Registry A/R Sub-System rules (by name, by parcel, by year), etc. as configured in the A/R General Parameters Sub-System parameters.
This action button can be secured by profile user and role.

Configuration

This controller is used in different standard Forms distributed with the system. It can also be added and configured on a customized form.
To add or configure this controller on a form click below:

Standard AR Controller – Create A/R (OpenForms Reference) (101-ar-fea-022-ofr)
Contact your System Administrator or Business Analyst for more information on this feature implementation in OpenForms.

Standard AR Controller – Create A/R Payment Action Button

Overview

NOTE: The following specifications will change due to enhancements, and as such may change.

This standard controller can be setup on different Account Forms (Real Property, Misc. Billing, Self-Reported Tax…) in order to provide the user with an Action Button to create an A/R payment for the users to enter payments, deposits or voluntary payments against this Account.

The Create A/R Payment button can be used for all Sub-Systems (Real Property, Self-Reported Tax, Personal Property, Miscellaneous Billing, etc.)
The AR Record to pay is determined by the action button controller setup….
This action button can be secured by profile user and role.

Functionality

This controller is used in different standard Forms distributed with the system. It can also be added and configured on a customized form.

NEW! The action button will open a Cash Collection Form in a modal window. When the form is opened, the focus will be on the Cash Collection tab. Next, a new Data Payment Entry record is created. The Subsystem and Transaction Type will be set to the ones specified in the action button properties. Note that these fields will be disabled in the Cash Collection form. If there are any ID’s, or a payer name is specified, they will be auto-loaded and set. When the payment is saved, the AR Detail links will be added if needed. At the end of the process, if required, the Cash Collection is closed.

Configuration

To add or configure this controller on a a form see below:

Read More...Read Less...

Govern New Administration (GNA)

To configure in GNA…

On the GNA ribbon select Editors (tab) > Editors (group) > Profile Editor.
In the Profile Editor, ensure that you have linked the cash collection form that will be opened by the AR Create Payment action button.

OpenForms Designer (OFD)

In the OFD, follow these steps…

Select the action for action button, i.e., the Ar_CreatePayment_Action.

The following are the available properties with their associated descriptions.

AutoCloseAfterSave : When checked, the modal window in which the cash collection form was opened will be closed after the completion of the payment.
AutoSearchDatasetTypeCode : Chose the Dataset Type code that defines the ids that you want to auto load (e.g ar_id, p_id)
- If this is not set the Auto load will not function properly
AutoSearchIds : An expression that returns a list of ids seperated by “;” that you want to load in the cash collection form automatically
- E.g of a the output of a the expression = “10;30;100” or “20”
- If this is not set the Auto load will not function properly
CashCollectionForm : The form that you want to open for the payment.
- This must be a form that is linked to the current profile
CashCollectionPayorNameId : An expression that returns a na_id that you want to set as the default payor for the payment
CashCollectionSubSystem : The subsystem for the payment transaction.
CashCollectionTransactionType : The transaction type for the payment transaction (Note: The transaction field on the cash collection form will be disabled so you should use this property to set the correct transactiontype)
DetailLinkCreation : If checked, a detail link will be created for all the Ar Details that are created for the payment transaction.
DetailLinkId : An expression that returns the link id that will be inserted for the new ar details links (AR_DETAIL_LINK.LINK_ID)
- If this is not set, no detail link will be created even if the DetailLinkCreation property was set to true.
DetailLInkType : The type for the new detail links (AR_DETAIL_LINK.LINK_TYPE)
- If this is not set, no detail link will be created even if the DetailLinkCreation property was set to true.

Contact your System Administrator or Business Analyst for more information on this feature implementation in OpenForms.

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

Load LockBox Entries Batch Process

Overview

Documentation

Configuration

Load LockBox Entries batch process Parameters

Scheduler Configuration

Applicable Business Rules

Related Topics

Personal Property Assessment

Personal Property Assessment

Overview

Value Setup Options

PP – Copy to Year

Personal Property Copy Parameters to next Year

Overview

Personal Property – Adjustment

Personal Property Adjustment

Adjustment Parameters

See Also

Standard AR Controller – Create A/R (101-ar-fea-022)

Standard Accounts Receivable (A/R) Controller – Create A/R

Overview

Configuration

Related Topics

Standard AR Controller – Create AR Payment Action Button (101-ar-fea-024)

Standard AR Controller – Create A/R Payment Action Button

Overview

Functionality

Configuration

Govern New Administration (GNA)

OpenForms Designer (OFD)

Related Topics