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

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

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

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

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

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

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

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

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

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