Standard AR Controller – Create A/R (101-ar-fea-022)

Standard Accounts Receivable (A/R) Controller – Create A/R

Overview

This new 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 summary record on demand. With the A/R record, it will be possible for the users to enter deposits or voluntary payments against this Account.

  • The Create A/R button can be used for all Sub-Systems (Real Property, Self-Reported Tax, Personal Property, Miscellaneous Billing, etc.)
  • The Create A/R button is only available after an Account is created and saved where no A/R records associated to the account exists.
  • Once the Create A/R action has been executed, the button becomes disabled.
  • The A/R record created will match the System Registry A/R Sub-System rules (by name, by parcel, by year), etc. as configured in the A/R General Parameters Sub-System parameters.
  • This action button can be secured by profile user and role.

Configuration

This controller is used in different standard Forms distributed with the system. It can also be added and configured on a customized form.
To add or configure this controller on a form click below:

 

 

Related Topics

Standard A/R Controller Configuration (101-ar-fea-022-ofr)

Accounts Receivable Parameters (103-ar-parm-General)

 

 

101-ar-fea-022

 

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 – Controller Config – Create AR Payment

Standard Accounts Receivable (A/R) Controller – Create A/R Payment (Configuration)

Overview

This standard OpenForms Action Button controller can be added to a form to provide an Action Button to create the Accounts Receivable payment.

This controller is available in GA Release 1706

  • For more information on the functionality, see Product Information (101-ar-fea-024).

Prerequisites

The following conditions are required in order to enable the Controller in OpenForms Designer Setup

  • The organization is licensed for the Accounts Receivable Sub-System to setup
  • The configuration for the Accounts Receivable has been completed
  • The Form’s ID Setters Properties must contain the …
  • The Govern ID must be …

Profile Security

  • The user must have security access (GSM) to the profile’s form.

 

101-ar-fea-022-ofr-UI.png
Action Button Controller Properties

 

Controller Setup

Adding a Custom Control to a Form

  • In OFD, drag the Action Button Control Icon to the Account Entity Tab on the form.

Custom Control Form Configuration

Once the Custom Control is displayed on the form, click on the object to configure the:

  • Assembly Name = Msgovern.OpenForms.CustomControls.dll (by default)
  • Class Name = AR_CreateARMaster_Action

User Interface (UI)

  • Icon
  • Is enable: An expression can be added to control the enabling (Can be executed) of the button.

Controller Properties

The following controller properties need to be set:

Sub-System

  • Select the sub-system for which the A/R Summary Record needs to be created.

Related Topics

For more information, see:

Troubleshooting

  • The Organization must be a licensed user of the A/R Sub-System selected.

 

 

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

 

AR – CC – Allow Payment less than Payment Plan Amount

Accounts Receivable (AR) & Cash Collection (CC) – Allow Payment less than Payment Plan Amount

Overview

This feature allows the collection of a payment that is less than the predefined Payment Plan Amount.

User Interaction

In Cash Collection, when a user tries to make a payment that is less than the set minimum to collect, a pop-up message is displayed. This message will block the transaction and prevent the saving of the payment. If the permission is checked, the message will no longer be displayed to the user. The payment can then be saved even if the amount is less than the set minimum that is to be collected.

Setup

To configure this option, you must set the new security parameter in the OpenForms Designer (OFD). This option can be set by Profile or by user for the Cash Collection Form.

NOTE: The default setting for all users for this permission is, False (F) .

In the OFD select… Cash Collection > Payment Data Entry > CCPaymentDataEntry_Control (while in security mode), set the following parameter:

  • Allow to pay less than minimum to collect

 

 

101-ar-fea-038

 

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 Detail

Accounts Receivable (A/R) Inquiry Detail

Overview

NOTE: The A/R Inquiry Detail form has been merged with the AR Inquiry form.

 

 

101-ar-frm-002

 

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 Notes

Accounts Receivable (A/R) Inquiry Notes

Overview

