Articles
EFT Processing v5 SedonaOffice - Post Button Greyed Out
If you receive a request for the version 5 EFT processor that the Post button is greyed out, it most likely means that the batch has a transaction that has no response code.
Sort the batch by the Response field to find the transaction a...
Adding a new Merchant ID in Sedona Office
When a user wants to add a new Merchant ID in SedonaOffice, this is a potentially complex task. The basic steps to add the Merchant ID are detailed below, but some pitfalls can arise. The largest of these is that payment methods are tokenized in ou...
SedonaOffice EFT testing with SedonaCloud
Find the file with information on SedonaOffice EFT testing with SedonaCloud here. .
This shows screenshots and SedonaCloud endpoints to use to test if the SedonaOffice EFT process is configured correctly to allow the SedonaCloud payment ...
SedonaOffice - SQL Script - 6.2.0.6 - ACH error for CC payments - Script for REV 4
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SEFT_ACH_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[SEFT_ACH_Add]
GO
Create PROCEDURE [dbo].[SEFT_ACH_Add]
@customer_number varchar(15),
@description var...
Credit Card and Bank Accounts for SedonaOffice 6.0 Testing
Below are test accounts that can be used when testing payment and payment types. These are not real payment methods, they are fake payment methods provided by Forte.
Overview
These accounts listed below are only to be used...
Debugging EFT Processing with Json files
When debugging the Forte EFT transaction settlement process, it is not always possible (or convenient) to get the desired responses from Forte. Therefore, code has been added to the PaymentProcessing project to allow reading responses from Json file...
EFT Processing Export to Excel in SedonaOffice
This process may need to be used if you need to create a report that displays the transactions listed in a specific status of EFT Transactions.
Description of Issue:
I need to create a report that displays all of the rejected EFT transacti...
EFT Setup for Non-Forte Customers in SedonaOffice
The information entered in the EFT Setup screen determines how a company processes Electronic Fund Transfers. Companies that don’t use Forte, and therefore do not process EFTs through SedonaOffice, can use the following configuration in the EFT set...
EFT Transactions not Submitting Automatically in SedonaOffice
EFT Transactions not Submitting Automatically
The Sedona EFT Processor can be configured to automatically submit transactions at predetermined times. Sometimes, you receive cases that transactions are not submitting on their own. There are two ...
Enable Funding Batches does not display on my Merchant ID
When you add a new Merchant ID to the system, if there are no branches assigned to that Merchant ID yet, the Enable Funding Batches selectable does not display. Once you have a branch using that MID, go back to EFT Setup and you should be able to s...
Getting U84 on transactions that reject
Users will occasionally get rejected transactions with U84 as the response code. When you look at the transactions, see how similar the transactions appear.
In this instance, the transactions are identical. This is not a setting ...
Getting “PCI Compliance needs to be run” message on log in
There are a few reasons the PCI Compliance message might show back up once the database has been made compliant. The primary one is that they have added a new Merchant ID. If they add a new Merchant ID, then the new line will not be added with the ...
How to Void an ACH/EFT Payment in SedonaOffice
When a customer’s scheduled ACH/EFT payment needs to be Voided, there are two options available: using the EFT Processing Module or through the Customer Account.
EFT Processing
Select EFT Processing under the Accounts Receivable Module...
How to Correct Error: Sequence Contains No Matching Element When Adding a Payment Method
Description of Issue:
When in Client Management attempting to add a new credit card or bank to a customer, selecting Manage Payment Options returns an error.
Error: Sequence contains no matching element....
How to get EFT Payment Processing log data
From database tables:
There are two database tables that can contain useful information for diagnosing EFT Processing issues: SEFT_Service_Log and SY_Edit_Log.
SEFT_Service_Log:
This table is the primary logging table used by EFT ...
Manually Adding Missing EFT Deposit Checks in SedonaOffice
How to Add a Manual Deposit when EFT/ACH Transactions are missing in Payment Processing.
If the user is on the latest version of SedonaOffice make sure the missing deposit check issue is documented and sent to development to track and resolve t...
Manually Settling EFT Transactions in SedonaOffice
How To Settle EFT/ACH Transactions
On occasion in a Batch in Payment Processing there will be an EFT/ACH Transaction(s) that cannot be Deposited because it is still showing “Approved” but is showing “Settled” In DEX and has been deposited into ...
How to Refund Credit Card on Unapplied Cash
Overview
Credit card refunds can be done from a credit memo ONLY . It is not possible to refund unapplied cash back to a credit card . The steps below walk through creating and applying the refund using a credit memo. ...
Remove Pending (P) Flag from Invoices in SedonaOffice
Remove Pending (P) Flag from Invoices in SedonaOffice
When there is no pending EFT payment on an invoice, but the system has not updated the flag, this script can be run to remove the pending flag from the invoice.
/* Remove the EFT Pendin...
How to Set up the EFT Returned Payment Invoice Item for Previously Funded Transactions (formerly Z-Transaction)
When an EFT Payment is returned as Previously Funded a negative payment batch is created to reverse the payment and unapply the payment from the invoices to which was originally applied. The system will also create an invoice for the amount of the ...
Invalid Authentication Error Adding Payment Methods in SedonaOffice
When users access the Developer section of DEX, they can generate new API credentials. They can do this when they have a new MID to add to Sedona. However, any already stored MID API credentials that are on the same Organization ID will also ...
SedonaOffice - Resubmitting EFT Transactions Rejected with ‘Task was Canceled’
Resubmitting EFT Transactions Rejected with ‘Task was Canceled’
If scheduled EFT payments were Rejected and have a Rejected Message: “A Task was Canceled” you can manually resubmit the payments.
EFT Processing.
Under the EFT Processin...
Multiple transactions for customers not showing in Sedona Office
Despite our best efforts, users will sometimes clone their database and stand it up. If they are in version 6+, they can have auto-submit enabled for their Ready transactions, leading to them double billing their customers. This is a messy situatio...
SedonaOffice Rollback from 6.2.0.X to 6.1.0.61
Overview
We have found out that Forte does not provide funding data for transactions processed by a 3rd party (Gateway merchants in Forte terms) back to SedonaOffice. We build our new deposit process with the understand that we would always get...
Orphaned Transactions in SedonaOffice
Sometimes, the communication between SedonaOffice and Forte hiccups during a transaction’s upload. These transactions will appear in the Orphaned status tab of the SedonaOffice version 6 EFT Processor. Orphaned transactions are not frequent, but the...
Transactions not Settling in SedonaOffice
The Sedona EFT Processor in version 6 should automatically settle transaction at the 11:30pm time listed in EFT Setup. However, when the settlement process runs, it needs to connect to Forte to get the updated transaction information. If the Sedona ...
Transferring Forte Tokens from One MID to Another
Tokens are random, alpha-numeric strings that represent stored, encrypted data. Tokenization is a common practice in the payment industry to protect sensitive data. Tokens are assigned to payment methods by Forte and are stored i...
U04 ACH Limit Exceeded
There is a limit to the number of transactions Forte will run for ACH transactions in a month. If a user receives the below error message , they must contact Forte for resolution.
...
Updating the Merchant ID of a Branch
If you are changing from one Merchant ID to another, or the user has added a new Merchant ID, that will not automatically take effect. The Merchant ID is configured on the Branch table of Sedona Setup. To update the Merchant ID, go to Sedona Setup....
How to Start or Restart Sedona EFT Services
This service automatically sends transactions done in EFT processing to Forte. If clicking on the Ready tab in EFT Processing shows transactions from the previous day, this service may need to be either started or restarted to push those transac...
Version 5.7.99 Stores Encrypted CC and Bank information
If the user is on Sedona Office version 5.7.0.99, their encrypted cc and bank information is stored in the AR_Customer_CC/AR_Customer_Bank tables. You can connect and run these scripts to see this information:
Select * from AR_Customer_C...
“Sedona Office not configured for Live Processing” Error Message
The above error message can occur if the EFT Setup screen is not configured correctly.
When you configure the EFT Setup screen, if you turn on the “Automatically Submit Transactions,” the system will expect you to...
“utc_time is expired” Error Processing EFT in SedonaOffice
Internal only.
Description of Issue:
In this scenario, the user is experiencing an issue where when they attempt to add a new Payment Method to a customer, they encounter an error, see below:
The error: “utc_time is expired” was...
How to Pull EFT Service Logs
When needing to pull service logs for EFT issues, below are the steps to follow.
Overview
The steps below will be done on the Server computer
Steps:
1 . Login to the server (you may need administrative p...
How to Export certain Dates from Rejected EFT Tab
Overview
There are times when more than normal rejected EFT transactions happen after processing invoices. These steps will show how to export that list for easier verification. The steps cover for SedonaOffice version 6.2.x.
...
Payments Being Rejected as Duplicates
A customer may have payments getting rejected because they seem like duplicates. Customer may believe Sedona is causing this to happen, below is why it happens and how to resolve.
A customer has a setting set up on their Forte account called ...
Credit Card Types in SedonaOffice
A company has the option to authorize certain Credit Cards from being used for payment processing. Those credit card types must be set up in the following location for the payments to go through and get authorized.
Sedona Setup > EFT Credit Car...
New Version of PCI Compliance Utility
Due to some issues with its function, the PCI Compliance Utility was updated. The updated version is available in Sedona Office version 6.2.0.14. It looks like the below:
If you do not see this version when you start the util...
Where is the ACH Upload File in Version 5 of SedonaOffice?
In version 5, there is a copy of the uploaded transactions kept on the machine that completed the EFT upload. This file is used to check against the Download option in EFT processing. The file can be found in this location:
'C drive - us...
EFT Funding for Gateway Processors
When a customer is setup to use CSG Forte as a Gateway, they will not receive funding information from Forte for the transactions that are funded by a third party processor. This means that if you enable Funding Batches, the setting will not work fo...
Payment Method Tokenizing Procedure for SedonaOffice
First, the application files will be updated from version 5.7 to version 6+. This will be coordinated with the Support representative, IT, and the customer.
On the EFT Setup screen, enable Advanced Providers.
Once Advanced Provider...
How to Update Orphaned Transactions
Orphaned transactions should automatically update in a few business days, but if several days go by with no change, use the process below to update the transactions to the proper status.
1. If there is no trace number, that means the forte did...
Forte Common Data Errors
There are a handful of data issues that can cause errors or stop payments from being processed.
Customer Token was imported into the ACH_Direct_Token - The payment token from Forte is the proper field.
PCI non – compliant. – In th...
Forte Data Mapping
When interacting with data from Forte, several of their fields map directly to our fields in Sedona Office. Below is a list of Forte Fields and Sedona’s corresponding Field name(s)
Forte Merchant ID = Sedona Merchant_ID
Forte Loca...
How to Set up the EFT Returned Payment Invoice Item for Previously Funded Transactions
When an EFT Payment is returned as Previously Funded a negative payment batch is created to reverse the payment and unapply the payment from the invoices to which was originally applied. The system will also create an invoice for the amount of the p...
Version 6 of SedonaOffice can Auto Create Invoices for Previously Funded Transactions.
In Payment Processing – transactions may be seen that show: Posting Z Transactions
These types of transactions show anything that has been returned by Forte for non-payment.
The system will attempt to remove the payment from the as...
Request reversal increase amount authorization
The following steps will allow you to submit a request to Forte, to increase the reversal amount authorization. Example – A customer wants to reverse the payments for 10 accounts that total $5,000. The Forte account is only authorized to reverse $1,...
Keep Credit Card Expiration Dates Current
Forte's Account Updater service enables merchants to prevent service interruptions to their recurring transactions by automatically updating cardholder account information for Visa, MasterCard, or Discover credit cards that may have been replaced or...
Request payment reversals via Forte
The following steps show how to submit a request to Forte to have payments reversed.
This link will take you to the correct form when requesting payment reversals.
https://hardwareorderform.formstack.com/forms/mass_reversal_request ...
How to Translate Forte Response Codes
When a customer processes customer payments and the payment(s) gets rejected, the transaction will have a Response code attached to the record. The Response code explains the reason for the rejection. There are two places where those codes can be ...
EFT Errors – Lock Errors and Orphans
Internal -
There is currently an issue in the eft processing service that is erroneously locking payment batches and not releasing the lock. Development is still looking into the source of the issue. Until it is fixed we expect occurrences of t...
Scripts for Correcting Orphans and Missing Payments
Internal -
As of SO versions 6.2.17 and higher the eft service should auto-correct orphans and missing check issues. If you do need to correct orphans or missing checks, please find attached scripts written by Scott Bourdeau. The three differe...
System Auto Creates Negative Checks for Previously Funded Transactions
Previously funded transactions are transactions that were approved, and our users got the money, but then the money was taken back and removed from our customers bank. There are many reasons this can happen, but it is usually because the end user w...
How to Start the SedonaEFT Service when EFT Processing Not Working
SeodnaOffice has a service that runs to send and receive transactions from Forte. When either the Ready tab seems not to be sending or the Settled Tab is not showing receiving settled transactions in EFT Processing, this service may be the reason w...
Submit Transaction Error
When submitting transactions to Forte, the below error can occur. At its core, this is the system rendering a 504 error. 504 is a networking error and indicates that the connection to Forte is timing out. This could be the result of an ...
API Access ID Error
This message is exclusively encountered around token migrations from Forte. This message indicates one of two things. First, that there’s been an issue with where the token is located. It could mean that the migration just went through, bu...
Transferring EFT Info from AB to SO (Internal)
The following was pulled from a communication regarding a customer moving from AB to SO and had questions about how to transfer their payment methods and Forte info. Future customers making the same switch would need to follow similar steps.
...
How To Modify the Credit Card Payment Message on Invoices
Issue:
How can the Credit Card Payment Message on Invoices get modified?
Solution:
To update the Credit Card Payment message on Invoices, go to:
SedonaSetup > EFT Setup
In EFT Setup, there is a Posting section in the AC...
Cannot Find Customer Token (Internal)
Primary Flags in Billing Screen
Issue:
We are receiving a message that the customer token does not exist when processing a payment.
Resolution:
The issue can occur if the customer's token on file is not current.
...
Error when submitting manual EFT transactions but auto billed transactions succeed
If auto-billed EFT transactions are successfully processed, but the customer receives an error when submitting manual EFT transactions for an account, it is most likely due to the incorrect Merchant ID associated with the customer's branch in the se...