MB – Sales Tax Compute Process

Miscellaneous Billing (MB) – Sales Tax Compute Process

Overview

Run the Miscellaneous Billing Compute Sales Tax batch process, after changing the sales tax parameters on the Miscellaneous Billing General Parameters form. These parameters are saved by year. The batch process recalculates all unposted Miscellaneous Billing invoices that meet the following criteria:

  • Standard (one-time) Invoices
  • Recurring Invoices

Invoices with items that are subject to sales tax.
Are Invoiced for the year entered in the Year parameter.
All these invoices are recalculated with the sales tax definitions of the corresponding year.

For details on defining the sales tax , see Miscellaneous Billing General Parameters

 

Read More...

 

Accessing the Miscellaneous Billing Compute Sales Tax Batch Process

The Miscellaneous Billing Compute Sales Tax Process can be run from Govern, GNA (for testing purposes), or the Govern Scheduler.
To set up run the MB Compute Sales Tax Process from Govern:

  1. Launch Govern.
  2. Open a Profile that contains Miscellaneous Billing.
  3. Select the Miscellaneous Billing form.
  4. Enter the year, corresponding to the invoices that you want to update and the sales tax definitions, in the Year parameter.
  5. Do one of the following:
  • Click the the Run arrow to run the process immediately.
  • Click Schedule to set up a schedule to run the process at a later date or on a regular basis.

Verifying the Miscellaneous Billing Compute Sales Tax Batch Process

If you are running the Miscellaneous Billing Compute Sales Tax batch process from Govern, you can click the Processing tab of the batch process and verify the execution. A progress bar is displayed along the top and information and warning messages are displayed.

After the process has run, The End is displayed on the progress bar. You can review the error, warning, and informational messages. The latter include:

  • Starting and Ending Time
  • Number of Records Processed
  • User ID
  • Batch ID
  • Transaction Mode
  • Batch Process Name

 

Notes

Synchronous Mode
This batch process runs in Synchronous mode only. If it is configured to run in Asynchronous mode in GNA:

  • A warning message appears to indicate that the process is running in Synchronous mode.
  • An information message appears to indicate that the Transaction Type parameters is set to Asynchronous.

 

Executing the Miscellaneous Billing Sales Tax Computation Batch Process

The Miscellaneous Billing Sales Tax Computation batch process performs the following calculations sin order to update the unposted Miscellaneous Billing invoices. It is run on both standard (one-time) invoices and recurring invoices.

It is typically run when changes are made to the Miscellaneous Billing Sales Tax rates on the Miscellaneous Billing General Parameters form in GNA.

Compute

The computation is run on all standard (one-time) and recurring Miscellaneous Billing that are unposted.

The computation is run on all standard (one-time) and recurring Miscellaneous Billing that are unposted.
The following fields are calculated:

  • Total
  • Sales Tax 1
  • Sales Tax 2

For all items, the price is multiplied by quantity:
ITEM_PRICE * ITEM_QTY

The totals for the sales tax are calculated:
TOTAL_SALE_TX_1
TOTAL_SALE_TX_1

Notes

Sales Tax 1 and Sales Tax 2 are calculated only for items that are subject to sales tax.

This is defined on the Miscellaneous Billing Items form in GNA. For each item, the option Subject to Sales Tax 1 and Subject to Sales Tax 2 can be selected or deselected.

The Miscellaneous Billing Account, which is set up for an individual or a company, can be exempt from one or both sales taxes. This is defined on the Miscellaneous Billing Account form in Govern. For each account, the options Exempt #1 and Exempt #2 can be selected or deselected.

Related Information

 

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

Log
A log of Miscellaneous Billing Accounts Computed will be generated. – need to verify if needed

Batch Processing (technical)

Before Executing Subprocesses:

  • Execute Subprocess
  • Error Reporting

In addition to the standard Batch Processing standard error reporting, the following will be validated:

 

What’s New

[6.0] Batch program created for OpenForms

Troubleshooting

The following is to help troubleshoot the batch process.

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

 

See Also

The following information might be of interest

 

 

 