Use the Notes tab of the A/R Inquiry form for adding comments and warning codes, additional information about delinquent charges, history, arrears, and ACH payment information to the selected record.

Documentation

For the complete reference guide, see 101-all-001-GovernAccountsReceivable-(man)-(6.0)
For the A/R Transaction Rules, see 101-ar-001-AR-TransRulesGL.

Prerequisites

The following Regular User Validation Tables are required for the A/R Alerts, Warnings, and Protest Codes.

  • ARALERT: for the A/R Alert Codes
  • ARWARNC: for the A/R Warning Codes
  • ARPROT: for the A/R Protext Codes
  • COLLAGCY: for the Collection Agencies used for A/R

To access these tables:

  1. Launch GNA.
  2. Select Editors > User Validation Table Editor.
  3. Select Regular from the Table Type drop-down list.
  4. Select the table.
  5. Click Codes to add, modify, or delete codes.
  6. Click Save.

Completing the Notes Form for Alerts and Warnings

The form contains the following sections:

  1. General Information
  2. ACH Information
  3. Notes and Comments

General Information

Alert Code: Select an Alert Code from the drop-down list (Table: VT_USR_ ARALERT). An Alert is more severe than a Warning. If an alert code is associated with the account, no payment entry can be made.
Warning Code: Select a Warning Code from the drop-down list (Table: VT_USR_ARWARNC). A Warning is less severe than an Alert, in that a notification is sent, but the user can make a payment entry.
Collection Agency: Select a Collection Agency for the account from the drop-down list (Table: VT_USR_COLLAGCY).
Notes and Comments: Enter any notes or comments for the account.

Additional Information

Not Subject to Delinquent Charges
Select this option if you don’t want any interest calculated on the current account. Otherwise, these charges are calculated automatically.
History / Inactive Account
Select this option to indicate the account is historical or inactive. No further Accounts Receivable transactions can be performed on the account.
Arrears
Select the calendar beside the Arrears date field to select the date that the account went into arrears. Depending on your organization, the date could be populated by a batch process.

ACH Information

Amount: This field displays the amount for the selected record. This can be the amount of the displayed installment or a fixed amount. To override this value, for example, for partial payments, modify the field directly and click Save.
Installment: If the displayed amount is an installment, this field displays first, second, third, fourth or total (Table: VT_SY_INSTALL).
Active Flag: The Prepare Data for ACH File process sets the Active Flag to Pending. In the Pending state, you can:

  • Modify the displayed amount.
  • Change the Active Flag to Manually Deactivated.

Records set to Manually Deactivated are not included in the ACH File. Use this state for accounts that cannot be prenoted; for example, invalid accounts.
ACH Date: This field displays the date the Prepare Data for ACH File process was run.
Fixed Amount: Select this option if the selected amount is a fixed amount.

 

 

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

 

AR – Inquiry ACH Information

Accounts Receivable (AR) Inquiry ACH Information

Overview

The A/R Information tab of the A/R Inquiry form includes a section for ACH Information.

This is updated automatically when you run the Prepare Data for ACH and the ACH Generate File batch process. For details, see
ACH Batch Processes

 

 

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

AR – Inquiry Payment Plan

Accounts Receivable (A/R) Inquiry Payment Plan

Overview

The A/R Inquiry Payment Plan is used for defining a payment and calculating when payments are due. The form provides some flexibility. Payments can be received between dates and made for less than the amount specified in the Amount per Period field. The Next Payment Date field is updated when the full amount for the period has been paid.

Documentation

For the complete reference guide, see Govern Accounts Receivable.
For the A/R Transaction Rules, see 101-ar-001-AR-TransRulesGL.

Running Reversal and Refund Batch Processes

If you run the A/R Refund Posting or A/R Reversal Posting batch processes for a payment made through the Payment Plan, start with the last payment entered.

NOTE: Running one of these batch processes on a payment prior to this may corrupt the Payment Plan data.

Highlighting on Accounts with Payment Plans

To indicate that a payment plan is associated with an account, the text for the record is displayed in red in the Summary Detail.

Payment Plan Command Buttons

