AR – Module Map

Accounts Receivable (A/R) Module Product Map

Overview

General Forms & Features

General Business Rules, Processes, Forms and Features

 

Section Product Code/ Wiki Page Description Supporting Information Developer
General 101-ar Accounts Receivable Module Overview
101-ar-brules System Integrity and Business Rules System Registry
100-ach Centralized page for Automated Clearing House (ACH) 100-ach (dev)
100-pos Centralized page for Point-of-Sale Processing (POS) 100-pos (dev)
A/R Forms 101-ar-frm-001 AR Inquiry 101-ar-frm-001
101-ar-frm-003 AR Inquiry Notes with ACH Information
101-ar-frm-004 AR Inquiry ACH Information General ACH Processing
101-ar-frm-008
101-ar-fea-038		 AR Inquiry Payment Plan
AR Allow Payment Less Than Payment Plan Feature
101-ar-frm-006 AR Deposit Management
101-ar-frm-020 AR Payment Data Entry
101-ar-frm-021 AR Data Entry – AR Transactions
101-ar-frm-022 AR Data Entry – Abatements and Exemptions
101-ar-frm-023 AR Data Entry – Adjustments
101-ar-frm-024 AR Data Entry – Interest, Penalties, Fees and Charges
101-ar-frm-025 AR Data Entry – Refunds
101-ar-frm-026 AR Data Entry – Payment Reversals
101-ar-frm-027 AR Data Entry – Payment Transfer
101-ar-frm-028 AR Data Entry – Refund Reversals
A/R Features 101-ar-fea-002 Using Protest Flags
101-ar-fea-003 Receipting
101-ar-fea-004
101-std-fea-004		 Dynamic e-search – Standards A/R
Dynamic e-search – Standards
101-ar-fea-010 Accounts Receivable Interest & Penalty Methods A/R Parameters
101-ar-fea-005 Overpayments (OCR & OCH processing)
101-ar-fea-006 ACH Processing General ACH Processing
101-ar-fea-010 A/R Credited Interest on Refund
101-ar-fea-011 A/R Class Code Included in Balance Forward 101-ar-fea-011
101-ar-fea-020 Group Adjustments
101-ar-fea-025 BT – Period Validation for AR Deposit in CC Payment Data Entry
101-ar-fea-026 A/R Search to Load Feature
101-ar-fea-027 Change Payer Name in A/R Inquiry
101-ar-fea-028 AR Inquiry – Payment Transfer
ACH 201-ar-fea-006 ACH Processing eGovern
101-ar-fea-016 ACH Processing Govern Payment Plan (option) Roadmap 101-ar-fea-016
101-ar-fea-017 ACH Processing Credit Filing
ACH egov 201-ar-fea-017 ACH Processing eGovern Credit Filing (ST Remittance)
101-ar-fea-007 Allow Interest and Fees as of date
101-ar-fea-008 Allow Payment Plan Processing
101-ar-fea-009 Security by Property Area Fields Roadmap (DEV) 101-ar-fea-009
Custom Control Payer name 101-ar-fea-021 Payer name Custom Control (New) 101-ar-fea-021-ofr (DEV) 101-ar-fea-021
(QC) 101-ar-fea-021
Action Button Control 101-ar-fea-022 Create A/R for MB, ST, RE, PP, etc. 101-ar-fea-022-ofr
101-ar-fea-023 A/R Method Waiver for Min/Max SRT Filings
101-ar-fea-024 AR Payment Action Button 101-ar-fea-024-ofr
Cash Collection 101-cc-frm-001 Cash Collection Data Entry CC wiki Map (DEV) 101-cc-frm-001

 

Batch Process (bp)

Accounts Receivable Batch Processing

