Dynamics GP On-Demand Learning: Word Template Tips


Excellent post on Dynamics GP Support & Services blog that walks us through GP Word Templates.

This was the last post in the series named Microsoft Dynamics GP On Demand Learning Series.

Sincere thanks to GP Support Team, for posting these articles. Highly informative.

VAIDY

OFF-TOPIC: Word for Mac 2011 – Print Area Cut Off Issue & Solution


It’s high time I blog about this. Those who are on Mac and use MS Word for Mac, this is going to be real time saver.

Let me brief the issue first. Whenever I create a document with a header/footer and when I try to save this document as PDF, I use to get following message:

Screen Shot 2014-12-17 at 12.33.11 PM

If I continue with “Yes”, it will cut the footer off and give me an incomplete document.

As usual, googled this and got too many solutions/workarounds, but only one solution actually helped me. It’s a YouTube video uploaded by Matt Fuller:

Thanks Matt.

VAIDY

OFF-TOPIC: Change Power Button Behaviour in OS X Mavericks


Whenever I accidentally press the power button on my MacBook, it switches off the display. This behaviour change happened from OS X Mavericks (10.9).

Earlier it used to let us choose with following options:

Power Button Options

OSXDaily.com has got a workaround for this trouble. It does not straightaway enable these options the moment you press the power button, but it prevents OS X Mavericks from switching the display off, which is far more relieving.

To invoke the above power button options: press power button continuously for a second or two.

Thanks OSXDaily.com.

VAIDY

OFF-TOPIC: Show Hidden Files & Folders in Mac OS X Mavericks


I had been struggling with this for sometime. I wanted to create a USB installer for Mavericks and was not able to get thru’ a step where I had to show hidden files and folders.

In Windows OS, it’s a simple step which is available graphically to either show or hide hidden files and folders. But in Mac OS X, for some reason, this has to be achieved by typing a command on Terminal. Following is the command that is required to enable showing hidden files and folders:

defaults write com.apple.finder AppleShowAllFiles TRUE
killall Finder

So, those who struggle to get it done, above is your key to unlock this.

VAIDY

Integration Manager – Troubleshooting & Testing Tips: Dynamics GP Support & Services Blog


Highly informative post on Dynamics GP Support & Services blog on Common Tips and Issues when Troubleshooting and Testing Integrations in Integration Manager.

I have never read such an expansive post on Integration Manager (IM) ever. Mariano touches specific issues, David (and his technical team) on his blog shares specific topics. But this one’s so very expansive and one stop guide to IM issues and tips.

Bookmark this for your future reference.

VAIDY

OFF-TOPIC: Increase Productivity By Adding Shortcuts To “Send To”


I often copy my chunk file on to GP application folder as part of my development work, so I must keep two explorer windows open always. Copy from my development folder and paste it on to GP application folder. Difficult and frustrating (at times) to shuttle between two folders every time.

Not anymore; I just created new shortcuts to Send To menu as shown below:

Snip20130213_2

Just select my chunk file from my development folder, invoke Send To menu and send it straight to GP application folder. Awesome, isn’t it? It is, indeed. It saves almost 15-30 minutes a day depending how many times you perform copy paste with same source and destination folders.

Follow the steps explained in this blog post: How to add SkyDrive shortcut into your ‘Send To’ Menu.

The post discusses on how to add a shortcut for Skydrive, but it’s the same steps that you have to follow for any shortcut (internally on your computer or an external location).

I assure you that this trick alone would save you tremendous amount of time and effort in a day.

VAIDY

OFF-TOPIC: Snip For Mac OS X – A Snipping Tool Alternative


This is another off-topic. But I wanted to highlight this most handy application called Snip, developed by Tencent Technology (Shenzhen) Company Limited and is also available on Mac App Store.

Snip20130209_1

Those PC users, who also used to be Snipping Tool dependants, and then became Mac OS user, would love to have an application in Mac OS X which would compensate Snipping Tool’s absence.

I used to crib about the lack of an application that I would use to do screen capturing and post-processing those captures. This tool Snip, which I came to know very recently, has done what other applications on Mac platform couldn’t.

We have built-in capturing commands in Mac OS X, such as SHIFT+CMD+4 (to capture a portion of screen), but those commands would simply take the screenshot and immediately save it on your desktop. You then have to reopen it on some other graphics tool to post-process it, such as narrating or simply painting on some text which you do not want to show to others.

This tool is amazingly simple and does exactly what you need. It just sits on that menu bar with a customisable keyboard shortcut to invoke a screen capture.

Go to the official website (link is provided in the beginning of this post) and know more about it.

Trust me, you would most certainly fall in love with this application, if you do tons of screen capturing on your day-to-day Mac OS usage.

UPDATE: There is one more app that is FREE on Mac App Store; named Share Bucket. I think it’s a serious competitor for all currently available apps.

VAIDY

Infamous “Sales distribution amount is incorrect” Error


I received an email from one of my users seeking my help in clearing this issue. While posting an invoice, this error message popped up:

SDE-01

 

Upon running the Edit List for this invoice, I realized that it was due to an imbalance in Markdown Amount and corresponding distribution line. Below was the error report that I got:

SDE-02

There seemed to be Markdown entered on one or more line item(s), but there was no distribution line for that amount. But the issue was not THAT simple and didn’t stop there.

When I ran thru’ all line items, none contained a Markdown. Now that’s the problem. After some minutes of thinking, I realized something must be stranded on header record’s Markdown field, for which GP requires a Markdown distribution line, but since line items do not contain any Markdown, it’s not creating one. Strange.

I decided to query the records from SOP10100 (SOP Header) and SOP10200 (SOP Line) to understand the issue. Below is what I found:

SDE-03

SERIOUSLY…?!?!?!?!

But yes, that was the issue. And most baffling thing is, when I tried to reconcile this sales document, this major mishap didn’t get cleared at all.

Obvious solution for this abnormal situation is as follows:

1. Take backup of this SOP10100 record.

2. Update Markdown fields with ZERO.

3. Reconcile this sales document again to see if the above update had caused any imbalance.

Happy new year and happy troubleshooting…!!!

VAIDY

Quick SQL Tip: Keyboard Shortcut for Database Selection in SQL Server 2012 SSMS


Till SQL Server 2008 R2, if you want to change the database on which you would like to execute a SQL query in SQL Server Management Studio (SSMS), the keyboard shortcut to do so was CTRL + U from the query window.

Now from SQL Server 2012, it is CTRL + ALT + J.

So those who tried this using the old shortcut, keep in mind that the new shortcut.

VAIDY

Performance Issue with Received/Not Invoiced Report in POP


Angela Ebensteiner (Technical Lead, Microsoft Dynamics) share a fix on Microsoft Dynamics GP Support blog for the performance issue with Received Not Invoiced report in Purchase Order Processing (POP).

To brief you here on why this performance issue occur, it’s because of huge pile of PO records staying on POP open tables, even after they are closed. When you run the report, it goes through each and every record on POP open table, due to which you got to wait for some time till query processing finishes.

Fix is to remove completed POs from open tables to history, which we have a standard utility available in GP.

VAIDY