AR – Search to Load Data (101-ar-fea-026)

Accounts Receivable (A/R) Search to Load Feature

Available in Govern Rel. 6.0/6.1

Overview

Selecting a Record Key from the DataSet TreeView will load AR Data, the form also has a feature that allows you to search for keys to load the data. The key is then sent to the TreeView as a Temporary Key to allow the application to recalculate information based on that key.

Demonstration of the Temporary Key

To demonstrate the functioning of a Temporary key in Govern, follow these steps:
Preparatory steps:
  1. Search for a few records to add to the Treeview from the eSearch then open the AR Inquiry form.
  2. Search for a key that contains a field that is of the same type as the profile and is already in the Treeview. It gets selected.
  3. Perform Step 1) but for a key that isn’t in the Treeview already. It gets added, selected, 1st and orange background.
  4. Perform Step 2). the key added by 2) gets replaced by this new one.
  5. Repeat Step 1). notice that the same result and the one added in Step 3) remains.
  6. Perform a search for a key that doesn’t contain a field that matches the Treeview key. The description is based on the Main ID of the key.
  7. Manually remove the temporary key from the Treeview and search for it again. It gets added as Temporary again.

Related Topics

 

 

101-ar-fea-026

 

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 – M&S Valuation Setting Editor (103-ed-025)

Valuation Setting Editor (Marshall & Swift MVP Interface)

Available in release 6.1.2211 – (In Development)

Overview

Marshall & Swift (M&S) is a cost-based appraisal methodology intended to value buildings and non-buildings improvements using the reconstruction cost method. It comes with two different valuation approaches, one for residential properties and one for commercial ones. This appraisal method is rarely used to produce final values but often used to provide a comparison point with other value types such as comparable sales or market values (MRA). The Marshall & Swift Valuation Platform Online (MSVPO) integrates with Computer Assisted Mass Appraisal (CAMA) systems via web services hosted by CoreLogic®.

Purpose

In Govern for Windows, M&S was offered as a special set of configurations within the Building Structural Element (BSE) function. An interface was developed to periodically load M&S valuation tables within the Govern BSE tables from the M&S database tables.

A different approach has been taken with OpenForms v6.1. In OpenForms, a new M&S API was developed to support the MSVPO interface for both residential and commercial valuations.

M&S In Govern

New admin parameters have been created as well as new database table structures that are specific to M&S. An internal API or data exchange tool will be needed for each Harris Govern product line to read/write the data from/to our product specific format (either in the legacy improvement tables or in new ones).

With the implementation of the new MSVPO API, a conversion tool has been created to convert the legacy M&S data into the new format.

The CoreLogic MSVPO API has been developed by CoreLogic as a public facing Web Service. This MSVPO service has been leveraged for Govern development.

The system defaults are by year and valuation types. As the M&S tables determine the type of computation, residential or commercial, the interface offers two entries, one for the Residential valuation method and one for the Commercial valuation method.

Valuation Settings Editor User Interface (UI)

The Valuation Setting Editor interface is located in the Govern New Administration (GNA)

To access the UI in GNA…

  1. On the GNA ribbon click Editors (tab) > Valuation Settings Editor
  2. The Valuation Settings editor will be displayed.

<–>

Valuation Settings Editor Setup Parameters

Valuation Settings Form – tab buttons

New – Click New to create a new Valuation Setting record.

Save – After completing the required parameters, click Save to save your Valuation Settings.

Delete – Click Delete to delete the currently selected valuation settings record

Refresh – To update the settings in the form with those of the M&S Valuation tables, click Refresh.

Valuation Settings Form – parameters

Description – Enter a descriptive name for the new valuation settings record.

Commercial / Residential – These options refer to the valuation method; select which type of table will be obtained from the M&S tables, e.g., Commercial or Residential.

Years – This column lists the valuation type and corresponding year that are available.

Year – This field that will indicate the year of the currently selected record.

Residence Type – This optional parameter is a drop-down menu that displays the residence types available in the Marshall & Swift (M&S) tables.

NOTE: This parameter is disabled when the valuation method selected is Commercial.

Default Style – When a Residence Type is selected, all possible styles will be displayed.

NOTE: This parameter is disabled when the valuation method selected is Commercial.

