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

 

AR General Parameters – Miscellaneous Billing

Accounts Receivable General Parameters – Miscellaneous Billing

Overview

There are administrative options that will control how the Govern System handles charges that are related to Misc. Billing (MB).
The following parameters need to be setup for Miscellaneous Billing:

Bypass MB/LM/SA/ST funds reapplication

There are administrative options that will control how the Govern System handles charges that are related to Misc. Billing (MB), Land Management (LM), Special Assessment (SA), and Self Reported Tax (ST). The Accounts Receivable General Parameters form is used to define settings for all the subsystems that are linked to Govern’s Accounts / Receivable (A/R) subsystem. Open Credit Transactions (OCT) are generated in the system when an amount that is applied to a payment exceeds the payment due. In the Govern system an OCT is in the form of an Open Cash on Hand (OCH), or an Overpayment (OVR). The Bypass MB/LM/SA/ST funds reapplication in the A/R General Parameters form is an option that changes how the system treats the reapplication of OCT’s.

When the Bypass XX funds reapplication option in GovAdmin is selected, the system will now apply the OCT to the account even if an invoice is NOT referenced.
As before, if the invoice is referenced, the OCT amount will be applied to the selected invoice.
When Reapply in the A/R Inquiry form is selected, the No option will apply the OCT to the outstanding balance of an invoice and creates the applicable G/L entries.
Only select the Yes option with the understanding that the OCT will be applied to account, but the OCT reference will be lost; this is consistent with the previous system behavior.

Default Rules of applying OCH

By default, in the A/R Inquiry form, when a payment is made in the system and no invoice number is specified, the Govern system will apply the payment to all outstanding invoices. When an overpayment amount exists as a result of that overpayment, it is recorded in the system as an open credit OCH. When users select the Bypass XX funds reapplication option in GovAdmin, where XX is a related subsystem. When Reapply is selected in the Govern A/R Inquiry form, unless an invoice number is specified, payments will be recorded as an OCH record, and will remain in the system.

NOTE: Invoices must be referenced by their number otherwise the system will not apply the payment.

During Reapply, if the Yes option is selected for Bypass MB funds reapplication, the OCH will be cleared. Any reference to the OCH will be lost and no adjustment will be made to the GL transactions.

A/R Master by Fiscal Year

This can be selected to create a new AR_ID each year for each MB_ID when an Invoice posting occurs. Otherwise, all invoices for each MB_ID will post to the same AR_ID.

Allow payments < Late Charges Due

 

 

103-ar-parm-MB

 

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

Miscellaneous Billing Module

Miscellaneous Billing Module

Overview

Govern’s Miscellaneous Billing module is a flexible invoicing and collection system. It can be used for special or occasional invoicing functions such as transportation costs or courier fees that do not fit easily into any other category. The system facilitates the entire billing process for uncommon charges, by updating the Accounts Receivable records and calculating financial and past due account charges, for all bills. The system can be integrated with the G/L for automatic updates.

The user forms for Miscellaneous Billing include the following:

  • Miscellaneous Billing Account Miscellaneous Billing accounts are set up for individuals or companies. Multiple accounts can be set up for each individual or company. Each account can be exempt from one or both sales taxes.
  • Invoice Data Entry The data entry for the miscellaneous billing invoices is performed on the Miscellaneous Billing Invoice. Invoices can be posted manually from this form or automatically in a batch process.
  • Recurring Invoice Data Entry Recurring invoices can be created for miscellaneous billing items that occur on a regular basis.

 

Read More...

Administrative Menu

The administrative menus for Miscellaneous Billing are as follows:

Miscellaneous Billing General Parameters: This form is used for defining the sales tax parameters for the items that are invoiced under Miscellaneous Billing. One or two sales taxes can be defined, depending on the requirements of the organization. The Sales Tax is associated with each item. An account can an account can be exempt from one or both taxes.

  • Miscellaneous Billing Items The Items are defined for the invoices. A default amount is added. An A/R Class is associated.
  • Miscellaneous Billing Categories: The Miscellaneous Billing categories are used for creating groups of items. This facilitates data entry.
  • Recurring Batch Codes: The Miscellaneous Billing Recurring Batch Codes are used for defining schedules for the miscellaneous billing invoices that occur on a regular basis.
  • Copy to Year: The Miscellaneous Billing Copy to Year is used for copying the Miscellaneous Billing parameters: Sales Tax definitions, Items, Categories, and Recurring Batch Codes from one year to the next.
  • Initialize Next Year: The Miscellaneous Billing Initialize Next year is used for copying the recurring invoices from one year to the next.

Specification

Miscellaneous Billing

  • Standard Search
  • Flexible Account Setup and Maintenance
  • Regular & Recurring Invoices
  • Invoice & Recurring Invoices posting
  • Detail Invoicing Itemized by User Defined Miscellaneous Billing Items setup with an A/R Class Code
  • Up to 2 Sales Tax Applicable

Accounts Receivable

  • Interest calculation on past due amounts
  • Re-Apply Funds (A/R OCH and OCT processing)
  • ACH Processing by Name

Tax Lien

  • Link to Property
  • Transfer unpaid invoice due to real property tax (tax lien)

Standard Reports

  • Recurring Entry List (by status)
  • Aged List of Accounts by A/R class code (A/R Standard Reports)

Automated Workflow (Activity Base) Miscellaneous Billing

  • Activity can trigger generation of Misc. Billing Invoices

See Also

  • Accounts Receivable
  • Cash Collection
  • Real Property Taxes

 

 

 

101-mb

 

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