Mark Polino's Blog, page 23

Importance of Recovery Model in SQL Server — DatabaseJournal.com

DatabaseJournal has a nice, straightforward look at the Importance of Recovery Model in SQL Server 

The post Importance of Recovery Model in SQL Server — DatabaseJournal.com appeared first on DynamicAccounting.net.

How to use Dynamics GP SmartList to find accounts with the wrong posting type – Etelligent Solutions-

This just can’t be covered enough. From Sheldon: How to use Dynamics GP SmartList to find accounts with the wrong posting type 

The post How to use Dynamics GP SmartList to find accounts with the wrong posting type – Etelligent Solutions- appeared first on DynamicAccounting.net.

Management Reporter ‘Bad or missing data…’ error | azurecurve

Ian Grieve covers Management Reporter ‘Bad or missing data…’ error 

The post Management Reporter ‘Bad or missing data…’ error | azurecurve appeared first on DynamicAccounting.net.

Dynamics Podcast Episode 8 – French and the 1% | Dynamics Podcast

Dynamics Podcast Episode 8 – French and the 1% is up and it’s a lot of fun.

The post Dynamics Podcast Episode 8 – French and the 1% | Dynamics Podcast appeared first on DynamicAccounting.net.

After restarting SQL Server, only sa user can log into Microsoft Dynamics GP – Developing for Dynamics GP

David Musgrave addresses an issue where After restarting SQL Server, only sa user can log into Microsoft Dynamics GP

The post After restarting SQL Server, only sa user can log into Microsoft Dynamics GP – Developing for Dynamics GP appeared first on DynamicAccounting.net.

Ending Dynamics ERP SMB exams ‘not a decision we took lightly’ says Microsoft’s Jeff Edwards | MSDynamicsWorld.com

Microsoft responds. Ending Dynamics ERP SMB exams ‘not a decision we took lightly’ says Microsoft’s Jeff Edwards

I respectfully disagree.

I have met, worked with and trained more than enough partners and consultants to know that the average consultant still has a long to way to go to really be up to date on the latest Dynamics GP release.

I also continue to argue that in online/Azure/cloud first world we will inevitably see consolidation of the technology layer into fewer players with fewer people. One big data center needs fewer administrators than 100 companies who have administer servers on premise. This argues for a better understanding of how to manage a business inside of GP, not how to manage technology.

Finally, if the Dynamics team has budgetary and P&L responsibility for all of the exams created they have other problems. For GP, the exam has barely changed in 5 versions, so the cost of updating should be minimal. Secondly, partners pay to take the exams so there is a revenue stream associated with them to offset the costs. Online training is going to deliver cost without offsetting revenue.

I still think that eliminating the exams was a mistake on Microsoft’s part and that it removes one of the few incentives for consultants to stay up to date.

 

The post Ending Dynamics ERP SMB exams ‘not a decision we took lightly’ says Microsoft’s Jeff Edwards | MSDynamicsWorld.com appeared first on DynamicAccounting.net.

SQL view for easier General Ledger transaction searches in Dynamics GP | Victoria Yudin

Victoria Yudin offers up a SQL view for easier General Ledger transaction searches in Dynamics GP

The post SQL view for easier General Ledger transaction searches in Dynamics GP | Victoria Yudin appeared first on DynamicAccounting.net.

Dynamics GP Land: Dealing with 1/1/1900 with GP and SQL Reports

Christina Phillips offers help for Dealing with 1/1/1900 with GP and SQL Reports.

The post Dynamics GP Land: Dealing with 1/1/1900 with GP and SQL Reports appeared first on DynamicAccounting.net.

Dynamics GP Land: RUN FOR THE HILLS! Christina is trying to write code!

RUN FOR THE HILLS! Christina is trying to write code!. Christina wrote that, not me.

The post Dynamics GP Land: RUN FOR THE HILLS! Christina is trying to write code! appeared first on DynamicAccounting.net.

Weekly Dynamic: Remove Security Records

Featured Post

So you’ve finally updated your security from the automatic security import from version 9, or maybe your business has changed and you’ve consolidated a bunch of security settings and now you need to get rid of some roles, tasks or alternate/modified dictionaries. Its important to clean this up so you don’t accidentally assign security improperly using old setup.

It’s actually pretty easy to clean these up. GP offers a Remove Security Setup Records Utility in Administration>Utilities.

 

The window is pretty straightforward. Pick the type of records to remove, set the range of records, and hit process.

Cleaning up security is important and this provides a nice way to make that easier.

The post Weekly Dynamic: Remove Security Records appeared first on DynamicAccounting.net.