Valuation Date – All valid valuation dates will be displayed in this drop-down menu

Base Date – Select a Base Date from the date picker; this is a value that is less than or equal to the Valuation Date. The default is the Valuation Date.

Multipliers (group)

The local multiplier adjusts the calculated costs to the location of the building. Commercial Estimator automatically uses a local multiplier based on the ZIP or Postal Code entered on the General Information screen.

Local Multiplier – Enter a value to set the Local Multiplier; this parameter accepts values between 0.10 and 3.00.

Local Multiplier Adjustment Percentage – The Local Multiplier Adjustment is used to increase or decrease costs for unusual situations, such as remote locations, resort locations, shortages, surpluses, and so on. Enter a positive or negative percentage to increase or decrease the local multiplier. Accepted values are -50.00 to 200.00

Regional Multiplier – Accepted values for this parameter are 0.10 to 3.00.

NOTE: This parameter is disabled when the valuation method selected is Commercial or when the Regional Multiplier parameter is not set.

Manufactured Home Mult. Type (group)

Manufactured homes are residential structures built on steel undercarriages with necessary wheel assemblies to transport them to permanent or semi-permanent sites.

Use Regional Multiplier / Use Local Multiplier – Select either Use Regional Multiplier or Use Local Multiplier.

NOTE: This parameter is disabled when the valuation method selected is Commercial.

Effective Age Adjustment Value – When entering an Effective Age Adjustment Value, accepted values are 020.

Rounding Value – Accepted Rounding Values are 01000000.

Architect Fee Percent – Valid values for the Architect Fee Percentage is 0.00100.00.

Depreciation Percent Adjustment Value – Refer to MPV Commercial 2.1.3 & 8.6.3 and MPV Residential 2.1.4 & 7.8.3 for more information.

US Localization Type (group)

Select one of the available three (3) options, 3-digit only, 5-digit only, or 5-digit or 3-digit.

Depreciation Percent Apply Flag – Select True or False ; See MPV Commercial 8.6.2 and MPV Residential 7.8.2 for details

Depreciation Maximum Percent – Refer to MPV Commercial 2.1.3, 8.6.3 & 8.6.4 and MPV Residential 2.1.4 & 7.8.4 for details.

Section Depreciation Maximum PercentSee MPV Commercial 2.1.3, 8.6.3 & 8.6.4 and MPV Residential 2.1.4 & 7.8.4 for details.

Zone Information Adjustment Override (group)

NOTE: The Zone Information Adjustment Override frame is only available when the valuation method selected is Residential.

Target Zip Code – Enter the zip code of the required area on the M&S table.

Energy Zone – Select an Energy Zone, e.g., Moderate.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Foundation Zone – Select a Foundation Zone.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Hillside Construction – Choose a value from the drop-down menu; e.g., Flat.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Seismic Zone – Choose a value from the drop-down menu.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Wall/Energy Zone – Select a Wall Energy Zone code; e.g., 2×4 Base Cost.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Wind Zone – Select a Wind Zone code.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Documentation

When documentation is available click here to view it.

GNA Product Map

 

 

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

Generic Import Editor (103-ed-024)

Generic Import Editor

Available in release 6.1.xxxx – (In Development)

Overview

The Generic Import Editor is a GNA Editor that will allow users to import

The function of the Generic Import Editor is as follows:

  • Allow import definitions to be stored in a configuration
  • Allow imports to be tracked and monitored from a single location.
  • Allow imports to be created faster with minimal coding required.
NOTE: This editor maintains records found in (Table: VT_USR_IMPORT_DEF).

Generic Import Editor Setup Parameters

T/C

 

GNA Product Map

 

 

103-ED-024

 

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

SSRS – SQL Server Reporting Services Report Conversion Tool

SQL Server Reporting Services Report Conversion Tool

Version 6.1

Overview

The SSRS Report Conversion tool is a Windows application developed to assist, with some minor manipulations, the conversion of a .rdl report for use in the latest versions of Govern and GNA.

User Interface

When initialized, the SSRS Report Conversion Tool displays as a utility window with input and output parameters.

 

SSRS Report Conversion Tool Parameters

Input Folder – Click to manually type in the path to the Input folder. This is the path to a physical folder that must contain at least one .rpt file that is to be converted.

