Cannot Insert The Value Null Into Column CDescription Table EVO_LIVE.DBO._ETBLEFTSFILELAYOUT – AP EFTS EXPORT ERROR

Article, Knowledgebase

Article credit: Sage 

Introduction

The following error message may be displayed when running the Accounts Payable | Transactions | EFTS Export:

Solution

First, consider the background of this query:

  • This issue was experienced by a client using the Australian installed edition of Evolution.
  • They properly installed the Australian edition of Evolution but were getting the above error on EFTS Exports.
  • The client discovered that the Accounts Payable | Maintenance | Defaults | EFTS screen only presented the South African EFT bank list (as also found on the Common | Maintenance |EFTS File Layout grid).

2

To resolve this query, the following steps should be applied:

  1. Close Evolution on the local PC.
  2. Open the local Evolution installation folder (e.g. C:\Program Files (x86)\Sage Evolution).
  3. Open the Evolution.ini file (use Notepad if it needs an application to open it).
  4. Change the cCode value from 0 to 1 and save the changes on the Evolution.ini file. 3
  5. When logging back into the company, the original Australian EFTS bank layouts should be back. After selecting the relevant Australian EFTS layout, the EFTS Export run should be completed without further issues.
  6. Note that if using the South African edition of Evolution results in the above error, ensure the value in step 4 above = 0. For using the New Zealand edition of Evolution the value = 2.
  7. Repeat the same steps on all the workstations from where EFTS export runs need to be executed.

Disclaimer: These articles refer to possible solutions and a platform to share information. Each article describes a method that solved a query (knowledge gathered from previous sites) and how Sage Evolution should operate. These articles make reference to a specific Sage Evolution version, however the thought process can be generalised. Please note the information contained in these articles should be treated as guidelines and adapted to accommodate differences in business processes and IT environments. Articles may not be applicable to all environments. If this article did not resolve your query please contact Kiteview Technologies Support Department on:  (+27) 010 005 6678.

About Us
Kiteview Technologies (Pty) Ltd was founded in May 2010 to provide the Sage Evolution Business Management solution to the SME market. The management team of Kiteview have combined +30 years of experience in the delivery of small to mid-market Financial & Business Management solutions. This experience, combined with a sound project implementation methodology has helped in Kiteview’s growth, becoming a Platinum status partner for SAGE Pastel within just 1 year.

Contact Us

For An Obligation Free Quote

View Our Client Testimonials

View Our Knowledge Base

Share:

Subscribe

Sage Referral Partner Sage VIP

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!