Sage CRM – Tips, Tricks and Components
Greytrix is one of the oldest Sage Development Partner of two decades for Sage CRM and has been awarded "Sage Development Partner of the Year" three times in the past years. Greytrix has been working on customization and configuration of products in Sage CRM since decades and have accumulated hundreds of man years of experience. In these blogs, Greytrix will endeavour to share its knowledge and expertise and save upto 90% of project cost for Sage CRM users by presenting a list of useful small components, tools and add-ons for Sage CRM! Contact us at sage@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home

Error with Account Manager field while uploading Company Data

By greysagecrm | December 7, 2015
0 Comment

As we all know that using Data Upload feature of Sage CRM we can update our system with required information and then the system can be handed over to user to make use of functionality. The Data Upload feature comes with default options to upload Company, Contacts and Leads.

New Stuff: IIS Configuration for Sage CRM

Recently, while working on company data upload for one of the customer we encountered with an error which says “Invalid Integer Value” for Account Manager Field. See below screenshot for your reference.

ErrorPage

On checking the upload sheet I found that Account Manager Field was containing full name of the user i.e. System Administrator and system was considering it as integer value. So, to rectify this we entered the User Logon name instead full name and uploaded the sheet once again.

Once the upload sheet is rectified, user has to map the Account Manager Field with User Logon Id from data upload mapping screen as shown below and data will be uploaded successfully.
DataFile
Also Read:
1. Sage CRM Mapping component to upload data from Excel
2. Troubleshooting Sage CRM’s Customized Data Upload Routine Issue
3. Data Upload using Deduplication
4. Error in Uploading companies using CSV file with Date & Integer columns
5. Create log file using .net API

Related Posts

  • ERP data in Company Entity
  • Can the Account Manager at the Person level be updated when the Account Manager is changed at the Company Level?
  • Time-Out Error while Importing Bulk Data
Category: Customer Data Upload Sage CRM Uncategorized Tags: account manager field, company data upload, comp_primaryuserid, Data Upload, integer value
Post navigation
← IIS Configuration for Sage CRM Auto Sync Data through Upload Routine in Sage CRM →

Greytrix Website and Blogs

  • Greytrix
  • GUMU™ Cloud
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage 300 – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Business Cloud – Tips, Tricks and Components
sage crm integration

Recent Posts

  • Integrate Sage CRM with Microsoft Outlook using OAuth 2.0
  • Bulk Promote in GUMU™ for Sage CRM – Sage 100 Integration.
  • Open Multiple Read-Only Tabs In Sage CRM 2023R2
  • Sage CRM and Sage 100 Configuration for v2023 R1
  • Suppress Stages with Zero Records in Pipeline in Sage CRM 2023 R2

Archives

Awards

Premier Partner of the Year Premier Partner of the Year
Platinum Partner of the Year Platinum Partner of the Year
The CEO Story The CEO Story
Gold Partner pf the Year Gold Partner pf the Year
Top Excellence Distributor Top Excellence Distributor
Copyright 2023
Sage CRM – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress