Version 6.0 | Version 6.1

Overview

Cash collection standard OpenForms Reference distributed items include:

• System Queries (Totals deposit queries … )
• Dynamic Search Queries Forms (New search group and style)
• Business Entity Model and Entities (Standards)
• Cash Collection Form

The Database tables used in Cash Collection include:

• CC_MASTER (key = BATCH_ID)
• AR_BATCH_NO (key = BATCH_NO and BATCH_ID)
• AR_DETAIL (key = BATCH_ID)

Govern IDs used for Cash Collection:

• CC ID (1603)
• Batch ID (roadmap)

Govern Access ID used for Cash Collection:

• Any Govern ID
• No Govern ID

System and Dynamic Queries

Deposit Form Total and Chart Queries
The following system queries are used to provide the totals on the deposit section of the cash collection.

• CCIBldgCount Total Principal
• CCcc003 Total Charges
• CCcc004 Total Collected
• CCcc002 Total Penalty
• CCcc005 Total Discount

Dynamic Query Group

• A/R Payment Data Entry (new) is the form default
• New Search Queries linked to the A/R Payment Entry Group include:

Govern Views

• View for A/R Description in CC and Receipt A/R Description to print (roadmap)

System Resources

• Text Resources for Cash Collection

 

Business Model and Entities (BED)

The Cash Collection Model (CC_CASH_COLLECTION) contains 2 business entities:

• Deposit Management (AR_DEPOSIT)
  • Root entity of the form as the user must first select a deposit number before the data entry of payments
  • OpenForms entity (It is possible to setup new fields to be added to the deposit management divider of the form)
• Cash Collection Master (CC_MASTER)
  • OpenForms entity with custom controls

Business Entities Setup (BED)

The following Standard OpenForms Features can be set-up in BED:
Model – Cash Collection (CC-001)

• Used by Query Tool Property

Entity – Deposit Management (AR_DEPOSIT)

OFD Configuration – Click to Enlarge

Note is Required on Creation

• Note is Allowed on Modification

Entity – Cash Collection Master (CC _Master)

• Note is Required on Creation
• Note is Allowed on Modification

 

Cash Collection Form (OFD)

Overview

The following controllers are used and system default options can be configured on the Cash Collection Form (cc001)

Payment Controller (CC_PaymentDataEntry_Control)
Click on the payment controller miscellaneous properties.

• SEARCH GROUP
  • Styles from this group will be used in the search
• AR INQUIRY FORM (Enable Auto-Launch)
  • Form to linked to when user double clicks on a A/R (Drill down)

Payer Name Controller

• Payer Name (Used in Cash Collection to record the name)
  • Can Create Properties
  • Selected Search Group and Name and Address Form

Login as Administrator

• Login As Administrator

 

Setup the Search Group

The following standard OpenForms features are setup:

Search Group

Payment Data Entry Controller CCPaymentDataEntry_Control

• Click on the Payment Data Entry Tab
  • Click on the CC PaymentDataEntry_Control
  • In the Properties, expand Properties, expand Misc
  • Select the Dynamic Group to use in the Quick Search form

 

Enable Auto-Launch of A/R form (Drill Down to A/R Inquiry)

 

NEW! As of Release 6.0.1603.262 the Cash Collection Payment Data Entry grid can configured to exhibit a new behavior when the user double clicks on a line item.

To obtain this new behavior, configuration will need to occur in the Payment Data Entry tab of the Cash Collection OpenForm. This configuration is carried out using the OpenForms Designer (OFD). To make this change in the OFD…

1. Open the CC001 – Cash Collection Form
2. Click to select the Payment Data Entry tab
3. Locate and click on the CCPaymentDataEntry_Control.
4. On the right hand side, Properties pane, locate and expand the Misc section; set the ArInquiryForm parameter to AR008 – Accounts Receivable.
5. Click Save.

 

Behavior in Govern

In Govern, when users are in the Cash Collection form, click on the Cash Collection Data Entry tab. A double click on a line item in the grid will load the Accounts Receivable (AR008) form.