Status Wiki Page / Code Batch Process Name Batch Process Supporting
Information		 GFW Batch Process
Batch Processes 101-ar-bp-001 AR Apply Pending Credits ar_applypencr mnu_apply_cr
101-ar-bp-002 AR Set Warning Flag on Delinquent ar_setwarning mnu_set_w_flag
101-ar-bp-003 AR Apply Penalty on Delinquent ar_apppendelinq mnu_ar_interest
101-ar-bp-004 AR Generate Delinquent Charges ar_gendelinqchg mnu_ar_charge
101-ar-bp-005 AR Apply Deposits ar_appdeposits
101-ar-bp-006 AR Compute Balance As Of a Date ar_compbaldue mnu_late_charge
101-ar-bp-007 AR Extract As Of Date A/R Detail Table ar_extrasofdate mnu_extract_ar
101-ar-bp-008 AR Generate Refunds ar_genrefunds Missing batch process mnu_gen_rf
101-ar-bp-009 AR Generate Over and Short ar_genovershort mnu_bal_adj
101-ar-bp-010 AR Transfer to History ar_tranartohist mnu_ar_hist
101-ar-bp-011 AR Re-Initialize A/R Tables ar_reinittables mnu_ar_init_tab
101-ar-bp-012 AR Period Closing ar_perclosing mnu_ar_p_close
101-ar-bp-013 AR Transfer Credits from One Year to Another ar_transcrd mnu_ar_credit
101-ar-bp-100 AR Posting – Combined Posting of all type Roadmap (14487)
101-ar-bp-020 AR Posting – Payments
AR Posting – Cash Collection (CC or)		 ar_postcashcol mnu_ar_cc
101-ar-bp-021 AR Posting – AR Transaction Not available
101-ar-bp-022 AR Posting – Abatements and Exemptions Not available
101-ar-bp-023 AR Posting – Adjustments ar_postadjust mnu_ar_adj
101-ar-bp-024 AR Posting – Interest, Penalties, Fees and Charges Not available
101-ar-bp-025 AR Posting – Refunds ar_postrefunds mnu_ar_refund
101-ar-bp-026 AR Posting – Payment Reversals ar_postpayrev mnu_ar_rev
101-ar-bp-027 AR Posting – Payment Transfers ar_postpaytrf
101-ar-bp-030 AR Posting – Postdated Payments ar_postdatedpmt mnu_ar_pdt
101-ar-bp-031 AR Posting – Deposits ar_postdeposit mnu_ar_deposit
eGov 201-ar-bp-033 AR eReipting (e-Gov System) ar_ereceipting
eGov 201-ar-bp-034 AR eBilling (eGov System) ar_ebilling
101-ar-bp-035 AR Create AR Levy Close File? ar_levyclose
101-ar-bp-036
101-ar-frm-036		 AR Lock Box Batch Process Posting
AR Lock Box Maintenance Form		 ar_lockbox 101-frm-036-config
Lockbox Layout to distribute 6.0/61
Change Assessment
101-ar-bp-038 AR Generate Check Refund Numbers ar_gencheck
DC 101-ar-bp-039 AR Transfer Delinquency GA 1609 Batch process to transfer delinquant accounts to Delinquency
Other 101-ar-bp-040 AR Generate GL Account gl_tranacc_updt General Ledger Account Update
101-ar-bp-041 AR Generate Payment Reversals for a Batch ar_gen_reversal GA 1609 Batch process to create payment reversals for a posted batch of payments
ACH 101-ar-bp-060 AR ACH Pre-notification File ar_ach_prenote GA1609
101-ar-bp-061 AR ACH Prepare Data for ACH File Balance Due ar_ach_bal GA1609
101-ar-bp-062 AR ACH Generate ACH File ar_ach_file GA1609 Changed from 037 to 060 AR ACH File Process
101-ar-bp-063 AR ACH Post Dated Payment Plan Roadmap Changed from 039 to 063
101-ar-bp-064 AR ACH Update Payment Plan Status version 6.0 only
eGov 201-ar-bp-065 AR ACH Process for Web Payments Validate if any changes
Tax billing 101-tx-bp-040 Tax TSO Registration tx_tso_registr
101-tx-bp-041 Tax TSO Bill Request tx_tso_billreq
101-tx-bp-042 Tax TSO Generate Tax Amount tx_tso_amount
101-tx-bp-043 Tax TSO Batch Payment Generation tx_tso_pmtgen
101-ar-bp-080 AR Batch Deletion of Payments ar_delpayments mnu_ar_pmt_del
101-ar-bp-081 AR Batch Deletion of Refunds ar_delrefunds mnu_ar_rf_del
101-ar-bp-082 AR Batch Deletion of A/R Transactions ar_deltrans mnu_ar_tran_del
Bankruptcy Bankruptcy
101-br-bp-050 AR Bankruptcy Posting bk_postbkruptcy
101-br-bp-051 AR Bankruptcy Delinquent Posting bk_postdelinq
General Ledger 101-ar-bp-040 AR GL Account gl_tranacc_updt
Parameters 103-ar-bp-105 Copy AR CLass Code Batch Process ar_copy_to_year