Save: Click Save to save the payment plan record.
Delete: If no payments have been made on the current payment plan, you can remove it by clicking Delete.
Show Detail:
Click Show Detail to display the payment plan details. This button is enabled after the record is saved at least once.

Payment Plan Fields

Plan Option (On/Off)
Select the On or Off option according to the status of the project. If required, you could set up all the payment plan parameters; then, turn on the plan when all conditions are agreed upon.

Payment Plan Information

Payment Option: The Payment option is displayed if the ACH (PAP) Supported via Payment Plan option is selected in GNA.

  • Manual: Select this option if you are processing a payment on a Payment Plan made in person at the counter.
  • Payment by ACH (PAP): Select this option for pre-authorized Automatic Clearing House (ACH) payments.
  • Postdated Check: Select this option for postdated checks.

Payment Period: Select an option for the payment period from the drop-down list, according to how often payments are to be made:

  • Semi-Annual
  • Every two months
  • Monthly
  • Quarterly
  • Weekly
  • Other: When you select Other, you need to enter a date in the Starting Date and Final Payment Date fields. The Periodic Budget field is disabled. Payments are automatically generated.

Number of Payments: Enter the number of payments required for the plan.
Periodic Budget: Enter the amount of the budget that is agreed upon for the selected period. This field is disabled when the Other option is selected in Payment Period.

Payment Information

Starting Date : Enter the date the payment plan starts. By default, the current date is displayed.
First Payment Date : Enter the date the first payment is due.
Final Payment Date: Enter the date the final payment is due. This field is active when the Other option is selected in Payment Period.
Next Payment Date: The next payment date is automatically displayed when the first payment is made and after each subsequent payment.
Last Payment Date: The last payment date is automatically displayed when the first payment is made and after each subsequent payment.
Last Payment Amount: The last payment amount is displayed when the first payment is made and after each subsequent payment.

Period of Interest/Penalty Information

Not Subject to Delinquent Charges: Select this option to exclude the current record from interest, penalties, and other delinquent charges.
Effective Date: Enter the date that the interest comes into effect.
Ending Date: Enter the last date that interest can be charged.

Payment Additional Information

Resolution Number: Enter a resolution (reference) number for the record.
Reason: Select a reason from the drop-down list. Reasons are user defined. Examples include Credit Memo, Debit Memo, Duplicate Payment, and Overpayment (Table: VT_USR_AR_ REASON).
Authorized By: Enter the name of the person authorizing the payment plan.

Payment Plan Details

When you click the Show Detail icon the Payment Plan Detail window opens.
This window displays information about the total amount due and the details for each pay period within the plan. For example, if the total is $12,000 and the payment period is monthly, 12 payment periods of $1,000 each are listed.
Amount Due: This field displays the total amount owing on the account.
Amount Distributed: This field displays the amount that is spread across the payment periods.
Difference: This field displays the difference between the Amount Due and the Amount Distributed.

Payment Period Information

The information in the grid is automatically calculated based on the amount due and the number of payment periods. The first column displays the number of the payment period. If there are 12 periods, the numbers 1 to 12 are displayed.
Due Date: This field displays the due date for each period. The dates are automatically calculated based on the starting date and the number of periods. Select a date and click the Calendar icon to change a due date if required.
Period Amount: This field displays the amount calculated for each period. This is based on the amount due and the number of periods.

  • You can change the amount due per period by overwriting the amount that is displayed. For example, if there is a small difference between the amount due and the amount distributed, you can add the difference to the first payment or spread it across all payments. If the total amount is uneven, you could add a small amount to the first payment in order to make the other amounts equal. When you change one amount, the others are automatically calculated.

Amount per Period: Enter the amount to be paid for each payment period.

NOTE: If you run the A/R Refund Posting or A/R Reversal Posting batch processes for a payment made through the Payment Plan, start with the last payment entered. Running one of these batch processes on a payment prior to this may corrupt the Payment Plan data.

 

Whats New!

Semi-Annual Payment Plan

