Dynamics GP Land

| |

Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format

Posted 6 hours ago

by ChristinaDynamics

In May 2012, I wrote about an apparent bug in the Dynamics GP 2010 Payables EFT CCT+ file format that prevented my customer from using the CTX file format (CCD+ with the Detail Line Addenda option). At the time, the bug affected GP 2010 SP 2, as the CTX...
MR 2012 UR 4- Quirky Excel Linking Behavior with RPO

Posted 3 days ago

by ChristinaDynamics

We had a client bring up an interesting issue last week, after updating MR 2012 to UR4. They use GL and Worksheet links in their row formats like this... (B=B3, C=C3, D=D3, J=B3, K=C3, L=D3) /RPO RPO (Row Period Offset), allows you to just specify the...
And the winner is....Doug Pitcher!

Posted 11 days ago

by ChristinaDynamics

I haven't met many famous people. Well, okay, depending on what you mean by famous, I haven't met any famous people. I saw Sylvester Stallone once at a country club--well, okay, someone told me that the guy I just walked past was Sylvester Stallone...
Relating GL Data to Project Accounting

Posted 19 days ago

by ChristinaDynamics

In any discussion regarding reporting and project accounting, we always end up talking about the GL. And the inevitable question comes up about reporting the GL by project. Which, of course, there aren't a lot of standard options... Within Dynamics...
Management Reporter Report Scheduling

Posted 1 month ago

by ChristinaDynamics

Earlier this week, I received my regular GPUG Community Update email, and it contained the following poll results: Really? Only 17.4% picked Management Reporter? As I was prepping a presentation on MR Report Distribution for the GPUG Special Interest...
2013 Top 100 Most Influential People in Microsoft Dynamics

Posted 1 month ago

by ChristinaDynamics

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Dynamics World has once again prepared a list of candidates for The Top 100 Most Influential People in Microsoft Dynamics. http://www.dynamicsworld.co.uk/the-top-100-most-influential...
What if...I went to Dale Carnegie training?

Posted 2 months ago

by ChristinaDynamics

So, yesterday I took advantage of the Leadership track at Convergence 2013 here in BEAUTIFUL SUNNY New Orleans, and I attended a Dale Carnegie session on building trust. The presenter was awesome, very dynamic and raised some interesting points. My coworker...
Predicting Payments Based on Average Days to Pay

Posted 2 months ago

by ChristinaDynamics

Had a great time today, and finished the day at the geography-based roundtables for GPUG. I was sitting at the IA, KS, MO table, and we had a full group. A lot of different topics of discussion- the upcoming regional chapter meeting on April 17th, everyone's...
Convergence 2013!

Posted 2 months ago

by ChristinaDynamics

Convergence 2013 here in New Orleans marks the first conference in quite a while where I am actually going to enjoy the conference. I am not working in a both, staffing the labs, or presenting. Just going to see old friends, hopefully make some new ones...
Updating Records with Excel

Posted 2 months ago

by ChristinaDynamics

Recently, I have had to update 1099 information for a set of vendors that was inadvertently cleared out. In that case, I retreated back to one of the simplest ways that I approach updating groups of records using Excel. In this case, I had a backup of...
Finding Duplicate GL Entries

Posted 2 months ago

by ChristinaDynamics

I faced an interesting dilemma this past week, in trying to locate duplicate GL entries integrated from another system. Obviously, GP doesn't know they are duplicates and assigned each one a unique journal entry number. So we had to find a way to...
Skype very slow on Windows 7

Posted 3 months ago

by ChristinaDynamics

I've been using Skype regularly for 3-4 years now to have almost daily calls with a colleague in Australia. While it has generally worked well, one problem I've had in the last year is that the Skype application has seemed extremely slow and unresponsive...
Cool Tool for Fixing 1099s

Posted 3 months ago

by ChristinaDynamics

Sometimes when you search for a fix, just hoping that there is a simple way to fix an issue, you find it. I came across this today, not realizing it was part of the Professional Services Toolkit. Super cool in my book, it fixes transactions that were...
Generating a 941 for 2012, Really?

Posted 3 months ago

by ChristinaDynamics

Do you really have to reapply the 2012 tax tables in order to run a 941 for 2012 in Dynamics GP...say it ain't so. Anyone out there with clever ideas, please share! Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional...
Correcting FICA Underwithholding

Posted 3 months ago

by ChristinaDynamics

Why does the government mess with us so? Especially in the month of January, where we are already running around trying to get 1099s and W2s out the door. As it goes, anytime there is a change in either FICA rate, inevitably somebody doesn't apply...
Dynamics GP security conundrum

Posted 3 months ago

by ChristinaDynamics

Today I was helping a customer install Post Master Enterprise for Dynamics GP in a development environment for testing. It should have been a simple process, taking maybe 15 minutes--but after an hour, we had to stop and reassess. The Post Master Enterprise...
OS X vs. Windows

Posted 3 months ago

by ChristinaDynamics

In 2011, I wrote about my initial impressions of a Macbook Air that I had purchased. At that time, I only wanted the sleek hardware for a new Windows laptop, and I never considered running OS X. After all, I am a Dynamics GP consultant, a Dynamics GP...
Payroll 401k Submission

Posted 4 months ago

by ChristinaDynamics

Okay, we have been a little radio-silent over here at Dynamics GP Land. Blame the holidays. Blame the year end crush in our line of work. Blame sick kids and sick spouses. Know that we have thought of posting often, and just didn't quite make it ...
SQL Server Management Studio IntelliSense Doesn't Work

Posted 5 months ago

by ChristinaDynamics

I have recently worked on several Dynamics GP SQL Server 2008 servers where the IntelliSense feature in SQL Server Management Studio was not working. I would type "SELECT * FROM RM", expecting to get a list of RM tables, but nothing would happen...
Dynamics GP 2010 Localization and Language

Posted 6 months ago

by ChristinaDynamics

Two "L" words that cause a lot of confusion in regards to Microsoft Dynamics GP are "Localization" and "Language". I have heard these used interchangeably when they actually mean very different things. Localization is the...
Support Expectations

Posted 6 months ago

by ChristinaDynamics

Recently, I have been coaching consultants that are relatively new in their careers working with Dynamics GP. It has been a really eye-opening experience in learning styles, consulting styles, and how we all build knowledge and expertise in a way that...
Generating Secure Report Links in Management Reporter

Posted 6 months ago

by ChristinaDynamics

Back in the FRx days, you could generate a report directly to Excel. Due to security concerns related to generating financial data to a file that was not secure, that capability was eliminated with Management Reporter. However, many users still have a...
When developing eConnect integrations, don't forget the details...

Posted 6 months ago

by ChristinaDynamics

I am testing an eConnect SOP Invoice integration that I just developed. The invoices are importing fine, and everything looks good...except...the invoice distributions are duplicated. Instead of 3 distribution lines, there are 6 lines. Hmmm, that isn't...
Management Reporter Migration and Row Linking

Posted 6 months ago

by ChristinaDynamics

It has been very well publicized that MR does not yet have row linking capability. In FRx, you could design a report tree and have each branch of the tree use a different row format. In MR, you can link to different GL links within a row format but not...
Save Operation on UPR_WORK_State_Tax

Posted 6 months ago

by ChristinaDynamics

When building a payroll (Transactions-Payroll-Build Checks) on GP2010, a client encountered the error "A save operation on table 'UPR_WORK_State_Tax' has created a duplicate key". We isolated the error to benefit transactions for three...

Microsoft Dynamics GP

About Dynamics GP Land