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


User Already Exists in the Current Database – Orphaned Users in SQL Server

by Derek Du

Today, when moving databases via backup and restoring, I had an issue of re-creating User Mappings on the new databases. An error, “User Already Exists in the Current Database,” prevents me from adding any mapping to the existing databases. Below is a solution:
This script shows the existing users of the selected database:
EXEC sp_change_users_login ‘Repor...
Read More »

On May 28, 2014 in Development [Post:by] Comment 0
Tagged With: SQL server / 2283 Views

Our Favorite Articles for the Week of May 23

by Emma Tsai
 

Here are my favorite articles I read recently:

1.       Pivot Tables Made Easy: The Last Demo You’ll Need
This is a very practical article to show you steps to produce pivot tables that benefit your account management.

 

2.       8 takeaways from eye tracking studies
It is an interesting article to h...
Read More »

On May 23, 2014 in General [Post:by] Comment 0
Tagged With: Pivot tables, web development / 1958 Views

Why SMBs Should Consider Human Resources Outsourcing (HRO)

by Brian Terrell

It’s no secret that owners of small- and mid-sized businesses (SMBs) wear many hats including payroll clerk, benefits manager, receptionist, office manager, and even mediator! In fact, according to the U.S. Small Business Administration, small business owners spend up to 25 percent of their time handling HR functions such as payroll, taxes, and benefits.

Unfortunately, o...
      Read More »

      On May 21, 2014 in General [Post:by] Comment 0
      Tagged With: integration, outsourcing, HRO / 3337 Views

      Intacct Mass Deletion Tool Introduction (Part 2)

      by Jacky Xu In a previous post, I explained how we created a specific tool to query and delete objects in Intacct. Here is the second part of the explanation.
      1. After you select the field, it auto-loads the operator, based on the selected field type. If you select the date type field, the value column shows you a date-picker to let you input the value quickly.
      ...
      Read More »

      On May 19, 2014 in Development, Web Development [Post:by] Comment 0
      Tagged With: delete, mass delete, Intacct / 2392 Views

      Top Articles for the Week of May 16

      by Hrayr Galoyan
      Here are the most interesting articles I read this week:

      The Consumer Revolution of Enterprise Computing

      Really, what version of Facebook are we on? I never thought about it, until I read this article, and then I realized that the concept of versions might be outdated already. Customers don't care about version numbers, they care about functionality. Its interesting to compare...
      Read More »

      On May 16, 2014 in General [Post:by] Comment 0
      Tagged With: computing, ERP software, Sales management / 1961 Views

      Working with Intacct SmartLink Clicks

      by Kristi Feng
      A SmartLink Click in Intacct allows us to embed intelligent hyperlinks into forms and reports. The hyperlinks can be based on conditional information about the objects in Intacct. We need to enable Platform Services or Customization Servers before adding a new SmartLink Click.
      When we create a SmartLink Click, we usually focus on two main properties:
      • Target (required): This is ...
      Read More »

      On May 14, 2014 in Development, Integration, Web application [Post:by] Comment 0
      Tagged With: integration, SmartLinks, Google Maps, Intacct, Smart Links / 3284 Views

      Failed User Login When Printing a Customized Crystal Report

      by Sheila Zhang
      We know that Sage 300 ERP is smart enough to use the local SQL database login to replace the SQL database login that is used on the development computer. So you don’t always need to install your client database when developing a general logic report for them on your computer. We did this for a while. However, you need to do this if you are referring to an additional data tabl...
          Read More »

          On May 12, 2014 in General, Integration [Post:by] Comment 0
          Tagged With: Crystal Reports, Sage 300 ERP, Sage 300 ERP 6.0 / 35007 Views

          Our Favorite Articles from the Week of May 9

          by Derek Du
          Here are some of the most interesting articles I read this week.

          Why Chinese Is So Damn Hard (2010)  
          Learning Chinese must give David Moser a big headache, he wrote such a long complaint. Following his logic, I also looked up the equivalent of "it's Greek to me" in other languages and very interestingly almost all the languages use Chinese in their corresponding idioms. What is...
          Read More »

          On May 9, 2014 in General [Post:by] Comment 0
          Tagged With: development, application development / 1976 Views

          Customization Project for Sage CRM

          by Emma Tsai

          Recently, we provided staff augmentation services to a housing service company. We had a Sage CRM developer working on several CRM customization projects that support their special operational needs for their student housing account management. One of the most current projects is to pull the application information from their existing housing website and upload them to Sage CRM and t...
          Read More »

          On May 7, 2014 in Development, Project Management, Success Stories [Post:by] Comment 0
          Tagged With: application development, customization, Sage CRM / 2261 Views

          How to Download Log Files for a Windows Azure Website using PowerShell

          by Joe Zhou

          It is essential for a .NET web developer to be equipped with knowledge about event logging and diagnostics. It remains true when it comes to Windows Azure, even though nowadays Azure developers can get away from configuring IIS and dealing with VMs most of time. Here are the steps to download log files without using FTP. I will use PowerShell instead.
           
          1.   &nbs...
          Read More »

          On May 5, 2014 in Development, Web Development [Post:by] Comment 0
          Tagged With: Azure, PowerShell, .Net web development, Windows / 5377 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.