As 2013 comes to a close, I have reflected upon the past year, and all of our changes, highlights and company direction. Some of these are probably worth noting to you, to see where the company is heading.

Added Intacct developers to our team. Well, technically, some of our team members attended training to become Intacct Platform Services and API developers. Other members of our team are now In...

by Emma Tsai
Recently, I received a request from a customer who wants to generate AR invoices based on an imported Excel file from a third party application. The interesting part of this regular import is the sales taxes are imported from the Excel file, instead of being calculated by Sage 300 ERP. If the import file contains tax amounts, then the import process allows Sage 300 ERP to calculate th...

by Brian Terrell
I attended a session, at the Information Technology Alliance Fall Collaborative, today in Salt Lake City. This conference is designed to help ERP business partners and information technology leaders determine the key metrics they are keeping to manage their firms. Bob Gaby, a principal of Arxis Technology, and Dan Milne, a partner with Eide Bailly LLP, delivere...

by Kristi Feng

For the past few weeks, I worked on a project in Intacct. I have two related objects in my project and I need to display the total amount of the child object in the parent object. 
I had to create two triggers to accomplish this task:
1.    Update Field Value on the parent record to update the summary field value
2.    Have the child record run ...

by Derek Du
Have you had the headache of configuring permissions to your ApplicationPoolIdentity account while running your web application under it? The IIS APPPOOL\Name trick never works for me. I run the ICACLS command to find the user in the permission configuration window.
If your ApplicationPoolIdentity-using-web-application utilizes a certificate to encrypt/decrypt messages, such as a WCF...

by Sheila Zhang
Databases designed for businesses typically focus on data manipulation. Normalized relational databases tend to increase the amount of tables, to reduce the space required for data storage, while being updated to reduce redundancy. For example: a customer table holds the customer ID and address information for each customer, and the sales order table only keeps the customer ID, not...

by Jacky Xu
I encountered a Dead Lock while working on a project to extract data from Intacct through a Web API.  I tried HttpClient.SendAsync as I did not want to block the web page once I called it to retrieve data from the Web API. First, I created a test project to ensure everything ran accordingly before releasing this change. It didn't work the way I planned. After more research, I fina...