[…] Select Folder – Click the ellipsis button […] to navigate to the required folder.

Output Folder – This non-editable parameter contains the path to the folder that the converted reports will be placed. This is always a folder named Converted that will be located under the Input Folder path.

Recordset – This combo-box is a GovernId that will be used to group records in Govern. This should be the same GovernId that is configured for the Profile that will be using the SSRS report.

Convert – Click Convert to run the conversion process.

Files to process: – The Files to process area will display all reports within the Input Folder. After a click on Convert, the report names with their status will be listed along with an indication as whether files were converted successfully, or if any issues were encountered during the process.

About the Conversion Process

Users should note the following about the conversion process:

  • The original .rdl file will not be modified.
  • The output file will always add the Parameters SERVER, DATABASE.
  • The parameters RECORDSET_{GOVERNID} will be added if the value for RecordSet is not empty.
    • For example, if the selected value is p_id, the parameter to add will be RECORDSET_P_ID.
  • The datasource connection string will be overridden with the following:
    =”Server=”+ Parameters!SERVER.Value +“;Database=” + Parameters!DATABASE.Value
  • The reports generated in the Output folder are the ones that should be submitted/replaced in the SSRS Server Folders.

 

See Also

301-ssrs

301-ssrs-changes

 

 

301-ssrs-util

 

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 – Miscellaneous Billing Module – What’s New

Miscellaneous Billing (MB) – What’s New

Version 6x

Overview

The following is a non-exhaustive compilation that lists recently updated topics related to the Govern for OpenForms Miscellaneous Billing module.

 

What’s New!

MB – Standard Report Recurring Entry Listing

Miscellaneous Billing (MB) – Standard Report Recurring Entry Listing Specification Overview Purpose Identification Process Name: Requirement Number: 16146 Records to

Posted in General, Miscellaneous Billing, Reports | Leave a comment

MB – Search Screens

Miscellaneous Billing (MB) – Search Screens Overview The following covers the standard searches used for Miscellaneous Billing, Access by Name

Posted in General, Miscellaneous Billing | Tagged , , , , , | Leave a comment

MB – Lien Transfer Batch Process

Miscellaneous Billing (MB) – Lien Transfer Batch Process Specification Overview Purpose Run the batch Miscellaneous Billing Lien Transfer process to

Posted in Batch Process, General, Miscellaneous Billing | Tagged , , , , , , , , , , | Leave a comment

MB – Tax Lien to Real Property

Miscellaneous Billing (MB) – Tax Lien to Real Property Overview Feature is currently not available and under review. Contact R&D

Posted in Govern, Miscellaneous Billing, Real Property | Tagged , , , , , , , , , , , , , | Leave a comment

 

Old News

Read More...

Release 6.1

 

Release 6.0

See also What’s New Name & Address (101-na-wnew)

Release 10.8 or prior

 

 

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

Bill Messages Editor

Bill Messages Editor

Available in release 6.1.1911

Overview

The Bill Messages Editor allows you to edit and manage Bill Messages. With this editor, you can add a message to your next billing run using form. This message is valid for one billing only. The message is defined by Message Type and by Subsystem. For example, you can define a message to be printed on duplicate bills created for Real Property Tax.

NOTE: This editor maintains records found in (Table: VT_USR_BILL_MESSAGES).

Bill Messages Editor Setup Parameters

Subsystem: Select a Sub-system (Land Management, Real Property Tax, Special Assessment, Utility Billing, and so on) from the drop-down list (Table: VT_SYSTEM.SUBSYS).

Message Type: Select a Message Type from the drop-down list (Table: VT_USER.MESSBILL).

: Click the ellipsis to add additional Message Types. Click to display the User Validation Table Editor.

Message on Bill: In this field, enter the message that is to appear on the bill.

 

GNA Product Map

 

 

103-ED-023

 

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

Dataset Treeview Temporary Records

Dataset Treeview Feature – Temporary Records

Overview

The Dataset Treeview Panel contains a list of record keys that, when selected, will send the information to OpenForms which, in turn, will load records accordingly.

Temporary Records

