MB – Category Parameters (103-mb-parm-Category)

Miscellaneous Billing (MB) – Category Parameters

Setting Up Miscellaneous Billing Categories

The Miscellaneous Billing Categories are used for classifying the Miscellaneous Billing Items. This facilitates data entry.
To define the Miscellaneous Billing Categories:

  1. Launch GNA.
  2. Select Application Configurations > Miscellaneous Billing.> Categories.
    The existing Miscellaneous Billing Categories are listed in a treeview on the left.
    The Miscellaneous Billing Items are listed in a grid at the bottom of the form.
  3. Click New to create a new category.
  4. Expand the description fields.
  5. Enter a code in the Code field.
  6. Enter descriptions in the English and French Short and Long Description fields.
  7. Select the Available column for each item that you want to classify under the selected category.
  8. Select the Default column for the item that you want to display as a default when the category is selected in Govern.
  9. Click Save.

 

Read More...

 

Miscellaneous Billing Categories Validation Codes

The Miscellaneous Billing Category codes are contained in the Miscellaneous Billing validation table. This table is populated from the Miscellaneous Billing Categories form.
To access the Miscellaneous Billing Category Validation Table:

  1. Launch GNA.
  2. Select Editors > User Validation Table Editor > Miscellaneous Billing.
  3. Select MB_CATEGORY – Misc. Billing Categories on the left.

The entities where the miscellaneous billing category codes are used are displayed under the heading Used In.

NOTE: A category cannot be deleted if it is used in MB Accounts

 

 

 

103-mb-parm-Category

 

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 – Search Screens

Miscellaneous Billing (MB) – Search Screens

Overview

The following covers the standard searches used for Miscellaneous Billing,

Access by

Name and Address

Govern’s Name and Address search form provides two ways of searching for Miscellaneous Billing records:

  • By returning a list of all the miscellaneous billing records sorted by the selected option, or…
  • Returning only the records associated with a specific invoice or account number

 

Read More...

Miscellaneous Billing

  • Account No.
  • Name
  • Invoice No.

 

Specific Account Search

  • Account Number: Enter the full or partial account number of the miscellaneous billing record.
  • Invoice Number: Enter the full or partial invoice number of the miscellaneous billing record.
  • Date Invoice: Double-click in the field and select the date of the record from the pop-up calendar. Add it to be a range
  • Reference: Enter the reference number of the record as entered on the Misc. Billing Invoice form.
  • Department: Department issuing
  • MB Account Category

Recurring Entries Search

  • Date From and Date End
  • Note: The use of wild card characters is permitted, however, the wild card (*) is not supported in an ORACLE environment. – To be validated
  • Recurring Batch Period
  • MB Account Category

Property Search

To link a Miscellaneous Billing Account to a property, you can find the property by the following criteria

  • Tax map number
  • Parcel ID
  • House number
  • Street name
  • Owner status

Search Result Screen

At a minimum, the search should return the following information:

  • MB Account No (MB_ID)
  • Name (NA_ID)
  • MB Account Category
  • MB Invoice No.

 

NOTE: Depending on the setup, additional fields may be displayed.

 

 

 

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

 

 

 

MB – OpenForms Reference Standards

Miscellaneous Billing (MB) – OpenForms Reference Standards

Overview

[in construction] Scheduled for GA Release 6.1.1606
The Misc. Billing module consists of the following tables organized in business entities, business models and forms.

Database Tables

The following Miscellaneous Billing Tables are standard:

  • MB_MASTER
  • NA_NAMES
  • NA_MAILING INDEX
  • MB_INVOICE | MB_INVOICE_DET
  • MB_RECURRING | MB_RECURRING_DET
  • MB_PARM_CATEGORY
  • MB_PARM_ITEM
  • MB_TEMPLATE | MB_TEMPLATE_DET (To be reviewed for Land Management)

For changes in tables or attributes from a prior release, please see Impact List Changes in DB Structure.

 

Read More...

 

System Components

The following System components are used for Miscellaneous Billing:

Search Group

  • mbMiscBilling: Miscellaneous Billing Search
  • note: naName: Name Search can also be used

Search Styles

  • mbMiscBillid: By Misc. Billing Id
  • mbAccountNo: By MB Account No.
  • mbName: By Name (Misc. Billing)
  • mbInvoice: By Invoice
  • mbRecurring: By Recurring Invoice

 

OpenForms Designer Setup

Tab Sequences

The following Tab Sequence default is as shown in this figure – (Click here to view )

Browse Feature

You can have multiple Miscellaneous Billing Account for a single name.
The browse fields are setup in the Business Entity Designer.

Record Selector Feature
See expression

Generic Link Control (Used to link to Name)

[CO_GENERICLink_Control] Misc Properties

  • Allow Select Current ID: The feature to automatically select the Current Name ID (Global Id) will be enabled
  • Link Text Override: DO NOT ENTER if you want the Name and Address to be displayed) – update w new STD features
  • Selected Description
  • Selected Form Name
  • Selected ID Code
  • Selected Search Group (new feature)
  • Selected Search Style – ROAD MAP

Security (Role & Profile)

  • Can Create
  • Can Search
  • Can Delete Link has been disabled

 

Miscellaneous Billing Account

  • The tax exempt group can (and should) be removed from the form if no tax is charged on the miscellaneous billing items

 

Business Models

Miscellaneous Billing

  • The same model groups Account Information, Invoices (posted and not posted) and Recurring Invoices.

 

