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.
Microsoft Excel Microsoft Office
SQL Server
SQL Alerts with HTML email body
A #TipTuesday post about how to send a SQL Alert in email in HTML.
Personal
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.
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.
Personal
Prepaid Visa Card rip-off
This post is a warning to those buying or receiving prepaid credit cards.