by Jacky Xu

We can open a Sage 300 ERP session without using a user name and password through the Sage 300 ERP COM library “AccpacSessionManager.dll.” This is a sample from the COM library to open a session:




But, we already know the Sage 300 ERP .net library does not pro...

by Brian Terrell

Recently, I had supper with the CFO of a $100+ million dollar manufacturing company and their Sage Channel Partner. Our dinner party represents a partnership of three companies working together since 1999 on various automations to tailor Sage 300 ERP to the exact needs of the manufacturer. The group clearly has been successful together, and all parties benefit greatly by it. The...

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.    &nb...

by Sheila Zhang
Here are some articles I found useful this week:

Remove Customer-Poll.com pop-up ads (Removal Guide)

It solved my problem last week.

Complete Business-Systems Analysis Model (UML Example) - See more at: http://www.modernanalyst.com/Resources/Articles/tabid/115/ID/1252/Complete-Business-Systems-Analysis-Model-UML-Example.aspx#sthash.ne8Gij6P.dpuf

What are the Scrum Master re...

By Emma Tsai
Performing functional testing for software applications is part of the job as a business analyst. Occasionally, I need to work with SQL server to do database queries so that I can verify that the application pulls data results as expected. Recently, I learned how to use PIVOT operator to group and aggregate data in SQL database. Here is how it works:
In pivot queries, here are the thr...

by Jacky Xu

Recently, I was researching .net linq syntax and found one interesting function: Extension Methods. I found myself asking, Why can linq add many methods to many existing classes? Did Microsoft change these classes? The answer is no. They are using a new c# 3.0 feature: Extension Methods. The old way is to inherit the “string” class and add it to your new method, and use y...

by Joe Zhou
Here are my favorite articles I read this week.

1.       The ASP.NET Team shared their wisdom on how to develop ASP.Net vNext application on a Mac.
http://blogs.msdn.com/b/webdev/archive/2014/08/12/develop-asp-net-vnext-applications-on-a-mac.aspx
2.       As the team lead with team members at different locations, I found Ma...

by Brian Terrell

Recently, I discussed several potential projects with Sheila Zhang, one of the very experienced and excellent Intacct and Sage Business Analysts working at CodePartners.  Sheila and I had just completed a discovery call with a Business Partner and their client on an opportunity to automate a complex and mission critical business process for this client.  At o...

by Hrayr Galoyan

I recently worked on integrating Intacct with Salesforce. There is an existing integration package, and the manual that comes with it is pretty good. However, I faced several issues that the manual did not cover, and most were related to Salesforce functionality. This was my first time integrating Intacct and Salesforce. Fortunately, Salesforce has an outstanding support team; t...

by Kristi Feng

Here are my favorite articles for this week:

3 cool Google cloud features

Google Cloud Platform targets developer with the following 3 unique features: Managed VMs, Replica Pools and Kurbernetes (management framework)

 

9 Common BI software mistakes (and how to avoid them)

Discussion on common mistakes when company selecting and implementing BI solution

 

...