Reports (rpt)

Accounts Receivable Standard Reports

Status Wiki Page Batch Process Name Report Process Name Supporting Information Description
Edits & Balancing 101-ar-rpt-001 A/R report
101-ar-rpt-002
101-ar-rpt-003
101-ar-rpt-004 Cash Balancing Report cashbal.rpt under construction Version 6.0 and 6.1
ACH Processing 101-ar-rpt-060 ACH Edit List (Encryption Method Backward Compatible) ach_list Roadmap This reports displays ACH information.
101-ar-rpt-061
101-gl-rpt-001 AR Distribution General Ledger auxialgl.rpt

 

Business Rules

Status Wiki Page Name Document Type Notes
101-ar-ref-TransactionRules AR Transaction Rules (table) The Golden rules of AR Transactions
101-ar-ref-TransactionType AR Transaction Type System Table (table)
101-ar-ref-GLAccountingRules AR to GL Account Business Rules (rules)(schema)
101-ar-brules-validation AR Object Error Reporting
101-ar-brules-payment Payment Application Priorities
101-ar-ref-ErrorCodes AR Posting Error Table

Application Parameters

See GNA map for more information

Status Wiki Page Name Notes
103-ar-parm-General General AR Parameters
103-ar-parm-Deposit Deposit Management Parameters
103-ar-parm-Priorities Sub-System Payment Application Priorities
103-ar-parm-ARClasscode A/R Class Codes
103-ar-parm-GLAccounts A/R GL Account
103-ar-parm-CC Cash Collection Parameters
103-ar-parm-ACH ACH Parameters
103-ar-parm-Tables System and Validation Tables
103-ar-parm-Escrow Escrow Paramters
103-ar-parm-CopyYear Copy AR Class Code to Year
103-ar-parm-Calendar A/R Parameters Calendar

 

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

308-icloud

Integration – Invoice Cloud

Version 6.0

Overview

Governs’ Invoice Cloud integration provides an invoice presentation / payment solution using Invoice Cloud. With Invoice Cloud integration Govern users have 24/7 access to on-line bills and flexible payment options that include all major credit/debit cards and eChecks.
Invoice Cloud consists of 2 major areas. Batch Functions that can be scheduled to send Billing Information reports to Invoice Cloud and the AR & CC Cash Collection Service.

Requirement

Integration needed with invoice cloud. We need to make a new service that:
1. Allows Payments
2. Allows Payment Reversal
3. Update Paperless status for Mailing Index
4. GetArBalances
See AR/CC Web Service

The following actions are also needed:
1. Generate a Summary Account Balance and send it to an FTP
2. Generate a Detail Account Balance (bill) and send it to an FTP

Tax & UB Bill

Tax and Utility Billing PDF Bill

Account Balance Extract

Account Balance Extract is created and push to the FTP.
Work Order for Code: WALGOL1202
Crystal reports that show the balance for each NA_ID

Batch Processes

Consists of 2 batch process that generate reports in CSV format.

1) Batch process – Invoice Cloud Balance :
UI : ComboBox SubSystems (only RE, PP, UB)
Nb. Activity days Add to the report all entries in AR_Master having activities (all activities in AR_DETAIL except payment from InvoiceCloud) in the X last days of activity.

2) Batch Process – Invoice Cloud Invoice :
. UI : ComboBox SubSystems (only RE, PP, UB) ComboBox SubSystems (only RE, PP, UB)

a) subsystems : RE, PP :
UI : Year, Installment
File Name to generate : XXXXXX_RE_TimeStamp.csv or XXXXXX_PP_TimeStamp.csv

b) Subsystem : UB :
UI : ComboBox : Posting ID – Posting Date (From table UB_POST_MASTER)
File Name to generate : XXXXXX_UB_TimeStamp.csv

