Profile cover photo
Profile photo
Mark Polino
Microsoft MVP for Dynamics GP
Microsoft MVP for Dynamics GP

Mark's posts

Post has attachment

Weekly Dynamic: GP, Terminal Server and Macros

It’s possible, and not all that unusual, to build a long running macro in Dynamics GP. The built in macro process to import fixed assets is one example. Other times, companies find that macros allow them to avoid security hassles and data concerns by not loading directly to SQL tables.

We cover how to build macros for importing data in both the GP 2010 and GP 2013 Cookbooks.

It’s also not unusual do load data via a macro using Terminal Server or Citrix. There are a couple of things to be aware of though.
If you run a macro from your computer with GP installed on the computer, you are effectively typing (really fast and automatically but still typing) into GP. You won’t be able to use your computer while the macro is running.

Most people get that instinctively. With Terminal Server, you are actually running the process on a server somewhere. It’s a different computer so you should be able to use your local computer while it’s running and just keep an eye on it, but it doesn’t always work that way. This is how you make it work.

•If you run Terminal Server in full screen mode, when you minimize to move to your local machine the macro will stop. The answer is to run Terminal Server in a window, then start the macro. This will let you tab off and do other things while the macro is running. In the corner of the window is a dash, a framed box and an X. Click the framed box to pull TS out of full screen mode.

•If you run the Terminal Server session in a window, your local screen saver won’t make any difference. If the terminal server session has a screen saver you’ll want to disable it. If it kicks in it will stop the macro. I’ve seen cases where the TS screen saver is controlled by group policy and can’t reasonably be turned off. Someone has to sit there and shake the mouse every 10 minutes or so. It’s not ideal. See if you can get it disabled.

There are times when a macro makes sense and there are times when you need to use other tools like Integration Manager, SmartConnect or SQL. It’s helpful to know how to get the most out of all of the tools.

Post has attachment
Weekly Dynamic: Undo All Depreciation.

Versions of GP prior to GP 2013 will let you undo depreciation for a single asset. If you accidentally depreciated land, this is an easy fix.

GP 2013 adds a checkbox to undo depreciation for all assets or for a group of assets. It's really easy. In the depreciation box just check all assets or pick a group, check Reverse depreciation and pick your books.

So if the tax department disagrees with how you setup certain assets for tax you can undepreciate them and rerun depreciation. Pick any scenario, asset wasn't in service, asset shouldn't be depreciated, wrong life, wrong method, this is a great fix for any of those.

n me, Belinda, Mariano and Microsoft’s Jared Hall at the Live Event: July’s Microsoft Dynamics GP Expert Roundtable tomorrow. We’ll be hanging out and talking GP.

Post has attachment
My newest book, Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 is out! It was released by Packt Publishing late last week. In the book we work together to build a Financial dashboard with Microsoft Excel using live data from Dynamics GP. If your CEO, CFO or other CxO is asking for a dashboard, this is the place to start with a step by step walk through.

Building Dashboards is available through and Packt Publishing. Barnes & Noble doesn’t have it yet. They are a little slower to get things added to their catalog.

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded