ePay Review

This Help File Page was last Modified on 03/18/2019

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module > Receivable Reports - An Overview >

ePay Review

This Help File Page was last Modified on 03/18/2019

The ePay Review dialog's data grid provides a selectable listing with All of the Data Elements of the InnoEPay Payment Gateway payment transaction records available as needed.

These include Credit Card and Check Payments (which are stored as Receipts records), the Payment Status of each, and much more related information (see the "Understanding the Status and Response columns" discussion below for more information).

This ePay Review data may be Printed as a report, and/or Exported (or Emailed) as an Excel® style Spreadsheet (or as a comma delimited file, or even a text file), and in some cases Modified.

 

There are two ways to access the Deferred Revenue dialog:

a)From the Backstage Menu System Select Reports and Choose Receivable Reports, or

b)From the Quick Access Menu, Select Reports and Choose Receivable Reports.

Then, Select the ePay Review option.

 

HelpFiles-ePayReviewDialog

ePay Review dialog

 

Setting Up the ePay Review dialog's data grid Options:

Select Date field - Using the Drop-Down Selection List provided, Choose the Date Field that will compared to the specified Date Range (see below).

 

HelpFilesEPayReviewSelectDateField&DateRange

Select Date field and Start/End Date Range fields

 

Set the Date Range of the Data to be displayed:

Start - By default, this will be 7 days ago, but this Date may be changed as needed.

a)Click on the Start Date field and type the desired Date using a MM/DD/YYYY format; or

b)Use the Drop-Down Calendar/Date Entry field provided to Choose the desired Date

End - By default it will be Today, but this Date may be changed as needed.

a)Click on the End Date field and type the desired Date using a MM/DD/YYYY format; or

b)Use the Drop-Down Calendar/Date Entry field provided to Choose the desired Date

 

Retrieve Data - Once the Date Range (and optionally the Column selection as explained below) has been set, Click the Retrieve Data Icon to populate the ePay Review dialog's data grid.

 

Print - Once the data has been formatted, filtered, sorted and configured as needed, a copy of this ePay Review data grid data may be printed (see Understanding the Print Preview Dialog chapter).

 

Export -  Once the data has been formatted, filtered, sorted and configured as needed, Click the Export Icon to make an Excel spreadsheet, Text or comma delimited copy of this ePay Review data grid data.

 

EMail - Once the data has been formatted, filtered, sorted and configured as needed, Click the EMail Icon to send this data as a PDF attachment to an Email address of your choosing.

 

Look Up - Accessing the Receipt and/or the Subscriber Form for any listed InnoEPay payment transaction record.

 

HelpFiles-ePayReviewDialog-LookUp

 

Right-Click on any InnoEPay record to display its Radial Right-Click Menu

Select the Subscriber, Invoice, or Receipt option to open and view the associated Subscriber, Invoice or Receipt Form, and/or

Select the Modify Due Date option (if that Date has not passed) or the Delete option (if not yet funded).

 

Columns - Select which columns of data are to be displayed:

 

HelpFiles-ePayReviewDialog-Columns

 

Click the asterisk (¬) at the left of the data grid's Header row (see the mouse pointer in the illustration above) to display a list of all of the column names - and associated data - which may be displayed.

By default, all Column Names will be Checked.

Remove the Check mark (Click on the Check to remove it) to hide that column of data from the data grid.

 

Sorting the List - Setting the Order in which the ePay Review dialog's data grid is Listed within the ePay Review Form:

The default sorted order of the ePay Review dialog's List is based on the PayBatchId (Payment's Batch ID Number) - which is ordered from lowest to highest (1 - 9, a-z, then A - Z).

Thereafter, the column that determines the sorted order of the List may be easily changed, whenever needed.

 

Filtering the List - This ePay Review dialog's data grid may also be filtered, as needed to define/identify the data that is actually needed.

See the Grids & Lists and the Filter Builder Dialog chapters for more information  about formatting and printing (and exporting) the ePay Review dialog's data grid

 

Understanding the Status and Response columns:

Invoices may be paid manually using the E-Payments option on the Subscribers Form and/or the Invoice Form; and/or automatically by using the Post Auto Draft process.

When using the E-Payments option on the Subscribers Form or the E-Pay option on the Invoice Form, InnoEPay is chosen for the Drop-Down Selection List in the Select Gateway field.

When using the Post Auto Draft process, InnoEPay is chosen for the Drop-Down Selection List in the File Type field.

When InnoEPay is chosen, there are no Other Options entries required in the Post Auto Draft Form.

 

Once an Invoice is "Paid" using the InnoEPay Payment Gateway, this will be the basic InnoEPay work-flow/process for a Check (or Credit Card) payment's submission, through the final result:

1.Pending – after a Check (or Credit Card) payment transaction record is submitted to the Payment Gateway it will reflect a Pending Status until the final submission to the check processor

2.Submitted – once the Check (or Credit Card) payment transaction record has been submitted to the Processor, the Status within the InnoEPay Payment Gateway (and therefore this ePay Review dialog) will be reflected as Submitted until the Transaction is funded (or the payment processor reports/provides information as to why the payment transaction record will not be funding such as NSF/Account Closed).

3.Final Results: (primarily, this will be reported as Settled or Returned)

a.Funded/Settled – the Check (or Credit Card) payment transaction record has been successfully completed

b.Returned – the Check (or Credit Card) payment transaction record was not Funded/Settled so your Company will be provided the reason why - such as Insufficient Funds or Account Closed (see the list of Returned Codes chart below)

 

The Status code of each payment transaction record will change as that transaction goes through the process to ultimately be Funded (for Checks) and Settled (for Credit Cards), or Rejected for some reason.

 

Transaction Code

Label

Meaning

N

Queued

New Transaction (hasn't been processed yet)

P

Pending

For credit cards, batch hasn't closed yet. For checks, hasn't been sent to Bank yet.

B

Submitted

For checks, sent to bank and void no longer available.

F

Funded

Funded (for checks, the date that the money left the account.

S

Settled

For credit cards batch has been closed and transaction has settled. For checks, the transaction has cleared.

E

Error

Transaction encountered a post processing error. Not common.

V

Voided

Check transaction that has been voided

R

Returned

Check transaction that has been returned by the bank (ie for insufficient funds)

T

Timed out

Check transaction, no update has been received from the processor in 5 days.

M

Manager Approval Req.

Transaction has been put on hold pending manager approval. (checks)

Transaction Status Codes

 

If a Check transaction is not funded, your Company will be provided with a Response (Reason code) for why it was Returned [e.g., Insufficient Funds ("R01"), Account Closed ("R02")]

 

Response

Reason

Returned

R01: Insufficient Funds

Returned

R02: Account Closed

Returned

R03: No Account/Unable to Locate Account

Returned

R04: Invalid Account Number

Returned

R06: Returned per Originating Depository Financial Institution's Request

Returned

R07: Authorization Revoked by Customer

Returned

R08: Payment Stopped

Returned

R10: Customer Advises not Authorized

Returned

R16: Account Frozen

Returned Codes

 

Certain Pending InnoEPay payment transaction records may be modified and/or deleted:

Modifying data in the Due Date column - The Due Dates on payment transaction records with a Pending ("P") Status may, from time to time, need to be modified.  To do so:

a)Set a Filter for Status = P  

b)If there are many payment transaction records in the ePay Review dialog's data grid, you may also Sort the data by Due Date column to make finding the necessary payment transaction easier.

c)Locate and Modify the Due Date, as required.

 

All Invoices associated with this Selected payment transaction record will have their Due Dates changed.

 

Deleting a payment transaction record with a Pending ("P") Status may be deleted:

From time to time, a payment transaction record may have to be deleted.  To do so:

a)Locate that payment transaction record  

b)Ensure that it has a Pending ("P") Status

c)Press the Delete key.

 

The Invoice record(s) associated with this payment transaction record will be unallocated, and the associated Receipt record removed.