Business Entities

The following are the standard Business Entities and Attribute Properties used in Miscellaneous Billing.
MB_MASTER

  • Table: MB_MASTER
  • Special Attributes:
    • MB_ACCOUNT Account Number Calculated field stored in DB / Expression + Format

MB_INVOICE (unposted)

  • Table: MB_INVOICE
  • Filter = Not Posted

MB_INVOICE (posted)

  • Table: MB_INVOICE
  • Filter = Posted

MB_RECURRING

  • Table: MB_RECURRING
  • Filter = Not Posted

 

 

 

101-mb-ofr

 

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

MB – Recurring Invoices

Miscellaneous Billing (MB) – Recurring Invoices

Overview

Use the Miscellaneous Billing Recurring form in order to facilitate the data entry of miscellaneous billing records that are sent out on a regular basis.

The Recurring Code that you select for the miscellaneous billing recurring record is associated with a schedule, which can be set up on a monthly, weekly,or daily schedule. Invoices . The invoices are sent, according to this schedule, when the batch process is run.

The categories and items used for the standard one-time invoices are also used for the recurring invoices. The Category field is automatically populated with the default category for the account.

  • Recurring Invoice Entry (101-mb-frm-003-fea-001)

 

Read More...

 

Accessing the Miscellaneous Billing Recurring Form

To access the Miscellaneous Billing Recurring form:

  1. Launch Govern.
  2. Open a Profile that contains Miscellaneous Billing.
  3. Select the Miscellaneous Billing form.
  4. Select the Account tab.
  5. Perform a search and select the required account.
  6. Select the Recurring Invoice tab.
  7. Click Save.

There are two ways to create a recurring miscellaneous billing invoice:
Manually: Click New and complete the parameters on the form.
Automatically: Click Duplicate to create a recurring Invoice from an existing invoice. Complete and / or modify the data entry fields as required.

Miscellaneous Billing Recurring Invoice Fields

Recurring Code

Select a code from the Recurring Code drop-down list.
The recurring code is associated with a schedule on the Recurring Batch Code form in GNA. The invoice is sent out according to the schedule when the Miscellaneous Billing Recurring Posting batch process is run.
Issuing Department
Select the department that is responsible for the invoice from the drop-down list.
Reference
Enter a reference for the recurring batch invoice. This is used as a description for the invoice.
Effective Dates
Click the drop-down arrows in the From and To date fields to enter a range of dates.. The invoice remains effective during the selected dates. The recurring invoice will be effective starting at the FROM date and inactive on the TO Date (to validate)
Adding an Item
You add items to the recurring invoice in the same way that you add them to the one-time invoice. As with the latter, items can be predefined.
To add an item:

  1. Click the Add button.
  2. Complete the following fields.

Item
Select an item from the drop-down list under Item.
Only the items that are associated with the selected category are displayed in the list. If you want to add items from another category, you need to create another invoice. This is a required field.

Description
Add a description to make the invoice meaningful for the client.
Amount
Enter the cost of the item in the Amount field.
When you enter an amount:

  • The sales taxes are automatically calculated and displayed under Sales Tax 1 and Sales Tax 2, accordingly.
  • The total (Amount + Sales Tax) is automatically calculated and displayed under Subtotal.
  • All amounts in the Sales Tax 1 column are added together and total is displayed at the bottom of the form.
  • All amounts in the Sales Tax 2 column are added together and the total is displayed at the bottom of the form.
  • All amounts in the Subtotal column are added together and the total is displayed at the bottom of the form.

Unit
By default 1 is displayed in this column. Override this field to bill more than one of the selected item.
Sales Tax 1
This column displays the amount calculated for Sales Tax 1. This is based on the amount of the item and the sales tax method defined in GNA.
The total for Sales Tax 1 is displayed at the bottom of the form.
Sales Tax 2
This column displays the amount calculated for Sales Tax 2. This is based on the amount and the sales tax method defined in GNA.
The total for Sales Tax 2 is displayed at the bottom of the form.
Subtotal
This column displays the total for the first item or items. It is calculated as: (Amount * Unit) + Sales Tax 1 + Sales Tax 2 )
Total
The Total is displayed at the bottom of the column.

Adding Recurring Invoices from Existing Invoices

It is possible to copy a regular invoice to a recurring invoice.

 

 

 

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

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

 

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 for roadmap information.
For unpaid miscellaneous billing items, it is possible to transfer the unpaid miscellaneous billing invoices amount due to a tax levy.
In order to do so, you the following is needed:

  • Setup of Real Property Levies to use
  • Accounts need to be linked to a property
  • The Tax Lien Batch Process that will transfer the amounts to a tax levy need to be executed.

Linking a Property

Use the following procedure to link a property to a Miscellaneous Billing Account record.

 

Read More...

 

Adding a Property

To link a property, click on the Link Property Tab
Search and select a property
Save the Miscellaneous Billing Account.

Once the parcel is linked, the MB_MASTER record is populated with the P_ID. If there is an AR_MASTER, the P_ID is also populated

Removing a Property

Once a property is linked, you can remove this link by clicking on the remove button.
This will prompt for “Remove Parcel Code #9999999999? with Yes or No as options.
If answered Yes, the display of the parcel link is removed. The MB Account record still needs to saved. This will then populate the P_ID with null, and also update the AR_MASTER.P_ID to null.

 

 

 

101-mb-fea-011

 

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