Tag: dynamics

SQL view to verify unposted SOP transaction totals in Dynamics GP

| 09/12/2014 | 0 Comments

Over the years we have seen a number of situations where a sales transaction total will be calculated incorrectly.

Continue Reading

Backup regimes and synchronizing folders across your network

| 09/10/2014 | 0 Comments

On my computers at home I have a backup and synchronization regime to ensure that each computer has access to the files I want (even when offline) and that there is no chance of losing any data in the event of a disaster. In this post, I will explain my regime and some of the tools and tricks I have learnt. While I am sure others will have their own systems and might not agree with what I am doing.

Continue Reading

Tech Tuesday: What is creating these XML files?

Continue Reading

After restarting SQL Server, only ‘sa’ user can log into Microsoft Dynamics GP

| 09/08/2014 | 0 Comments

Last week, I resolved a rather bizarre case for a customer. The Situation Each time the customer’s SQL Server was restarted for whatever reason, only the ‘sa’ user was able to log into Microsoft Dynamics GP.  Once the ‘sa’ user had logged into Microsoft Dynamics GP at least once, then all the other “normal” users could log in and everything was fine until the next time the SQL Server was restarted.

Continue Reading

SQL view for easier General Ledger transaction searches in Dynamics GP

| 09/04/2014 | 0 Comments

Just about every Dynamics GP customer I have worked with, at one time or another, has had occasion to search the General Ledger for a particular dollar amount.

Continue Reading

Tech Tuesday: SmartList Builder needs to Finish Installing at Every Login

We hope you had a restful Labor Day weekend! To start the week off we have a Tech Tuesday article from our SmartList Builder guru, Jared Dux, who is addressing an error that some users have been experiencing when upgrading SmartList Builder.   

Continue Reading

reIMAGINE 2014 – Welcome Home Party

reIMAGINE 2014 – Welcome Home Party

@media only screen and (max-width: 480px) body,table,td,div,p,a,li,blockquote -webkit-text-size-adjust:none !important; tdid=pageContainer ul margin: 0 !important; padding-left: 18px !important; padding-right: 18px !important; line-height: 125% !important; tdid=pageContainer ol { margin:

Continue Reading