Back to consulting!
I share my decision to return to consulting work after a change in employment, discussing the transition and what’s next.
News
Microsoft Excel Microsoft Office
Excel Paste Special – Operations
This #TipTuesday post is how to Paste Special with a multiply or divide operation to quickly change the sign on a set of data.
SQL Server
SQL Alerts with HTML email body
Learn how to configure SQL Server alerts to send email notifications with HTML formatting for better readability and presentation.
Miscellaneous
In search of the perfect credit card
This post is off-topic about a series of trials and errors in finding the right credit card for my needs.
SmartList & SmartList Builder
SmartList stuck on My Reports pane
A #TipTuesday post about a SmartList stuck on the My Reports pane and how to resolve the issue.
SmartList & SmartList Builder
Originating fields in SmartList
A #TipTuesday post about what the Originating fields in SmartList mean and what information they contain.
Integrations
eConnect Distributions – double trouble
A #TipTuesday post about eConnect integrations and settings that define whether default GL distributions are created or not.
Integrations
SmartConnect, Variables & Quotes
This #TipTuesday post is about integrating into Dynamics GP with SmartConnect, and using variables with something to watch out for.
Integrations
Object reference not set to an instance of an object
A post about an error “object reference not set to an instance of an object” while integrating with SmartConnect.
Fixed Assets
Fixed Asset Labelling
This #TipTuesday post is information about Asset Labels vs. Asset IDs and when to use the Asset Label feature.
Integrations
SmartConnect Define Company
A post about using the Define Company option in SmartConnect to specify what company in Dynamics GP to integrate into.
Canadian Payroll
Mass Update CPY Basic Personal Exemption
A #TipTuesday post about how to update the Basic Personal Amount in Canadian Payroll in Dynamics GP.
Dynamics GP Security
What’s included in those SQL rpt roles?
A #TipTuesday post about reviewing the permissions in the Dynamics GP “rpt” SQL roles.
Canadian Payroll
Cdn Payroll T4 XML & Multiple Employers
A #TipTuesday post about how Dynamics GP generates the XML file when there are multiple employers set up in Canadian Payroll.
Development SQL Server
Fun with XML, the end
This is the 5th post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 4
This is the 4th post in a 5-part series about building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 3
This is the 3rd post in a 5-part series about building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 2
This is the 2nd post in a 5-part series about building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 1
This is the 1st post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Dynamics GP
Additional menu in GP windows
A post about the Additional menu in Dynamics GP that might appear in various circumstances, including when using Extender.