Refund Credits

The Refund Credits task refunds overpayments and adjustment credits for eligible billing accounts.

There are two types of refund credits runs. If the run type is “Automatically refund Accounts,” the refunds are created automatically as part of the run. If the run type is “Show refund eligible Accounts in My Infor,” the run will mark accounts as eligible for refund. They can then be processed manually in My Infor.

  1. Load accounts that have credits (ACCOUNT.CREDFLAG = Y), have final bills (ACCOUNT.FINALBILLFLAG = Y), and match task parameters.
  2. If run type is automatic, perform these steps for each account:
    1. Query the ACCTTRAN and ADJUSTMENT tables for credit adjustments, and sum the available amounts of all transactions.
    2. Query the ACCTTRAN and PAYMENT tables for overpayments, and sum the available amounts of all transactions.
    3. Add adjustment and overpayment credit amounts.
    4. If credit sum greater than minimum defined in task parameters, create refund, refund payment, refund items, account transaction, and account activity record.
    5. Depending on approval levels, the refund may need approval.
  3. If run type is “show in My Infor,” set ACCOUNT.ELIGIBLEFORREFUNDFLAG = Y.

Setup

This table describes the Infor Operations and Regulations setup forms that are used to configure this task:

Setup form Comments
Line Item Setup To refund credits you need a refund line item setup.
Bill Type To refund credits you need a “default for refund” bill type (select the Default for Refund check box) with an associated refund line item.

This table lists the database tables that store setup information for this task:

Table Comments
BILLING.BILLTYPE Stores bill type records.
BILLING.LINEITEMSETUP Stores line item setup records.

Invocation

This table describes each parameter for this task:

Form Console Description
Account Area AccountArea (string) Account area used as a selection parameter.
Account Class AccountClass (string) Account class used as a selection parameter.
Billing Cycle BillingCycle (string) Billing cycle used as a selection parameter.
Group Group (string) Account group used as a selection parameter.
Run Type RefundCreditRunType (int) Type of Refund Credits run. Can be Show refund eligible Accounts in My Infor (enter 83 in the console) or Automatically refund Accounts (enter 65 in the console).
Subgroup SubGroup (string) Account subgroup used as a selection parameter.
With Minimum Credits CreditExceeding (double) Minimum credit sum an account must have to qualify for a refund. This parameter is only used for “Automatically refund Accounts” runs.

Monitoring

If the Refund Credits run is successful, you should see these messages in the Billing Batch Process log:

  • Loading eligible refund account loaded successfully.
  • Total Accounts Eligible for refund : [#]

In the database, the PROCESSINGFLAG column in BILLING.REFUNDCREDITSRUN is set to Y at the start of a run, and set to N when the run is finished.

Common errors

This table lists some common errors that this task may return:

Error message Comments
LineItemSetup not associated with Bill Type Check your bill type setups. Ensure that there is a bill type with the Default for Refund check box selected, and an associated refund line item.
Account did not receive refund because credit amount of [credit sum] is less than [minimum credit] amount. The account’s credit sum is less than the minimum credit amount for the run.

Data output

This table lists the database tables in which this task adds or updates records:

Table Comments
BILLING.ACCOUNT For a “Show refund eligible Accounts in My Infor” run, each eligible account will have its ELIGIBLEFORREFUNDFLAG column set to Y.
BILLING.ACCTTRAN Stores any account transactions created in the run.
BILLING.DEPTRAN Stores any deposit transaction created in the run.
BILLING.REFUND Stores any refunds created in the run.
BILLING.REFUNDAPPROVAL Stores any refund approvals created in the run.
BILLING.REFUNDCREDITSRUN Stores information on the Refund Credits run, including the run key, the parameters used, and whether the run is currently processing.
BILLING.REFUNDITEM Stores any refund items created in the run.
BILLING.REFUNDPAYMENT Stores any refund payments created in the run.

This table lists the Infor Operations and Regulations forms that you can use to review the results of this task:

Form Comments
Manage Account page Used to review an account’s transaction history.
Lookup Transactions Standard Infor Operations and Regulations lookup used to search for transactions.
Transaction InfoViewer Shows details for a selected transaction.
Lookup Deposit Transactions Standard Infor Operations and Regulations lookup used to search for deposit transactions.
Deposit Transaction InfoViewer Shows details for a selected deposit transaction.