Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

#TipTuesday series

  • 1.  #TipTuesday series

    GPUG ALL STAR
    Posted 01-23-2018 09:19 AM
    Last week I started a #TipTuesday series where I will blog about a relatively simple (meaning: doesn't take hours to write!) blog post about a tip around an underused feature, things I think would be helpful or general small tips. Most will be around Dynamics GP but some might be peripheral to GP like SQL or Excel if I start running out of ideas! :)

    I'll try to remember to post the links here each week.

    Last week's was tips around Dates in GP:
    https://jenkuntz.ca/2018/01/tips-for-dates-in-dynamics-gp/

    Today's is writing off small customer balances:
    https://jenkuntz.ca/2018/01/write-off-small-customer-balances/

    I've got topics written and ready up to Feb 6th and a laundry list of topics I want to get in the series. If you have ideas for other tips, feel free to comment below!

    Thx
    Jen

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------


  • 2.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 02-06-2018 08:51 PM
    I forgot to update this last week. Here's last week and today's #TipTuesday blogs!

    https://jenkuntz.ca/2018/01/clear-recurring-batch-amounts/

    https://jenkuntz.ca/2018/02/reverse-fiscal-year-end-close/

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 3.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 02-27-2018 07:07 PM
    Edited by Marghet Hager 02-27-2018 07:18 PM
    3 more #TipTuesday posts for y'all. I keep forgetting to update the this each week :)

    https://jenkuntz.ca/2018/02/account-maintenance-options/

    https://jenkuntz.ca/2018/02/assigning-an-item-to-multiple-sites/

    https://jenkuntz.ca/2018/02/tips-for-refreshing-a-test-company/

    Enjoy!​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 4.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 03-06-2018 06:08 PM
    Believe it or not, it's Tuesday and I have remembered to post my latest #TipTuesday post here on time! hahaha

    Multicurrency troubleshooting tip
    JenKuntz.ca remove preview
    Multicurrency troubleshooting tip
    Today's #TipTuesday post is a small tip, something to watch for if you have a G/L Account in Dynamics GP that is revaluing month after month despite having a zero balance in your functional currency. Nearly 20 years ago, I worked for a company that did a lot of transactions in multi-currency and we revalued our A/R and A/P control accounts each month, among others.
    View this on JenKuntz.ca >


    Jen​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 5.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 03-14-2018 08:33 AM
    I'm running out of excuses for why I keep forgetting to post my latest tip here on an actual Tuesday. :)

    Oh well!

    This week's #TipTuesday is a simple one but a good one if you use serial numbers.

    Multi-select serial numbers
    JenKuntz.ca remove preview
    Multi-select serial numbers
    Today's #TipTuesday is a short one. Did you know you can multi-select Serial Numbers in Dynamics GP? Yes, this was a minor feature added in GP 2015 and allows a user to select multiple serial numbers instead of clicking and inserting one at a time. In my example below, I'm specifically selecting random, non-sequential numbers.
    View this on JenKuntz.ca >

    ​​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 6.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 04-10-2018 05:24 PM
    Wow, time flies when you're having fun. It's been 4 weeks and I've missed posting 4 tips! I really need a reminder in my calendar!

    View options for multicurrency

    Currency symbols in Dynamics GP

    Unnecessary restrictions in report options window

    Miscellaneous Check doesn't support multicurrency

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 7.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 04-30-2018 11:23 PM
    Look at that, I'm behind again. This time I'm posting this on Monday so most of you may see this on Tuesday. I fall behind because I schedule my posts and write them in advance but you can't schedule posts here... and I forget. Doh...

    Some more tips from the last 3 weeks:

    Reset Home Page

    Upgrade your company names!

    and tomorrow (Tuesday's) post, will be visible at 7am EST May 1st:
    Forcing a SQL login in Web Client



    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 8.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 05-15-2018 08:53 PM
    2 more #TipTuesday's for you all...

    https://jenkuntz.ca/2018/05/what-does-web-client-user-only-do/

    https://jenkuntz.ca/2018/05/unassigned-security-report-superuser-roles/

    Enjoy!​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 9.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 05-29-2018 09:02 PM
    Here are a couple more #TipTuesday blogs ...

    https://jenkuntz.ca/2018/05/launching-gp-with-alternate-dynamics-set-file/

    https://jenkuntz.ca/2018/05/tax-schedule-tip/

    Jen​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 10.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 06-26-2018 07:45 PM
    Here's the last 4 weeks of #TipTuesday blogs for y'all! This covers every tip from the month of June that I posted!

    https://jenkuntz.ca/2018/06/sample-sql-views-for-smartlists/

    https://jenkuntz.ca/2018/06/user-preferences-tips/

    https://jenkuntz.ca/2018/06/navigation-pane-options/

    https://jenkuntz.ca/2018/06/remote-desktop-multiple-monitors/​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 11.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 07-11-2018 10:20 AM
    It's the Wednesday edition of #TipTuesday ;)

    I was on vacation last week so didn't get a chance to post last week's tip, and then completely forgot about yesterday's tip!

    Both tips are Lookup window related things. Enjoy!

    https://jenkuntz.ca/2018/07/hidden-shortcut-on-item-lookup-window/

    https://jenkuntz.ca/2018/07/lookup-window-tips/

    Jen

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 12.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 07-17-2018 09:08 AM
    Today's #TipTuesday post is how to remove the day of the week from Management Reporter!

    https://jenkuntz.ca/2018/07/getting-rid-of-day-in-mgmt-reporter-date-format/



    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 13.  RE: #TipTuesday series

    TOP CONTRIBUTOR
    Posted 07-19-2018 11:27 PM
    Love #TipTuesday.  I am curious if you have used Power BI on the GP Home Page or know of anyone using this feature and how that is working.​

    ------------------------------
    Amy Brown
    Consultant
    S2 Technology
    Boise ID
    ------------------------------



  • 14.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 07-20-2018 11:24 AM
    Thanks @Amy Brown! It's always good to hear when people are finding this useful!

    Re: PowerBI on the home page, I haven't done much with that yet but I would look at @Shawn Dorward's blog series on this topic:

    https://gplifehacks.com/dynamics-gp-power-bi-gp2018rtm/

    It's an excellent series on the whole thing!

    Jen​​​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Solutions)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 15.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 07-31-2018 10:11 AM
    Two more #TipTuesday's for y'all!

    Last week's tip is around #SSRS permissions, specifically Report Builder:

    https://jenkuntz.ca/2018/07/ssrs-2016-report-builder-permissions/​​
    Today's tip is around year end close and a question that was posted recently and answered by Victoria Yudin (tagging isn't working for some reason!):

    https://jenkuntz.ca/2018/07/retained-earnings-account-is-inactive-error/
    ​​
    Jen

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 16.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 08-07-2018 09:22 PM
    Today's #TipTuesday is about the new (not soooo new though) Budget Transactions feature and why you may use it.

    The blog title is a bit misleading but now that it's published I am not going to change it!

    https://jenkuntz.ca/2018/08/budget-transactions-vs-budget-upload/



    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 17.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 08-14-2018 04:03 PM
    Today's #TipTuesday post is about sending messages to users within GP.

    Like last week, not a "new" feature as it's been around since GP 2013 R2, but a quick one to post a tip on!

    https://jenkuntz.ca/2018/08/send-message-to-users/



    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 18.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 08-21-2018 04:18 PM
    Today's #TipTuesday may not apply to everyone but if you run local instances of SQL for testing or demos, check this out. A small time-saver.

    https://jenkuntz.ca/2018/08/start-stop-sql-by-batch-file/


    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 19.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 09-05-2018 08:10 PM
    Hello again! Here's the last couple #TipTuesday posts I've made... I forgot to post here last week!

    What user permissions are required for GP Utilities if you just need to install workstations:
    https://jenkuntz.ca/2018/08/gp-utilities-user-permissions/

    A non-GP post: Flash Fill, what it is and a couple of uses for it. LOVE this feature in Excel!
    https://jenkuntz.ca/2018/09/flash-fill-in-excel/​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 20.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 09-11-2018 08:22 AM
    ​Today's #TIpTuesday post is a follow up to my GP Utilities minimum user permissions post from a couple of weeks ago, and it relates to questionable advice on permissions for GP Utilities users.

    https://jenkuntz.ca/2018/09/gp-utilities-user-permissions-part-2

    Jen


    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 21.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 09-25-2018 09:49 PM
    Here are the last couple of #TipTuesday posts:

    Excel tip: copy and pasting unique values:
    https://jenkuntz.ca/2018/09/excel-tip-copy-paste-unique-values/

    Today's post: setting up Advanced Lookups in GP
    https://jenkuntz.ca/2018/09/advanced-lookups/

    Jen​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 22.  RE: #TipTuesday series

    TOP CONTRIBUTOR
    Posted 09-27-2018 10:16 AM
    @Jen Kuntz I consider myself an Excel junkie and your #TipTuesday for the list of unique values just made my day! Thank you so much for these posts. ​​

    ------------------------------
    Tiffany Ziegler
    Vice President & Controller
    Velcor Leasing Corporation
    Madison WI
    ------------------------------



  • 23.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 09-27-2018 01:05 PM
    Thanks @Tiffany Ziegler! I love hearing that!​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 24.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 10-02-2018 10:17 PM
    Today's #TipTuesday is on an unrelated to GP topic: 2FA / MFA authentication (2 factor/multi factor). I'm going to do at least one more probably two Tip Tuesday posts on how to set it up with some common providers. Stay tuned!

    https://jenkuntz.ca/2018/10/two-factor-authentication-part-1/



    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 25.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 10-09-2018 09:10 AM
    Today's #TipTuesday is a "part 2" of the two-factor authentication post I started last week.

    I changed my tune, I'm not going to recreate the steps and create my own documentation on "how to" use 2FA with the various websites and services as it was taking forever to do. If anyone has challenges with 2FA though, feel free to start a discussion here or comment on my blog posts and I'll help where I can.

    https://jenkuntz.ca/2018/10/two-factor-authentication-part-2/

    Jen​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 26.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 10-16-2018 09:30 AM
    Today's #TipTuesday is a little on a "simpler" side but relevant this week:

    How to follow a conference or event like GPUG Summit via Twitter when you're not a Twitter user (and have no interest in joining Twitter!).

    https://jenkuntz.ca/2018/10/how-to-follow-a-conference-or-event/

    Enjoy!​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications)
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 27.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 10-30-2018 12:38 PM
    Yet again, I missed posting last week's #TipTuesday!

    Last week I posted a tip around taking a company offline for maintenance or year-end close situations.

    https://jenkuntz.ca/2018/10/take-company-offline/

    Today I posted a non-GP tip, using a Windows 10 feature to use a 2nd PC like a Surface, as a second monitor in a pinch.

    https://jenkuntz.ca/2018/10/connecting-a-2nd-pc-as-a-second-monitor/

    Enjoy!
    Jen​

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 28.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 11-06-2018 07:06 PM
    Today's #TipTuesday is about My Reports in GP:

    ​https://jenkuntz.ca/2018/11/my-reports-in-gp/

    Enjoy!

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 29.  RE: #TipTuesday series

    TOP CONTRIBUTOR
    Posted 11-07-2018 12:37 PM
    ​Awesome tips @Jen Kuntz! Keep them coming. 8-)​

    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------



  • 30.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 20 days ago
    2 more posts for #TipTuesday.

    ​https://jenkuntz.ca/2018/11/getting-a-list-of-write-offs/

    https://jenkuntz.ca/2018/11/getting-a-list-of-write-offs-follow-up/

    Enjoy!

    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 31.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 14 days ago
    Today's #TipTuesday is all about AutoComplete in Dynamics GP.

    https://jenkuntz.ca/2018/11/autocomplete-tips/


    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 32.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 7 days ago
    OMG I can't believe I have managed to keep posting a tip a week this entire year... some "low-hanging fruit" in the mix but hey, sometimes that's all I've had time to get done!

    This week's tip is about the Copy Journal Entry feature and I'm following it up next week with Backout & Correct Journal Entry.

    https://jenkuntz.ca/2018/12/copy-journal-entry

    Both are very much "not new" features (introduced in GP 8 or earlier) but they are still underutilized at times!

    Jen






    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------



  • 33.  RE: #TipTuesday series

    GPUG ALL STAR
    Posted 4 hours ago
    Today's #TipTuesday is the "cousin" of last week's copy JE feature: backing out and correcting JE's...

    https://jenkuntz.ca/2018/12/backout-or-correct-journal-entry/


    ------------------------------
    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
    Manager, Business Solutions
    Energy+ Inc.
    Cambridge, ON, Canada
    ------------------------------