CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Using CodePartners’s Mass Update Tool to Update Records

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

by Joe Zhou

At BTerrell Group, we have a few experienced consultants who specialize in Intacct implementations.  Migrating client’s data from another ERP system to Intacct is a big part of the implementation process. However, it can be cumbersome and error prone. Over time our CodePartners division developed some useful tools that help our consultants overcome these obstacles in their implementation tasks and make their life easier. Mass Update is one of the tools I want to show you in this article.

Currently there are only three options when it comes to updating records on a large scale. All three options are either time consuming or unpractical for a consultant. You will agree with me on how easy it is to use CodePartners’s tool to accomplish the mass update compared to these three options.

1.       Find all the records in Intacct and update them individually.

2.       Delete all the records and reload them again.

3.       Write your own Intacct update API statement and execute it using Intacct Chrome test tool. This requires Intacct API knowledge.

 

CodePartners mass update

Figure 1. Existing available tools

First of all, the tool provides a powerful query builder to allow you to find all the records you want to update. In the example below, I query against Employee object and retrieve all the employees who started later than 07/01/2009. As you can see from Figure 2, all employees that meet the criteria have the same title “Developer”. Then I pick two records from the results because I only want to update them with a new title “Sr. Developer.” I pick the field I want to update from the dropdown menu and provide a new value. When I click the Update Selected button, it dynamically builds the update request for me and executes it in Intacct via Intacct API. When I query again using the same criteria, you notice the title field for both selected records has been updated. There is no limit on how many records can be updated at the same time as long as Intacct doesn’t timeout.

There you have it. I hope you find this tool useful. If you would like to see a demo, please contact us at info@codepartners.com.

Selecting Intacct items

Figure 2. Records before update

 

Updated Intacct data

Figure 3. Records after update

 




Comments are closed.
On August 6, 2014 in Development, Web application [Post:by]
Tagged With: customization, mass update, Intacct / 3431 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.