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


Manipulating SQL String Functions

by Sheila Zhang
I recently reviewed SQL character functions in SQL 2012. One thing I learned is that these functions also work in SQL 2008.
Commonly, I need to combine several string type fields into one in your select statement. So, I may write something like this:
“SELECT empid, country, region, city, country + COALESCE( N',' + region, N'') + N',' + city AS location FROM HR.Employees&...
Read More »

On September 27, 2013 in Development [Post:by] Comment 0
Tagged With: application development, character function, MSSQL / 3508 Views

How to Default the Company Dashboard in Sage CRM

by Kristi Feng
A while ago, a client asked if Sage CRM had a way to default the Company Interactive Dashboard based on Company Type.
There is an asp page that displays the interactive dashboards. It is located under #CRM Installed Path#\#CRM Instance Name#\WWWRoot\InteractiveDashboard\InteractiveDashboard.asp.
It will pass QueryString to the SDataWebservice and if the QueryString contains the lpLa...
Read More »

On September 26, 2013 in General [Post:by] Comment 0
Tagged With: Company Interactive Dashboard, Customization, Sage CRM / 3394 Views

How to Develop Phone Apps with PhoneGap with jQuery Mobile Part 2

by Jacky Xu
In a previous blog post, I talked about how to get the environment set up to create mobile apps with PhoneGap and jQuery. Once you have the environment set up, it’s time to get started:
1. Create new project like below.
 
Select Android Application Project and click next.
 ...
Read More »

On September 25, 2013 in Mobile Development [Post:by] Comment 0
Tagged With: mobile development, PhoneGap, jQuery / 2857 Views

Configuring Journal Entry Detail Optional Fields

by Hrayr Galoyan
The optional fields configuration for GL Journal Entry in Sage 300 ERP can be a little confusing. Say you wanted to capture a field called SERIALNO on the detail level of Journal Entry. You would first create the field in the Common Services, and then add it to the Transaction Details as shown in the figure below.
 ...
Read More »

On September 24, 2013 in General [Post:by] Comment 0
Tagged With: optional fields, journal entry, Sage 300 ERP / 7236 Views

Custom Estimate Duplicator for Sage CRM

by Emma Tsai
Recently, one of our Sage business partners asked me to do a customization project for Sage CRM 7.1. Their client wanted a way to copy an entire response for a quote and allow users to enter a new Quote Number to create a new quote.
We worked with the partner to get the requirements and created a simple program that would enable this to happen with a few keystrokes. With this customi...
Read More »

On September 23, 2013 in Success Stories [Post:by] Comment 0
Tagged With: Estimate duplicate, Proposal duplicate, Sage CRM / 11267 Views

How to Post JSON to REST Web Service with SoapUI

by Derek Du
Among several web service test tools I use, including WCFStorm, VS WCF Test Client, and other proprietary test tools, soapUI is my favorite. In a recent project, with the help of soapUI, I was able to add custom fields into an HTTP header, compose the authentication header field, and POST JSON data to a REST web service. Here’s a quick guide on how to add REST web services to soa...
Read More »

On September 20, 2013 in Web application, Web Development [Post:by] Comment 0
Tagged With: JSON, REST, SoapUI / 111290 Views

Use Intacct Chrome Test Tool and NimbleText to Import Data into Intacct

by Joe Zhou
There are so many ways to import data into Intacct. The most straightforward method is to prepare a CSV file that conforms to the format requirements of the object, manipulate the data in Excel, and use the Intacct import function to load the data. In this article, I will share with you a different approach that doesn’t require Excel and Intacct’s export and import buttons....
Read More »

On September 19, 2013 in General, Integration [Post:by] Comment 0
Tagged With: Intacct Test Tool, NimbleText, Intacct, Intacct Platform Services / 4028 Views

Comparing Integration Capabilities between Intacct and Sage 300 ERP

by Brian Terrell
Recently, a Sage business partner emailed me with these exact questions: “How do the integration capabilities of Intacct measure up compared to Sage 300 ERP? How is Intacct for screen customization?”. Many of our Sage business partner clients have also decided to sell and support Intacct Cloud Financials, and they naturally wonder to what extent their clients will be a...
Read More »

On September 18, 2013 in General, Integration [Post:by] Comment 0
Tagged With: Intacct, Sage 300 ERP / 2507 Views

Tools to Analyze Query Performance

by Sheila Zhang

If you need to monitor a system that has performance problems, start using Extended Events. It is a very lightweight performance monitoring system.

SQL Trace is an internal method for capturing events. You can set it up either manually or through SQL Server Profiler. Currently, it is supported by SQL 2012 and next version. After the next version, it might be discontinued.

SQL Se...
Read More »

On September 17, 2013 in General [Post:by] Comment 0
Tagged With: Extended Events, MSSQL, SQL Servr Profile, SQL trace / 2216 Views

How to Hide Columns from List Block Definition in Sage CRM

by Kristi Feng
Recently a new user to Sage CRM asked How to hide columns from the CommunicationToDoList. She tried with "Hidden = true;" in the Create Script, but it has no effect.
It was not specified in the "Developer's Guide," but in the "System Administrator Guide" it stated that we can do "Visible = false;" to hide the column in list control.
For example, we can put the following in the Creat...
Read More »

On September 16, 2013 in General [Post:by] Comment 0
Tagged With: Block List, Customization, Sage CRM / 2862 Views
12Next

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