SmartList Export: Excel cannot open error

Today’s #TipTuesday is one a client ran into a little while ago, and is worth sharing how you may find out what is causing the issue. The TL;DR version is a strange character somehow was input into an invoice comment and it caused an issue when that record (with that field) was exported to Excel from a Dynamics GP SmartList. Exporting to Word instead of Excel showed where the character was to be able to edit the data to remove it.

Continue reading “SmartList Export: Excel cannot open error”

Testing email functionality

Today’s #TipTuesday is around email functionality in Microsoft Dynamics GP and some tips around how to test it. As you may have read in my post last week, I made some mistakes in testing that have led to this post. Long story short: I neglected to edit all the tables that had live email addresses when I did some testing. There are some other things I could have also done to prevent compounding the problem, and all of that is what I intend to cover in this post.

The background to this post is the standard non-Workflow related email for emailing documents to customers or vendors. While some of what I’m about to say may apply to Workflow emails, I am going to be explicit here and say I didn’t not document all of the places where Workflow may contain data and it’s not covered here. The only mention of Workflow is in relation to valid Series settings in the SY04902 table.

Continue reading “Testing email functionality”

Fixed Assets GL Posting Flow Part 8

Today’s #TipTuesday is the finale of my series on Fixed Asset transactions in Dynamics GP and what G/L accounts get used where. Today is where I will walk through the rest of the catch-all set of scenarios around what kinds of asset changes impact the G/L.

The previous posts so far are:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
  3. Retirements in the 1st year of ownership
  4. Retirements after the 1st year of ownership
  5. Different retirement types & impact on Gain/Loss Account
  6. Retirements with proceeds and sale expenses
  7. Account changes & Mass Change impact on G/L
Continue reading “Fixed Assets GL Posting Flow Part 8”

Fixed Assets GL Posting Flow Part 7

Today’s #TipTuesday is a continuation of my series on Fixed Asset transactions in Dynamics GP and what G/L accounts get used where. Today is the second-last of the series, where I will walk through a catch-all set of scenarios around what kinds of asset changes impact the G/L. Half of the scenarios are here, and the rest I’ll cover next week.

The previous posts so far are:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
  3. Retirements in the 1st year of ownership
  4. Retirements after the 1st year of ownership
  5. Different retirement types & impact on Gain/Loss Account
  6. Retirements with proceeds and sale expenses
Continue reading “Fixed Assets GL Posting Flow Part 7”

Fixed Assets GL Posting Flow Part 6

Today’s #TipTuesday is a continuation of what happens during Retirement transactions in Dynamics GP. Today is the last of the “retirement” scenarios I plan on covering and it is: proceeds (cash, non-cash), sale expenses and their impact on the resulting retirement journal entry.

The previous posts so far are:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
  3. Retirements in the 1st year of ownership
  4. Retirements after the 1st year of ownership
  5. Different retirement types & impact on Gain/Loss Account
Continue reading “Fixed Assets GL Posting Flow Part 6”

Fixed Assets GL Posting Flow Part 5

Today’s #TipTuesday is a continuation of what happens during Retirement transactions in Dynamics GP. Today: different retirement types and the impact on which Gain/Loss account is chosen.

The previous posts so far are:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
  3. Retirements in the 1st year of ownership
  4. Retirements after the 1st year of ownership
Continue reading “Fixed Assets GL Posting Flow Part 5”

Fixed Assets GL Posting Flow Part 3

Today’s #TipTuesday is a continuation of my Fixed Assets series around G/L posting flow. This post will be the start of what happens during Retirement transactions in Dynamics GP. There are a lot of options around retirements, although in the end most selections don’t impact the results much as you will see. I will be breaking this into different posts to keep the length manageable. Today: retirements in the first year of ownership (acquisition year).

The previous posts so far are:

  1. Additions with & without YTD/LTD amortization
  2. Depreciation/Amortization
Continue reading “Fixed Assets GL Posting Flow Part 3”

Posts navigation

1 2 3 4 11 12 13
Scroll to top