Fun with XML, part 3

The fun continues! Today’s post is about the namespaces. I was unable to figure this out for the longest time and ended up giving up, manually pasting in the values I needed for submission. It was only in prepping this post that I came up with a way to get the namespace attributes in the right spot.

If you are interested in the entire journey, check out part 1 (the story behind this) and part 2 (deep dive into the technical details of creating the XML in SQL).

It seems from searching for this in various forums that other people had the same issue I did: using WITH NAMESPACES seemed to then put the namespaces in every element parent tag, where I only want it on the Submission tag. Here is how I worked around it and I can only assume it’s a “workaround” not a recommended way of doing it. It works so I’m going with it! I hope this helps someone else out there.

Continue reading “Fun with XML, part 3”

Fun with XML, part 2

Today’s post is a continuation of the mini-series I started on Feb 28th. You can read the first part here if you’d like, which contains the story behind this. In this post I’ll be getting into the technical details on what I learned.

This is about the guts of the XML itself, in SQL, where I ended up writing this procedure. First, before I get into the details, I wanted to reference this Stack Overflow post that was the single most useful post and example for the work I did. The person who posted the example, Ryan, also laid out a very simple temp table structure so I literally copied that code and pasted it into my test SQL server and played with it to understand it.

Continue reading “Fun with XML, part 2”

Fun with XML, part 1

This is going to be a short series of posts (short series, not short posts!) about my journey with creating an XML file for T5 filing with the Canada Revenue Agency (CRA for short). So many things happened in the last couple of weeks on this, that there were plenty of lessons learned to share and stories to tell! The story overall was one of a lot of frustration at times but in the end, a lot of pride in figuring things out with a deadline looming and ultimately, successfully creating an XML file to submit on time for our T5’s.

Continue reading “Fun with XML, part 1”

Additional menu in GP windows

Today’s #TipTuesday is a pretty simple one, it’s about the Additional menus in GP windows that appear when you use Extender (from eOne Solutions) or other ISV solutions or customizations that add functionality to existing Dynamics GP windows. I learned something that shouldn’t have been new to me, so I either didn’t know this or had forgotten about how security worked, as it relates to Extender. I can’t say 100% that this applies generically to all Additional menu items but I believe it does. Someone can comment if I’m incorrect here!

Continue reading “Additional menu in GP windows”

Prepaid Visa Card rip-off

Recently, I was given a Visa gift card from a friend, which ultimately was given to her from someone else. She’d been holding onto it for over a year, with no particular need to use it and owed me for something so offered it up since she had no cash with her at the time. I was fine with it because I would find a use for it somewhere but quite honestly, had planned to hold onto it and use it with some other things as I have a birthday coming up.

We had no idea that she was being ripped off by ridiculous fees and that the value of the card (originally $25) was now down to $16. I tried to check the balance when the card didn’t work on 3 separate attempts to use it, and found out there were $3 charges on the card each of the last 3 months. I called the number on the back of the card to ask about what the charges were, one of which was dated last week, when I had the card already but had never used it. I thought it might have been compromised, but no, that wasn’t it at all.

Continue reading “Prepaid Visa Card rip-off”

When did that G/L Account get added?

This phrase was uttered in the office recently, by the person who is tracking final changes to the year end Financial Statements. Her statements were out of balance, which turned out to be a new G/L Account. The next phrase was “Oh sorry, I forgot to tell you I added that. There must be some way to to alert you because I won’t always remember to tell you!”

Yes, there must be a way! Cue the SmartList-based Home Page Reminders. This is the subject of today’s #TipTuesday post.

Continue reading “When did that G/L Account get added?”

Changing Password Managers

Back in October last year, I posted a couple of articles around my recommendations and use of Two-Factor authentication. (Here’s part 1 and part 2 for those articles, if you’re interested in reading them.)

In my part 2 post, I indicated that I was also using a password manager and was using LastPass at the time. I have recently switched to 1Password and after posting a couple of things about that on Twitter, a few friends and followers expressed interest in knowing more about why I switched and how I would compare the two of them.

Continue reading “Changing Password Managers”

My write-off doesn’t add up!

Or does it? Today’s post is the first #TipTuesday of 2019, and a little bit of an obscure one at that. The short version is, if you use the write-off feature while you are applying payments or credit notes in Dynamics GP Receivables Management, the results display rather oddly on the RM Historical Aged Trial Balance. In fact, at first glance, it seems like the report is actually wrong, but it’s not, and here’s why.

Continue reading “My write-off doesn’t add up!”

Posts navigation

1 2 3 4 5 28 29 30
Scroll to top