The semi-annual payment plan will calculate the payment dates starting from the starting date, i.e. Begin Date, and then taking into account the user specified Number of Payments, calculate the dates of payment every six (6) months. For example, if we were to create a payment plan, specify the Payment Period to Semi-annual, with the number of payments entered as five (5). The plan will break down the amount owed into a Periodic Budget of five (5) payments that are to be made Semi-Annually, i.e. every six (6) months.

Entering a Semi-Annual Payment Plan

For example in the Govern A/R Module, we have an amount due of $1,585.14, the Begin Date is 08/15/2017, when we set the Payment Period to Semi-annual, and the Number of Payments to 5, Govern will determine the following first and final payment dates as:

  • First Payment Date – 2/15/2018
  • Final Payment Date – 2/15/2020

In Govern, locate an account via its AR_ID in the Govern search form. When the record has been located, click the A/R Payment Plan Info tab.

Applying a Semi-Annual Payment Plan

  1. Click New (Ctrl + N), to create a new payment plan.
  2. Select the Payment Period.

When the Number of Payments parameter is entered as 5, the First Payment Date and the Final Payment Date will be indicated. The details for our payment plan have been entered.

  1. Click on Save (Ctrl + S)
  2. Next click on the Show Periods Detail icon to display a modal screen with the scheduled payment dates (Payment Plan Detail).

The full details of the payment schedule are displayed as follows:

Period Due Date Period Amount Amount Paid
1 2/15/2018 $317.03
2 8/15/2018 $317.03
3 2/15/2019 $317.03
4 8/15/2019 $317.03
5 2/15/2020 $317.02

Paying Less than Periodic Budget Amount

The Periodic Budget amount is the system calculated payment amount. This amount is displayed in the Periodic Budget parameter. When a payment is made, after the click to save the payment, the Cash Collection dialog box will appear displaying a log of the transaction. This will include the Account No., the Account Name, and the Minimum to Collect. Situations may arise where the system generated Periodic Budget amount cannot be paid. In such instance a supervisor can give permission to allow a lower amount to be paid.
Configuration of this temporary transferring of permission is performed in the OFD. See the Enable Supervisor Permission Transfer for Minimum Payment in the Security section.

Change Payment with Supervisor Permission

NEW! When the option to “Allow to pay less than minimum to collect” is set in the OFD, an authorized user can enter their password and override the system requirement for a minimum payment. To use the supervisor override, after the prompt of the Cash Collection confirmation screen…

  1. Click OK to dismiss the screen.
  2. On the Payment Data Entry tab, click the padlock icon, i.e. Change the permissions for the form.
  3. At the Govern Login prompt, an authorized person can enter their Username and Password.

After the Supervisor enters the Username and Password, click the Save icon to confirm the permission transfer for the minimum payment.

NOTE: If a payment type is not selected, a Cash Collection dialog box will be displayed indicating that a “Payment Type is Required”; click OK. Choose a payment type, e.g. Cash.
Unless the user option to “Allow to pay less than minimum to collect” is set in the OFD, the minimum payment will be required to be entered.

Security

OpenForms Designer (OFD)

Enable Supervisor Permission Transfer for Minimum Payment

NEW! Security for this feature can be set by Role or by User. Enabling or disabling security options must be performed by a user with administrator level rights.

  1. In the OFD, open the Cash Collection form.
  2. Click the padlock icon to select Security Mode.
  3. Select the Payment Data Entry Tab
  4. Click to select the Custom Control (CCPaymentDataEntry_Control).
  5. On the Security pane on the Left Hand Side (LHS), select security type as Type: Normal (default selection).
  6. Click the required profile.
  7. Beside the Custom Control click the black arrow [V] to select the security option to enable “Allow to pay less than minimum to collect” for the Role or User.

Typically this option is enabled for a Supervisor or user that has administrator rights.

Related Topics

Accounts Receivable Module
Accounts Receivable – What’s New
Accounts Receivable Configuration
A/R Inquiry Payment Plan

 

101-ar-frm-005

 

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