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.

Load accounts that have credits (ACCOUNT.CREDFLAG = Y), have final bills (ACCOUNT.FINALBILLFLAG = Y), and match task parameters.
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.
If run type is “show in My Infor,” set ACCOUNT.ELIGIBLEFORREFUNDFLAG = Y.

Setup

This table describes the Infor Public Sector 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 Public Sector 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 Public Sector lookup used to search for transactions.
Transaction InfoViewer	Shows details for a selected transaction.
Lookup Deposit Transactions	Standard Infor Public Sector lookup used to search for deposit transactions.
Deposit Transaction InfoViewer	Shows details for a selected deposit transaction.