Troubleshoot error – ‘Unable to Import Customer. Either BOF or EOF is True’

By | March 17, 2021

GUMU™ for Sage CRM – Sage 100 integration is a real-time bi-directional link where we synchronize all the customer data from Sage ERP’s to Sage CRM and vice versa.Thus users can have a 360 degree view of customer data within both the systems.

Today in this blog, we will discuss about troubleshooting tips for resolving an error message “Unable to Import Customer. Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record” as shown below which occur on Import Customer routine.

Currency

The above issue is related to data specific and normally occurs due to below process

1. If user create a customer/Import Customer using 3rd Party Addon or VI job in Sage 100 under Customer Maintenance screen by entering improper data and then tries to Import Customer in CRM using Import Customer Routine then it will show the error message as “Unable to Import Customer. Either BOF or EOF is True, or the current record has been deleted

2. You can observe the failed customers list in the GUMU logs by navigating to below mentioned path C:\Windows\SysWOW64\inetsrv\GUMU\GUMUImport.log

Currency

3. After knowing the failed customer’s customer number check the data against them in Sage 100 if it proper or not.

4. For Example, as shown in below screenshot the salesperson code against the customer was incorrect due to which an error message occur in Sage CRM.

Currency

5. Once the data gets properly updated in Sage 100 against the failed customers then again try to Import customers in Sage CRM and check if issue resolve.

For any other related queries you can always contact us at sage@greytrix.com.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service SignatureSage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.