101-mb-bp-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 – Configuration

Miscellaneous Billing (MB) – Configuration

Overview

This page describes the administrative configuration for the Miscellaneous Billing module. It includes a checklist and detailed steps for further information.

 

Miscellaneous Billing Configuration Checklist

The following table lists all the applications, forms, and steps required for configuring the Miscellaneous Billing module in Govern OpenForms.

 

Read More...

 

Application

Form

Steps
Deploy EZ N/A Run Deploy EZ. Open the Reports folder in the root folder of your deployment. Ensure that all reports required for Miscellaneous Billing are added to the deployment. Miscellaneous Billing reports include the Miscellaneous Billing Invoice (101-rpt-003.rpt).
For details, see Miscellaneous Billing Report.
Govern Business Entity Designer (BED) Business Models The Miscellaneous Billing Model contains the following entities:

  • MB_Master: This is the Root entity.
  • MB_InvoicePosted
  • MB_InvoiceUnposted
  • MB_RecurringInvoice

Perform the following configuration if required:

  • On the Model: Allow use in the Govern Query Tool.
  • On the Entities: Set rules for auditing and central notes

For more information, see the Business Entity Designer.
GNA General Settings Editor Open the GNA > Parameters > General Settings Editor > Report and ensure that the report parameters are defined. These include the folders for the reports and the log file.
For details, see Miscellaneous Billing Report.
GNA Report Parameters Editor Open the GNA > Parameters > Report Parameters Editor. Ensure that all report parameters are added for the Miscellaneous Billing Reports.
GNA Batch Process Editor Open the GNA >Editors > Batch Process Editor form and ensure that all batch processes for Miscllaneous Billing are defined and configured. These include:
Miscellaneous Billing Recompute Sales Tax.
GNA Department Maintenance Open the GNA > Department Maintenance form for all departments that are using Miscllaneous Billing.
Ensure that Miscellaneous Billing is selected under A/R Subsystems Allowed
GNA Profile Editor Open the GNA > Profile Editor form for all profiles associated with the department.
Ensure that Miscellaneous Billing is selected or deselected under A/R Subsystems Allowed for all Profiles as required.
Ensure that the Miscellaneous Billing form is added to all required Profiles.
Ensure that all Miscellaneous Billing Batch Processes are added to all required Profiles.
Ensure that all Miscellaneous Billing tree view, V_TREEVIEW_MB, is added to all Profiles, as required. This is optional.
Ensure that the Miscellaneous Billing Search is added under Default eGroup for all Profiles, as required. This is optional.
GNA General Settings Editor Open the GNA > Parameters > General Settings Editor and specify the number of characters in the default Account Number.
GNA Accounts Receivable General Parameters Set up Accounts Receivable (A/R) General Parameters for Miscellaneous Billing.
Set up the A/R General Parameters for Misc. Billing
GNA A/R Class Codes Set up Accounts Receivable (A/R) Class Codes for Miscellaneous Billing. See
A/R Class Codes
GNA User Validation Table Editor Verify the validation codes for the Miscellaneous Billing user validation tables.
GNA Miscellaneous Billing General Parameters Set up the Miscellaneous Billing General Parameters.
Miscellaneous Billing General Parameters
GNA Miscellaneous Billing Items Set up the Miscellaneous Billing Items. See
Miscellaneous Billing Items
GNA Miscellaneous Billing Categories Set up the Miscellaneous Billing Categories.
Miscellaneous Billing Categories
GNA Miscellaneous Billing Recurring Batch Codes Set up the Miscellaneous Billing Recurring Batch Codes
Create schedules for Miscellaneous Billing Invoices that are billed on a regular basis.
See Miscellaneous Billing Recurring Batch Codes
Govern Security Manager (GSM) N/A Set up the security for the Miscellaneous Billing administrative and user forms under your deployment.
Govern OpenForms Designer (OFD) . Miscellaneous Billing (MB001) Open the Miscellaneous Billing (MB001) form and configure the Miscellaneous Billing action button for printing the Miscellaneous Billing Invoice from the Miscellaneous Billing > Invoices Posted form.
Customize the form by naming and positioning the fields as required by your organization.
Customize the Browse screen, the Record Description, if required.
Make any required modifications to the form, such as repositioning the fields and renaming the labels.
Note: If you are making modifications, it is recommended to create a copy of the form, so that your changes are not overwritten.
For more information, see the OpenForms Designer.
OFD Open the Miscellaneous Billing form in Security Mode. Assign security permissions for all items on the Miscellaneous Billing form.
Assign security permissions for the Name and Address controllers in order to create and search for a name and / or create, search for, or delete an address.
Govern Miscellaneous Billing Account Create Miscellaneous Billing Accounts for required names in your municipality or organization.
For more information, see Miscellaneous Billing Account.
Govern Miscellaneous Billing Recurring Invoices Create Miscellaneous Billing Recurring Invoices for required accounts in your municipality or organization.
For more information, see Miscellaneous Billing Recurring Invoices.
GNA Copy to Year Open the GNA > Miscellaneous Billing > Copy to Year form. Ensure that the Miscellaneous Billing parameters, including the general parameters, categories, and items are copied from a previous year to the required year (as required by Miscellaneous Billing.
See Copy to Year.
Initialize Next Year Open the GNA > Miscellaneous Billing > Initialize Next Year form. Ensure that the Miscellaneous Billing recurring invoices are copied from a previous year to the required year (as required by Miscellaneous Billing.
See Initialize Next Year.
Govern Scheduler Verify the scheduled batch processes for Miscellaneous Billing
Govern Query Tool N/A Ensure that you can run queries on the entities

Detailed Steps

Setting Up a Department for Miscellaneous Billing

Adding the Miscellaneous Billing A/R Subsystem to the Department

It is necessary to add Miscellaneous Billing under A/R Subsystems Allowed for all departments that are using Miscellaneous Billing.
To select this option:

  1. Launch GNA.
  2. Select Parameters > Department Maintenance.
  3. Select the Department you want to update from the tree view on the left.
  4. Select the General tab.
  5. Select Miscellaneous Billing under A/R Subsystems Allowed.
  6. Click Save.
  7. Repeat steps 3 to 6 for all departments that use Miscellaneous Billing.

 

 

 

101-mb-config

 

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 – Posting of Invoices

Miscellaneous Billing (MB) – Posting of Invoices

Features and Specifications Overview

This process posts the invoices meeting the selection criteria to Accounts Receivables (AR) and creates the supporting General Ledger entries to support the new A/R transactions.

Invoices can be posted via:

  • An Action Button on the Miscellaneous Billing Form – Invoice Tab
  • A Batch Program configured for the Profile and accessed through the Batch Program Explorer Tool box
  • The Govern Scheduler (batch process definitions) to run periodically with preset user criteria

For more details see:

 

Read More...

 

Records to Process Criteria

Only the records meeting the following business rules will be considered in the batch process selection of invoice records to be posted.

Batch Program

  • Year
    • To verify
  • Department
    • To verify
  • Invoice is Ready to Post
    • Select this option when you are ready to post the record to the Accounts / Receivable sub-system. The record will be posted the next time a Miscellaneous Billing Posting is performed, in Govern Batch Processing.
    • This ensures that the invoice data is correct before it is posted. (MB_INVOICE.READY_TO_POST = -1)
  • Invoices are not already posted
    • (POSTED_FLAG = 0)

Action Button

  • None
    • When the user clicks on the current unposted invoice, it will be posted after confirmation by the user regardless if the Ready to Post field is checked

 

User Parameters

The following parameters can be set by the user on the execution of the batch program or as predefined parameters setup the the batch definition schedule to refine the records to be processed.

Selection Criteria

Year

  • Enter the A/R year. If the AR General Parameters have “A/R Master by Fiscal Year” checked for the MB Subsystem, then this year will determined which AR_ID is posted to for each invoice.
    • If the “A/R Master by Fiscal Year” is not checked, then this year is populated in the AR_DETAIL.YEAR_ID
    • The Year is used to determine the record in AR_PARM_CLASS to use and the associated GL’s

Invoice Number

  • Select the single invoice number to be posted.

Date Range

  • Enter the effective INVOICE DATE range of the invoices to be posted
    • From Date: Invoices on this date will be posted
    • To Date: Invoices on this date will be posted

Account Number Range

  • Enter the account range to be posted
    • From Account: Starts at this account
    • To Account: Up to this account. To account will be included in the selection.

Category

  • Invoice Category

Issuing Department

  • Department

 

Override Fields

The following parameters can be entered to override:
Effective Date (Invoice)

  • Overrides the Invoices effective date

Due Date (Invoice)

  • Overrides the Invoices due date

 

On Completion (Post Conditions)

Invoice Records

Batch / Reference No.

  • Enter the Miscellaneous Billing Batch or Reference Number from the Miscellaneous Billing Invoice form in Govern. This is the Reference field from the Invoice form.

A/R Class Code

  • Select the A/R class code from the drop-down list to process only the bills from a single class code. Otherwise, leave this field blank to process all the bills.
  • This will not be needed for Open Forms because the AR Class code on the Invoice will be removed.

From / To date

  • Enter the range of dates to process or leave these fields blank to process all bills.

From / To MB Account Number

  • Enter the range of account numbers to process or leave these fields blank to process all account numbers.

A/R Class Code

  • Select an A/R Class Code from the drop-down list, to process only the records for a specific class code, or leave this field blank to process all Miscellaneous Billing Recurring transactions.
  • This will not be needed for Open Forms because the AR Class code on the Recurring form will be removed.

Batch Name

  • Enter the batch name or number for the records you are processing or leave this field blank to process all transactions. This is for the Recurring Batch Process Only

Issuing Department

  • Enter the issuing department to process. This is optional.

By Saved Dataset

Override Due date

  • By default, the current date display, but unless the Override check box is selected, the Due date on each invoice will be posted to AR.
  • If the Override check box is selected, All invoices posted with that process will receive the due date in the Date field.

Batch Variables

Invoice Date

  • In this mandatory field, enter the date to appear on the invoice. This is for the Recurring Batch Process Only

 

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. – to verify

  • On error, the parcel id will be displayed in the message
  • Double-click on the message to access the full text

Once completed, information will be displayed, that includes:

  • Parameters and Options used
  • Total number of records read
  • Total number of records processed

 

Batch Processing (technical)

Before Executing Subprocesses:

  • Select all MB_INV_ID

Execute Subprocess

  • For each batch process
  • This process will post to AR the MB Invoices based on selection criteria and then update the MB_INVOICE records with POSTED_FLAG = -1 and POSTED_DATE with current date

Error Reporting
In addition to the standard Batch Processing standard error reporting, the following will be validated:

What’s New

[6.0] Batch program created for OpenForms

Troubleshooting

The following is to help troubleshoot the batch process.

  • Turning on the Govern Diagnostic Tool
  • Turning on the SQL Profiler Tool (system administrator)

 

See Also

The following information might be of interest

 

 

 

101-mb-bp-001

 

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 Product Map

Miscellaneous Billing (MB) Product Map

Version 6.x

Overview

The goal of the Product Map is to provide links to existing Miscellaneous Billing documentation.
This information is grouped around the Form Functionality or other stand-alone OpenForms Component ( Batch Process, Report, View, etc.).

Product Map

The following lists the product code documentations grouped by forms or by type.

 

Read More...

 

Section Status Product
Code/Page		 Description Process Name Supporting Info Quality Control Developer Technical Information
General 101-mb
101-mb-system		 Miscellaneous Billing Module Master
Master System Architecture and Configuration Requisites		 What’s New Configuration
Impact List
Visio MB Database Diagram		 101-mb Developer Specs & Questions
101-mb-config Miscellaneous Billing Administrative Configuration and Setup
101-mb-ofr OpenForms (OFR) System Configuration 101-mb-ofr 101-mb-ofr
101-mb-brules MB Business Rules 101-mb-rules 101-mb-rules
A/R Business Rules 101-ar-brules Accounts Receivable Business Rules and References

Transaction Types

Transaction Rules
A/R Object Errors G/L Transaction Rules
Standard Features
Features 101-mb-fea-004 Standard Dynamic Search Queries MB Group Std Features 101-std-fea-004 101-mb-fea-004 101-mb-fea-004
201-mb-fea-005 Online Payment of Miscellaneous Billing
101-std-fea-024 Standard Controller used for Link to Name and Link to Parcel How to setup 101-std-fea-024-ofr 101-std-fea-024
101-ar-fea-022 Standard AR Controller – Action Button – Create A/R How to setup 101-ar-fea-022-ofr 101-ar-fea-022
Miscellaneous Billing – Features
101-mb-fea-010 Sales Tax Computation
101-mb-fea-011 Misc. Billing Tax Lien Feature Feature not available. See Roadmap 101-mb-fea-011
Miscellaneous Billing – User Forms
Misc. Billing 101-mb-frm-001 Account Maintenance 101-mb-frm-001 101-mb-frm-001
101-mb-frm-002 Invoices (Unposted and Posted) 101-mb-frm-002 101-mb-frm-002
101-mb-frm-003 Recurring Invoices 101-mb-frm-0http://product-qc.govern.harrisgovern.com/101-mb-frm-00203 101-mb-frm-003
Recurring Invoices History Deprecated
Miscellaneous Billing – Administrative Parameters check–> GNA wiki Map
Parameters 103-mb-parm-General Misc. Billing General Parameters 103-mb-parm-General 103-mb-parm-General
103-mb-parm-Category Misc. Billing Parameter Category 103-mb-parm-Category 103-mb-parm-Category
103-mb-parm-Item Misc. Billing Parameter Items SY Registry USR Registry
A/R Parm A/R Deposit		 103-mb-parm-Item 103-mb-parm-Item
103-mb-parm-Recurring Misc. Billing Recurring Batch Code 103-mb-parm-Recurring 103-mb-parm-Recurring
103-mb-parm-Template Misc. Billing Templates for Land Management Feature not available. See Roadmap 103-mb-parm-Template 103-mb-parm-Template
103-mb-bp-005 Misc. Billing Copy to Year (see batch process) check–> 103-mb-copytoyear 103-mb-copytoyear
103-mb-bp-006 Misc. Billing Initialize Next Year (see batch process)
Miscellaneous Billing – Batch Processing Batch Processing
Batch Processes 101-mb-bp-001 Misc. Billing Posting to A/R (See also Features) MB_Post_AR 101-mb-bp-001 101-mb-bp-001
101-mb-bp-002 Misc. Billing Recurring Entry Posting MB_Post_Rec 101-mb-bp-002 101-mb-bp-002
101-mb-bp-003 Misc. Billing Lien Transfer MB_Post_Lien Feature not available. See Roadmap 101-mb-bp-003 101-mb-bp-003
101-mb-bp-004 Misc. Billing Compute (Recompute sales tax) MB_Compute 101-mb-bp-004 101-mb-bp-004
103-mb-bp-005 Misc. Billing Copy to Year (GNA) MB_CopyToYear 101-mb-bp-005 101-mb-rpt-005
103-mb-bp-006 Misc. Billing Initialize Data to the new year (GNA) MB_init_next_yr
Miscellaneous Billing – Standard Reports Reporting
Standard Reports 101-mb-rpt-001 Recurring Entry List mbrecurring.rpt Feature not available. See Roadmap 101-mb-rpt-001 101-mb-rpt-001
101-mb-rpt-002 Batch Posting Report standard report Use standard batch audit report 101-mb-rpt-002 101-mb-rpt-002
101-mb-rpt-003 Invoices mbinvoice.rpt
Miscellaneous Billing – OpenForms Standard STD Map
103-UT-005 Database Integration (System Tables, Corr. Scripts…)
103-UT-007 / 103-UT-008 EMT (Import / Export ) Utilities
103-UT-010 Database Extract Tool Utility
101-std-fea-027 Online wiki help for GNA Parameters
Miscellaneous Billing – System Options
202 mMobile Mobile Table Resources Feature not available. See Roadmap System Options (202) Tech

 

Related Topics

101-mb-bp-001

 

 

101-mb-map

 

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 – Initialize Year Data Batch Process

Miscellaneous Billing (MB) – Initialize Year Data Batch Process

Overview

Govern OpenForms Miscellaneous Billing module is year based and the purpose of this functionality is to create the recurring invoices in choosen year for the invoices that have not expired.
The system will check the END date with the Current Menu date to make this determination.

The Initialize Year functionality is a Batch Process and like any other batch process, it can be setup by profile with role and user security, scheduled, monitored, etc.

  • The batch process name is [mb_init_year] and it will be created when the Verify Database is run for the first time after having deployed a 6.1.1609 deployment.
  • The batch process definition [103-mb-bp-006] is available using the import/export. (to be verified)
  • The same batch process can be setup in multiple batch process definitions (with different schedules, notifications, etc.)
  • The batch process definition can be setup as an Action Button or a Link item that can be placed on a standard Form or on the user Cool Bar.
  • See Standard Batch Process details Batch Program Setup or Govern Scheduler for more details

This batch process can be accessed from:

  • Govern Administrator (GNA), select Application Configurations, Miscellaneous Billing,
  • Govern, open Profile Batch Process tool box window

 

Read More...

 

Batch User Interface

The following user criteria will impact what invoices will be processed.
Selection Criteria
You can select criteria to refine the process or leave these fields blank to process all transactions.Year

  • Select the year for to copy

Recurring Code (Batch Name)

  • Enter the batch name or number for the records you are processing, or
  • Leave this field blank to process all transactions.
  • Mandatory

Category Code

  • Enter a category code to limit the process to invoices setup with this category code.

Issuing Department

  • Enter a department to limit the process to invoices setup/issued for this department.

Override Invoice Date

  • Used to override the invoice date that will be created.
  • If left blank will use the current date

The selection criteria for the From year is user persistent and will appear the next time the batch process is executed.
However, the destination year is not persistent, so this field will be reinitialized each time the batch process is executed

Batch Processing

General Batch Processing

  • The process definition can be executed in SYNC mode only and this mode will be forced or overridden upon execution.
  • The batch transaction Mode = “Roll Back If One Transaction Failed” is not supported. It will be “Continue If One Transaction Failed” by default

 

Records to be Processed

Only the recurring invoices meeting these rules will be processed:

  • Recurring Invoices for the specified year
  • User Profile Current Date is superior to the Recurring Invoices Effective FROM Date and inferior to the Effective TO Date or end date.
    • If Effective TO Date is blank, it will be set internally to 12/31 of the recurring invoice year.
  • User Profile Current Date must be in the 1/1 and 12/31 range of the selected year.

On Warning and Error Reporting
During the execution, standard warning and error messages will be presented in the batch result grid.

  • On error, the MB ID will be displayed in the message text. Note: Double-click on the message to access and copy the full text

 

On completion

The following standard information will be displayed:

  • Parameters and Options used
  • Total number of records read
  • Total number of records processed

Log File

At the end of the batch process, a log will be created:

  • Log file called mbInitializeYear.log

 

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

 

 

 

103-mb-bp-006

 

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

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

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

 

Govern New Administration (GNA)

To configure in GNA…

  1. On the GNA ribbon select Editors (tab) > Editors (group) > Profile Editor.
  2. 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…

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

The following are the available properties with their associated descriptions.

  1. AutoCloseAfterSave : When checked, the modal window in which the cash collection form was opened will be closed after the completion of the payment.
  2. 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
  3. 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
  4. CashCollectionForm : The form that you want to open for the payment.
    • This must be a form that is linked to the current profile
  5. CashCollectionPayorNameId : An expression that returns a na_id that you want to set as the default payor for the payment
  6. CashCollectionSubSystem : The subsystem for the payment transaction.
  7. 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)
  8. DetailLinkCreation : If checked, a detail link will be created for all the Ar Details that are created for the payment transaction.
  9. 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.
  10. 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.

 

Related Topics

 

 

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