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
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 »
Tagged With:
SQL server
/ 2376 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 »
Tagged With:
Pivot tables
,
web development
/ 2063 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 »
Tagged With:
integration
,
outsourcing
,
HRO
/ 3430 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 »
Tagged With:
delete
,
mass delete
,
Intacct
/ 2533 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 »
Tagged With:
computing
,
ERP software
,
Sales management
/ 2079 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 »
Tagged With:
integration
,
SmartLinks
,
Google Maps
,
Intacct
,
Smart Links
/ 3432 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 »
Tagged With:
Crystal Reports
,
Sage 300 ERP
,
Sage 300 ERP 6.0
/ 45758 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 »
Tagged With:
development
,
application development
/ 2081 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 »
Tagged With:
application development
,
customization
,
Sage CRM
/ 2358 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 »
Tagged With:
Azure
,
PowerShell
,
.Net web development
,
Windows
/ 5549 Views
1
2
Next
Search
Categories
General (166)
Development (158)
Success Stories (40)
Products (29)
Uncategorized (18)
BTerrell Group (5)
Project Management (22)
Web Development (57)
Web application (33)
Integration (19)
Mobile Development (7)
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.