Normally, a user simply searches for record keys and navigates through them to work but some features can load their keys internally without being linked to the Record Keys from the Tree View, for example AR Inquiry and Cash Collection forms. The side effect is that any information normally available outside the form are not refreshed because they are triggered only by a selection in the Tree View, this is the case with Tiles. In order to resolve this issue, these keys are sent to the Tree View but are flagged as “Temporary”. Only one of these keys can appear in the Tree View. The keys are replaced when a new one is introduced; this approach is used so as not to clutter the Tree View with keys that are not part of the user’s workload. In addition these keys can also quickly increase disproportionately. These keys are also not retained when the application is closed.

Business Rules

In order to trigger as many features as possible, the key will be filled with as many ID’s obtained from the database, based on available and missing ID’s from the Temporary Key.

  • First we check to see if we can find IDs from AR_MASTER based on an ordered list of specific ID Types that we get from the Temporary Key. These keys are the same that are needed to add to the Temporary Key afterwards from AR_MASTER.

    From AR_MASTER
    • The ordered ID types are: AR_ID, PP_ID, ST_ACCT_ID, UB_ID, MB_ID,  BR_ID, DC_ID, BT_ID, MV_ID, AC_ID, P_ID, NA_ID 
      • This means that as soon as one key returns records, we stop and take the most recent one.
  • If no AR_MASTER records are found directly, we try to find an AR_MASTER record linked to AR_DETAIL based on specific ordered field types from AR_DETAIL, noting that the IDs taken from AR_MASTER will still be the same as before.

    From AR_DETAIL Expand source
    • the ordered AR_DETAIL Field Types are: ST_ID, INVOICE_NO, PRJ_ID, PM_ID
      • This means that as soon as one key returns records, we stop and take the most recent one.
      • In version 6.1, the content of PM_ID will be a Workflow ID
  • If no NA_ID is found after that for the Real Estate Sub-System, we’ll try to get it from the primary NA_MAILING_INDEX if a P_ID was previously found.

    From NA_MAILING_INDEX

The Temporary Key will be inserted at the top of the Tree View with an Orange background. For example:

  • It is possible that the Temporary Key contains an ID that matches the Profile’s Key Type at this point, but its current Main ID Type is not the same. In that case, we will make this ID Type the main one so as to see the correct description in the Tree View.

Duplicate of an Existing Key

It is possible that after the work is done, the Temporary Key’s main ID exists in the Tree View. If that’s the case, it won’t be added to the Tree View like a Temporary Key, although the ID’s of both will be merged together, it will only be selected.

Context Menu

In the Dataset Treeview, a right click on an item will display and a menu with 3 options:

  1. Remove the current selected item
  2. Remove All items from the Dataset Treeview
  3. Remove All the items except the item where we did a right click on it

If we decide to right click on the panel, only 1 option will show up, allowing the removal of all items from the Dataset Treeview:

Remove

  • The item which we made a right click on will be removed from the Dataset Treeview.
  • If “Dirty”, a confirmation will show up asking you to save the data first.
    • Yes: Save the data and remove the item
      • If there is a validation error on saving, the item will not be removed and the item will remain “dirty”
    • No: Cancels the change and remove the item
    • Cancel: Not remove the item and the item is still “dirty”

Remove All

  • All the items will be removed from the Dataset Treeview.
  • If “Dirty”, a confirmation is displayed asking you to save the data first.
    • Yes: Save the data and remove all the items
      • If validation error on saving, the items will not be removed and the changed item remains “dirty”
    • No: Cancel the change and remove all the items
    • Cancel: Will not remove the items; the item is still “dirty”

DEV NOTE: Currently there is a bug in the techno and the message is displayed twice (2 times).

Remove All But This

  • All items will be removed except the item which we did a right click on in the Dataset Treeview.
  • If “Dirty”, a confirmation will show up asking you to save the data first.
    • Yes: Save the data and remove all the items except the item which we did a right click on it
      • If validation error on saving, the items will not be remove and the changed item is still dirty
    • No: Cancel the change and remove all the items except the item which we did a right click on it
    • Cancel: Will not remove the items and the item remains “dirty”

DEV NOTE: Currently there is a bug in the techno and the message is displayed twice (2 times).

 

Related Topics

Dataset Treeview

Forms Explorer
Reports Explorer

 

 

101-std-fea-049

 

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