Wiki

Scale Your Enterprise

User Tools

Site Tools

mbstring extension must be loaded in order to run mPDF

versago:payment_configuration_and_reports

This is an old revision of the document!


Introduction (Payments)

This document describes the steps to configure Versago to accept credit card and eCheck payments. It also describes the reports available to provide traceability for Versago Payments processing.

Audience

This document is intended for Versago administrators and end-users that are responsible for supporting the payments process. End-users do not have access to the configuration functions.

Related Pages

The following pages contain additional information that may be helpful with understanding these processes.

Special Terminology

  • “eCheck” means payments based on checking accounting information submitted through a payment gateway such as Authorize.net.

To Begin

This document is intended for Versago administrators. End-users do not have access to this function.

  • Click on the Admin link in the profile section of the Versago home page to access the Administration console.
  • Payments configuration is found in the Settings category to access the function.

Payments Configuration

The Payment configuration function is used to identify the payment gateway, and associated credentials, to be used for processing payments accepted through Versago.

Email will also need to be configured to allow the user to send a confirmation page for their payment transaction.

  • Click on the “Payment Setup” link in the Admin console to begin.

  1. Select the appropriate Payment Gateway from the drop-down list.
    1. As of August 2018, the only available gateway is Authorize.Net. Additional gateways will be provided in future releases.
    2. Your company will need an account with the selected gateway before completing this setup since this is how you will get your credentials.
  2. Enter the Merchant Login provided by your gateway.
  3. Enter the Merchant Password provided by your gateway.
  4. Select the payment method(s) you wish to accept.

    Be sure the checkbox is cleared if you do not want to accept a payment method. In the illustration above, American Express is not accepted and will not be presented as an option for the user.

  5. Click the Demo option during testing only. This option must be cleared for production operations.

Mapping SAP Business One Values

For the payment information in Versago to be processed into SAP Business One, some specific values must be defined. This is done using the “Versago Payment Info Mapping” form.

  1. Click the look-up (funnel) icon in each credit card field to see a list of credit cards defined in your SAP Business One system.
    1. Select the card that matches the label on the field.
    2. The internal SAP code is displayed in the right-hand column.
    3. If you do not accept a particular type of card (Discover in this example), leave the field blank.
  2. Click the look-up icon in the “eCheck GL Account” field to select the appropriate GL account where bank transfers will be posted.
    1. The internal SAP code is displayed in the right-hand column.
  3. Enter the URL to your Bizweaver instance that will process the payments into SAP Business One.
    1. Be sure to include HTTP:// or HTTPS:// as appropriate.
  4. Enter the port used by your Bizweaver instance.
  5. Enter the Bizweaver workflow ID that will process the payments into SAP Business One.

Notes

  • Credit cards must be defined in your SAP Business One system before item 1 can be defined.
  • The internal SAP codes are displayed for support purposes only. The user does not need to be concerned with them during the configuration process.
  • Your system administrator should be able to provide you with the information needed for items 3 and 4.
  • The workflow to process payments from Versago will need to be imported (or created) in Bizweaver before item 5 can be set. This value will be different for each installation.

Once any of the codes have been defined and saved, the associated report, “Versago Payment Info Mapping” must be used to review and update values. The maintenance form will not allow more than one record to be created.

Reports Overview

Two main reports are provided for users to review payment transactions and resolve issues. These reports are Versago Payments Recap and Payments Transaction Log. The standard location for these reports is in the ‘Payments Admin” menu category.

Versago Payments Recap Report

Detailed information about successful payment transactions can be viewed using the “Versago Payments Recap” report. This report displays details about each transaction, including invoices paid, information sent to the processing gateway, and the response from the gateway.

This report utilizes a SQL View as the data source. The View must be created manually in the database. Code to create the View is provided below.

Create the view in the VersagoData database (or whatever database name you may be using to capture Versago form data).

CREATE VIEW [dbo].[vgo_vw_PaymentTransactions] AS
SELECT DISTINCT
t0.vgo_transid,
(SELECT SUM(x0.BalDue) FROM Versago_Payments x0 WHERE x0.vgo_transid = t0.vgo_transid GROUP BY x0.vgo_transid) AS [TtlAmtPaid],
CASE t0.vgo_paymenttype
WHEN 1 THEN 'Credit Card'
WHEN 2 THEN 'eCheck'
END AS [TransType],
CAST(t0.vgo_paymentdate AS DATE) AS [vgo_PaymentDate],
(SELECT COUNT(*) FROM Versago_Payments x0 WHERE x0.vgo_transid = t0.vgo_transid) AS [DocCount],
t0.vgo_PostingStatus, t0.vgo_PostingDate, t0.vgo_PostingId
FROM Versago_Payments t0

Use the Payments Transaction Log report for information about unsuccessful transactions.

Versago Payments Recap – Main Report

  1. Expand the row to see a list of invoices paid.
  2. The “SAP Posting Status” indicates if the transaction has been posted into SAP Business One.
    1. “0” indicates that the transaction has not been processed.
    2. “1” indicates that the transaction has been posted successfully.
    3. “9’ indicates that the transaction posting failed.
      1. Click on a “9” to see the reason the SAP posting failed.

  • Click the Transaction ID link to view details of the transaction.

Payments Log Sub-report

  1. Click on the CC Request or eCheck Request link as appropriate to view the information that was sent to the gateway for processing.

Payments Log Request (CC and eCheck) Sub-report

Payments Response (CC and eCheck) Sub-report

  • Click on the Response link to view the information that was sent to back from the gateway.

Payments Transaction Log Report

The Payments Transaction Log report is like the Payments Processing Recap report, except that it shows both successful and unsuccessful transactions.

Note that the “Transaction ID” for unsuccessful transactions begins with “E” followed by the log record ID, and the date & time of the transaction.

  1. Click on the “CC Request” or “eCheck Request” link as appropriate to view the information that was sent to the gateway for processing.
  2. Click on the “Response” link to view the information that was sent to back from the gateway.

In general, the “Response” information will be the most helpful for troubleshooting unsuccessful transactions since it shows the reason a transaction was rejected.

versago/payment_configuration_and_reports.1559672926.txt.gz · Last modified: 2019/06/04 14:28 by runger