SmartList stuck on My Reports pane
A #TipTuesday post about a SmartList stuck on the My Reports pane.
SmartList & SmartList Builder
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
This #TipTuesday post was a fun one. I kept getting an error “object reference not set to an instance of an object” while integrating into Dynamics GP in SmartConnect and it took me a while to find the reason for it.
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
This #TipTuesday post is about using the Define Company option in SmartConnect and why it’s my number one way of identifying 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 where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing. In this post, I discuss file validation.
Development SQL Server
Fun with XML, part 3
This is the 3rd 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. This post is about namespaces.
Development SQL Server
Fun with XML, part 2
This is the 2nd 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. This post is about the “guts” of the SQL to create the XML.
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. This post is the intro and story on why I needed to do this and the trials and tribulations of my various efforts to get it working.
Dynamics GP
Additional menu in GP windows
A #TipTuesday post about the Additional menu in Dynamics GP that might appear in various circumstances, including when using Extender from eOne Solutions.
Personal
Prepaid Visa Card rip-off
This post is a warning to those buying or receiving prepaid credit cards. Watch the terms, mine starts with $3/month charges to reduce the balance on the card after one year of activation.
SmartList & SmartList Builder
When did that GL Account get added?
A #TipTuesday post about SmartList reminders using the example of tracking when new GL Accounts get added to Dynamics GP.
SmartList & SmartList Builder
SmartList Options
A #TipTuesday post about the SmartList Options window and how it can be used to manage the default columns, search defaults and default number of records returned.
Miscellaneous Security
Changing Password Managers
This post is my experience with changing Password Managers from LastPass to 1Password.