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


CodePartners Creates Intacct GL File Uploader

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

by Joe Zhou

At BTerrell, our development team works very closely with our consulting team led by Chris Firra on the daily basis. I often solicit Chris for ideas to build generic tools for Intacct that can save our customers time. A couple of weeks ago, Chris approached me and told me about an import tool a client needed.

In a nutshell, here are the requirements.

1.       The client has two types of CSV files that they want to import into GL on a regular basis.

2.       The client wants the ability to define the mapping between the CSV file and GL by themselves, because they want the flexibility in case the file format changes.

3.       The client would like to be able to do the import within Intacct.

After analyzing the requirements, we came up with a solution to meet the client’s need and satisfy any prospects with similar needs.

First, the tool is web-based and can be embedded in a dashboard within Intacct. Second, the tool supports drag-and-drop, and it can import any CSV files as long as they have a header as the first row. Third, it allows the user to pick and choose which column from the CSV file is mapped to which field exposed by Intacct’s GL Entry object.

These screenshots illustrate how the tool works. As you can see, the tool is very straightforward and easy to use. Using this tool, hundreds of transactions can be imported into Intacct within a matter of a few minutes.

Figure 1. Preview the CSV file to be imported

Intacct uploader tool

Figure 2. Map the importing file with the GL Entry object

Intacct import mapping

Figure 3. Save the mapping and upload the file

Upload file to Intacct

Figure 4. View Journal Entries in Intacct

Intacct journal entries

If you are interested in this tool, please contact me at joe.zhou@codepartners.com.

 

 




Comments are closed.
On September 3, 2014 in Development, Success Stories , Web Development [Post:by]
Tagged With: general ledger, import, Intacct / 4289 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.