The Total Billed should be the Sum of Amounts from AR_DETAIL where type = ‘INV’ and having Creation_Date = Posting_Date

Supporting Documents

Click on the links below to view the .PDF document.

Right-click on the links below to down the view the .PDF document.

To download the Excel files below, either right click on the link and select “Save Link As…” from the menu, or click directly and select the option to open in Microsoft Excel.

To download the .CSV files below, right click on the link and select “Save Link As…” from the menu. The file may then be opened in an application like Microsoft Excel.

SQL for the INVOICE

SELECT "AR_MASTER"."SUB_SYSTEM", "AR_MASTER"."YEAR_ID", "AR_SUMMARY"."INSTALLMENT", "AR_SUMMARY"."AR_ID", "NA_MAILING_INDEX"."NA_ID", "NA_NAMES"."FREE_LINE_1", "NA_NAMES"."STREET", "NA_NAMES"."CIVIC", "NA_NAMES"."PRE_DIR", "NA_NAMES"."S_SUFFIX", "NA_NAMES"."POST_DIR", "NA_NAMES"."SEC_ADD_IND", "NA_NAMES"."UNIT", "NA_NAMES"."CITY", "NA_NAMES"."STATE", "NA_NAMES"."ADD_LINE_A", "NA_NAMES"."ZIP_POSTAL", "NA_NAMES"."EMAIL", "NA_NAMES"."NAME_2", "AR_MASTER"."SORT_KEY", "AR_SUMMARY"."PRINCIPAL", "NA_MAILING_INDEX"."SUB_SYSTEM", "NA_MAILING_INDEX"."PRIMARY_INDEX"
FROM (("Waltham"."dbo"."AR_MASTER" "AR_MASTER" INNER JOIN "Waltham"."dbo"."AR_SUMMARY" "AR_SUMMARY" ON "AR_MASTER"."AR_ID"="AR_SUMMARY"."AR_ID") LEFT OUTER JOIN "Waltham"."dbo"."NA_MAILING_INDEX" "NA_MAILING_INDEX" ON ("AR_MASTER"."P_ID"="NA_MAILING_INDEX"."REF_ID") AND ("AR_MASTER"."SUB_SYSTEM"="NA_MAILING_INDEX"."SUB_SYSTEM")) LEFT OUTER JOIN "Waltham"."dbo"."NA_NAMES" "NA_NAMES" ON "NA_MAILING_INDEX"."NA_ID"="NA_NAMES"."NA_ID"
WHERE "NA_MAILING_INDEX"."PRIMARY_INDEX"=-1 AND "NA_MAILING_INDEX"."SUB_SYSTEM"='UB'
ORDER BY "AR_SUMMARY"."AR_ID"

SQL for the BALANCE

SELECT "AR_MASTER"."SUB_SYSTEM", "AR_MASTER"."YEAR_ID", "AR_SUMMARY"."INSTALLMENT", "AR_MASTER"."AR_ID", "AR_SUMMARY"."AR_ID", "NA_MAILING_INDEX"."NA_ID", "NA_MAILING_INDEX_1"."NA_ID", "AR_SUMMARY"."BALANCE", "NA_MAILING_INDEX"."SUB_SYSTEM"
FROM (("Waltham"."dbo"."AR_MASTER" "AR_MASTER" INNER JOIN "Waltham"."dbo"."AR_SUMMARY" "AR_SUMMARY" ON "AR_MASTER"."AR_ID"="AR_SUMMARY"."AR_ID") LEFT OUTER JOIN "Waltham"."dbo"."NA_MAILING_INDEX" "NA_MAILING_INDEX" ON ("AR_MASTER"."P_ID"="NA_MAILING_INDEX"."REF_ID") AND ("AR_MASTER"."SUB_SYSTEM"="NA_MAILING_INDEX"."SUB_SYSTEM")) LEFT OUTER JOIN "Waltham"."dbo"."NA_MAILING_INDEX" "NA_MAILING_INDEX_1" ON ("AR_MASTER"."UB_ID"="NA_MAILING_INDEX_1"."REF_ID") AND ("AR_MASTER"."SUB_SYSTEM"="NA_MAILING_INDEX_1"."SUB_SYSTEM")
WHERE "NA_MAILING_INDEX"."SUB_SYSTEM"='RE' AND "AR_MASTER"."YEAR_ID"=2012 ORDER BY "AR_MASTER"."AR_ID", "AR_SUMMARY"."INSTALLMENT"

Installation of Web Services

Invoice Cloud Web Service (Release 5.1)

To install the following are the installation steps for the Invoice Cloud Web Service:

  1. Deploy the Release 5.0.9 of the Resources Files.
  2. Install and configure the WCF Accounts Receivable API [Filename: WCFAccountsReceivableAPI.zip].
  3. Modify the web.config file to use the GoverNetConfig.xml of the deployment [Location: In the root of the specific deployment folder]
  4. When installing Release 5.1 of the web service, administrators will need to manually create the following table in (Table: NA_NAMES: WEBPROFILEACCESSRT (Smallint, Allows Null). This field was added to provide support for the eGov and is used in the business rules of the Names.

Verification of the Service

The WcfTestClient.exe application is used to test the web service. This application can be obtained on the Govern FTP site or from Govern Technical Support: WCF Test Application.zip. For additional details regarding testing Govern Web Services

What’s New!

Release 6.0
The two (2) Govern batch processes that are associated with the Invoice Cloud process for Real Property and Personal Property modules have been modified to allow them to identify required InvoiceTypeID’s that match with AR Cycle codes for Real Property (RE) and Personal Property (PP). – Release 1703.06

Prior to release 6.0 of the Govern Web service, manual changes were required to be made during the installation of the Invoice Cloud Web Service:

  • Modify the web.config to use the GovernNetConfig.xml file located in the deployment root directory.
  • Create (Table: NA_NAMES.WEBPROFILEACCESSRT), with properties set to (smallint, allow NULLS).

The above steps are no longer required, they are automatically created when the Database Verification process is run in the Govern New Administration (GNA).

Related Topic(s)

Govern API and Service

 

 

308-icloud

 

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 Inquiry – Change Payer Name (101-ar-fea-027)

Accounts Receivable (AR) – Change Payer Name in AR Inquiry

Overview

The Accounts Receivable Inquiry form displays transaction details on the selected account, including historical data. This form is linked to the master file of each subsystem so that you can access all the A/R information available on a given property or taxpayer name and address record.

The Accounts Receivable Inquiry form includes a Summary and a Detail section. The Summary section lists the Accounts Receivable transactions for the selected record. The Detail section displays transaction details on each entry selected in the Summary section.

There are two (2) ways to change the payer name in AR Inquiry:

  • Payment Data Entry
  • Double click on Payer Name row and column in Cash Flow

Functionalities

  • Payment Data Entry:

    The Payment Data Entry is using the CC Payor Name control
  • Double click on Payer Name row and column in Cash Flow

    Double clicking on row and column of Payer Name will open a window to change the payer name

Configuration

To be able to open the window to change the payer name in Cash Flow, the following setting must be set in the security of OFD in Accounts Receivable form:

The option “Disable Editing Payer Name in Cash Flow” must be disable to able to use the feature.

Related Topics

Accounts Receivable (A/R) – Payment Transfer Data Entry (101-ar-frm-027)

Accounts Receivable (A/R) – AR Inquiry form (101-ar-frm-001)

Accounts Receivable (AR) – What’s New

 

 

101-ar-fea-027

 

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

AR – Escrow Parameters (103-ar-parm-escrow)

Accounts Receivable (A/R) – Escrow Parameters

Version 6.1.1702.0557

Overview

NOTE: A/R Escrow is not a standard function. The individual Escrow process can vary, and as such, with arrangements with Govern development, the module may be customized to meet individual business requirements. It is through the A/R Escrow Parameter form that Escrow Information is created and maintained. For more information on the ESCROW feature please contact Govern R&D.

Escrow is a legal concept in which a financial instrument or asset is held by a third party on behalf of two other parties that are in the process of completing a transaction. The funds or assets are held by the escrow agent until it receives instructions or until predetermined contractual obligations have been fulfilled. Money, securities, and funds can all be held in escrow.

In the current context of Govern, Escrow payments allow taxpayers to sign up to send in coupons or ACH transactions out of their savings or checking accounts. The escrow module allows counties to manage escrow accounts, calculate/override amounts to be withdrawn, send out coupons, import payments, and enter payments to satisfy the requirements of the escrow process. In addition, the escrow module will calculate interest earned on certain types of escrow accounts. At the end, the system will apply the escrow payments to the qualifying accounts.

User Interface (UI)

A/R Escrow Parameters Form

The A/R Escrow Parameter editor is a standard Govern parameter creation UI. For UI details, refer to the Govern New Administration (GNA) Editors section of the GNA user guide.

A/R Escrow Parameters Form – parameters

In order to set up the Escrow, users must create the required account types in the A/R Escrow Parameters form. When the A/R menu item is selected, you will need to complete the required parameters.

Code – Enter a unique period detail code. This field is auto populated with the period code and a formatted period number in the following format: PeriodCode_PeriodNo. This is a required field.

EXAMPLE: When the period code selected is “MONTHLY”, then the generated codes will be MONTHLY_01, MONTHLY_02, MONTHLY_03, … , MONTHLY_12.

English Short Description – This is the English description that will be used for fast data entry and lookups where space is limited on forms.

English Long Description – Enter the English description that will be displayed for lookups on forms, and normally used for reporting

Sub System – Select the Sub System of the account type; select Real Property (RE) for Escrow to function. Please note that this is a Required field.

Cycle Code – Select the Escrow cycle code from the combo-box; this required field will contain the Escrow cycle code.

Number of Periods – Select the number of periods required for the escrow. These periods will correspond to an annual, semi-annual, or monthly setup.

  • Annual – When the requirement of the escrow is annual, the number of Periods is set to 1; when selected, the system will create one (1) escrow detail parameter.
  • Semi-Annual – An escrow that is semi-annual will require two periods; when selected, the system will create two (2) escrow detail parameters.
  • Monthly – When monthly is selected, the number of periods is twelve; when selected, the system will automatically create twelve (12) escrow detail parameters.

When a period has been selected in Number of Periods, the grid below the parameter will be populated accordingly.

After selecting a period number, each escrow installment detail will display its required parameters. Click on each line item in the grid to display its corresponding parameters.

Period Code: This is a unique account type code; this parameter is auto filled from the master escrow.

Installment: The installment of the escrow detail.

  • For the 1st half, the installment = ’01’
  • For the 2nd half, the installment = ’02’

For example,

  • Monthly – First 6 periods: the installment = ’01’
  • Monthly – Last 6 periods: the installment = ’02’
  • Annual: the installment = ’01’
  • Semi-Annual – the first period: the installment = ’01’
  • Semi-Annual – the last period: the installment = ’02’

ACH Date: This is the date for the Automated Clearing House (ACH) transaction; this is a Required field.

NOTE: The current ACH date must be greater than the previous ACH date.

Coupon Due Date: This parameter must contain the due date for the coupon; this is a Required field.

NOTE: The current coupon due date must be greater than the previous coupon due date.

Once configuration is complete, the escrow record can be created and accessed in Govern.

Configuration

Read More...

Pre-Configuration Steps

Escrow allows a county or municipality to collect money that will be kept in a temporary account in advance. The user must create all account types (A/R Escrow parameters) in the Govern New Administration (GNA) before creating the escrow in Govern.

Govern New Administration (GNA)

In order to ensure that the A/R Escrow Parameters menu is visible in GNA, you will need to run the GNA Verify Database process.

Security Manager (SM)

After running the Verify Database process, open the Govern Security Manager. In the SM, you will need to select Synchronize All in the Govern Security Manager (SM).

Govern New Administration (GNA)

The A/R Escrow Parameters Editor is located in the GNA.

To locate the A/R Escrow Parameters menu in the GNA ribbon:

  1. Select Application Configurations (tab) > Accounts Receivable (Govern Tax Group) > A/R Escrow Parameters.
NOTE: If the menu is not visible in GNA, refer back to the Pre-Configuration Steps section above.

Configuration of Escrow Periods

The following steps should be used as a guide to configure the required escrow periods:

Configuration – Annual (December)

Configuration – Semi-Annual (December)

Configuration – Monthly

NOTE: Periods 6 and 12 will not be used for a Coupon, they will be used for ACH only.

 

Documentation

When available, a link to documentation will be located here!

Related Topics

What’s New in Accounts Receivable (AR)

 

 

103-ar-parm-Escrow

 

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 – Justification Combo Box (101-ar-fea-029)

Accounts Receivable (A/R) Justification Combo box

Available in Release 6.0.1903

Overview

The Accounts Receivable Inquiry form displays transaction details on the selected account, including historical data. This form is linked to the master file of each subsystem so that you can access all the A/R information available on a given property or taxpayer name and address record.

This is a combo box for specifying a Justification code or Reason code on the AR Inquiry form. This combo-box can be configured to show a Code and/or Description. This is the same as an Entity or GfW. If no entry is selected, the default entry will be the Short Description.

Configuration

NOTE: Before proceeding, ensure that you have updated to Govern Rel. 6.0.1903 and above.

This option is configured in the Govern OpenForms Designer (OFD).

To configure this feature…

1. As an administrator, open the OFD.

2. On the OFD ribbon click Open Form.

3. From the list, select the Accounts Receivable form (default AR008 – Accounts Receivable).

4. Click to select the A/R Inquiry tab.

5. On the left-hand side Properties pane, click to expand Properties.

6. Under the list of properties, click to select Justification Code Display Type.

7. Select the default preference for the combo-box.

8. Click Save to save your configuration.

 

Related Topics

Accounts Receivable (A/R) Inquiry

Accounts Receivable (AR) – What’s New

 

 

101-ar-fea-029

 

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 Payment Transfer (101-ar-fea-028)

Accounts Receivable (AR) Feature – Payment Transfer

Overview

The Accounts Receivable Inquiry form displays transaction details on the selected account, including historical data. This form is linked to the master file of each subsystem so that you can access all the A/R information available on a given property or taxpayer name and address record.

Payment transfers are used to transfer posted payments from one account to another. Typically, they are used to correct an error such as a payment made and posted to the wrong account. For example, a client could make a payment intended for a utility bill that is somehow processed on a tax bill. To correct this error, you can create a Payment Transfer.

Functionalities

Creating a Payment Transfer

To create a payment transfer:

  1. Open a record.
  2. In the A/R Inquiry screen right click on a Posted payment line item
  3. On the floating menu select Account Receivable – Payment Transfer

Read More...

 

4. The Accounts Receivable – Payment Transfer form is displayed.

5. On the form click to select a transfer destination; Out Of System, Different Account for Selected Name/Tax Map Number, or Selected Accounts.

Full payment transferred

If the Full payment transferred option is checked…

In the Original Payment Information, the Amount listed is for the selected AR_ID, which is not necessarily the full payment. If Full payment transferred checkbox is checked, in the Transfer Information section, the Transfer Amount is updated to reflect the full payment amount, including all AR_ID’s attached to the payment. The same is done to the Remaining Balance in the Transfer Destination area.

Changing a Payment transfer

Example: When a Payment only deletion is permitted.

Do not transfer late charges (Just transfer credit amount)

When the Do not transfer late charges option is not selected, i.e. the default, both the principal and interest are transferred.

When the Do not transfer late charges option is selected, only the principal is transferred. This option is useful if the penalty and interest are calculated separately. There was a client that had that need.

NOTE: This applies to full payments, only. In instances of partial payments, the interest is not transferred, only the principal.

 

DEV NOTE: As stated above, a functionality of this feature when modified will only transfer the OCH part of the payment. Since partial payments do not transfer late charges by default a partial payment = OCH amount will do just that. If required by users, this change to functionality can be requested through Govern Customer Support.

Scenarios

Over-payment with Interests and penalties

Preparation

In this scenario, we have a balance of 400$. We add 100$ interests, 100$ penalties and add an extra 100$ to the now 600 balance which make the total amount 700$. Post the payment.

Test Do not Transfer late charges for a full Payment transfer

Result on Source Account. The result seems wrong since only 400$ should have been transferred.

Result on Target Account.

Transfer Full Payment Option

Target Account Results

Source Accounts Result

Do not transfer late charges for a partial payment

Source Account Result

Target Account Result

 

Related Topics

Accounts Receivable (A/R) – Payment Transfer Data Entry

Accounts Receivable (AR) – What’s New

 

 

101-ar-fea-028

 

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