You get the LESLIE VAIL Badge if you can answer this!

  • You get the LESLIE VAIL Badge if you can answer this!

    Posted by DSC Communities on March 6, 2017 at 5:37 pm
    • Steve Erbach

      Member

      March 6, 2017 at 5:37 PM

      Dear Collaborators,

      Since Leslie doesn’t visit the GPUG Forums every day, I’d like to float this out there to find out if any of you can play Leslie on TV for today!

      Our Controller is quite frustrated with a particular “feature” of the Payables module. That is, when there is a Vendor credit of, say, $1000, we wish that GP would not automatically apply it when we write checks. We would like to hold onto that credit until we can apply it to an A/P check or EFT that equals or exceeds the amount of the credit… and have the remittance show that we had $1000 in Vendor credit and we used it against this group of 12 invoices that totaled $1500… so our net payment is $500… and the remittance would show the credit at the bottom of the list of invoices that we’re paying.

      The way GP works now is that when we make a check run and we only have an invoice for $200 for that Vendor, GP doesn’t write a check for that Vendor. It records that the credit is reduced to $800. Then the next time we have a check run for, say, $1200, a check is written for $400… but the remittance doesn’t show the credit amount, and the Vendor calls us asking why we short-paid.

      Is there a way to tell GP to quit it with the automatic deduction from a check? We want to control when we use a Vendor credit, and we’d like to see it recorded properly on the remittance.

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————

    • Tammy Chavez

      Member

      March 6, 2017 at 5:44 PM

      HI Steve,

      When you are building your check batch you can tell GP not to Auto Apply payments / credits / returns.  

      ——————————
      Tammy Chavez
      Senior Software Consultant
      LightHouse Business Information Solutions, LLC.
      Albuquerque NM
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 9:17 AM

      Tammy,

      Whoa! Is it that simple? My accounting peeps are going to be so embarrassed!

      You included a nice screen shot like Leslie would, too! For that you win the coveted Leslie Vail Badge!

      QzF1q9TgTEWCg624RNXT_LeslieVail.gif

      One more thing: there aren’t any default settings one could change, are there? Or must one un-check the box(es) for every batch?

      Thank you!

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Tammy Chavez

      Member

      March 7, 2017 at 10:52 AM

      HI Steve,

      That is how I teach my clients to not have prepayments/credits/returns auto applied. Unfortunately there is no setup window to keep that setting as default.  I love Amber Bell’s answer too!  That is a great solution.  

      Thank you for the honor giving me the Leslie Vail badge for the day!  🙂

      Sincerely,

      ——————————
      Tammy Chavez
      Senior Software Consultant
      LightHouse Business Information Solutions, LLC.
      Albuquerque NM
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 12:28 PM

      Tammy,

      You are most welcome.

      I see that the prospect of winning the Leslie Vail badge has brought out the best in everybody! She has that effect on people!

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Tammy Chavez

      Member

      March 6, 2017 at 5:46 PM

      You have to uncheck the highlighted boxes.  Sorry hit enter before i was done.  🙂

      ——————————
      Tammy Chavez
      Senior Software Consultant
      LightHouse Business Information Solutions, LLC.
      Albuquerque NM
      ——————————
      ——————————————-

    • Shawn Dorward

      Member

      March 7, 2017 at 9:31 AM

      Steve,

      There is no default settings for those settings…. unfortunately!

      Modifier doesn’t help either (if memory serves me correctly).  A macro combined with extenders auto run does a nice job – I’ve used this work around before and it works nicely.

      ——————————
      Shawn Dorward
      Twitter: @ShawnMDorward
      Implementation Consultant
      InterDyn Artis
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 12:30 PM

      Shawn,

      Some of our users make use of macros… this looks like a perfect application for one.

      P.S., I still have my “Move Forward with Dorward” sign!

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Amber Bell

      Member

      March 7, 2017 at 9:30 AM

      I would recommend putting the Credit Memos and Payments on-hold. On-Hold transactions do not automatically apply!

      Purchasing > Transactions > Holds

      nBFTRM9cThqNh27rWz9j_AP Hold.JPG
      or….my favorite…setup a Navigation List to place these on hold:

      XNUbdJaTQQuXk0mBXZPM_AP Navigation List.JPG

      ——————————
      Amber Bell
      Training Dynamo LLC
      Email: amber@trainingdynamo.com
      Website: http://www.trainingdynamo.com
      Twitter: @trainingdynamo
      ——————————
      ——————————————-

    • Tom Monfre

      Member

      March 7, 2017 at 10:17 AM

      Steve,

      This is a good example of how you can preset GP screens when there is no setup option for setting default values.  With just a few lines of code, you can use Visual Studio Tools to create an AddIn that will set screen defaults that you may want.  The attached zip file contains source code and a compiled DLL that will automatically uncheck the three boxes mentioned above.  All you have to do is copy the UncheckSelectPayablesChecks.dll file to your GP AddIns folder.  Please review the source code to see just how easy this is and to make changes that you may want.

      ——————————
      Tom Monfre
      Batteries Plus Bulbs, LLC
      Hartland WI
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 12:33 PM

      Tom,

      I don’t believe that we purchased the VS Tools for our installation. We have no spare development resources to devote to GP.

      Do we need to have VS Tools in order to make use of that DLL? Otherwise I will put it through its paces on our TEST server.

      Thank you,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Tom Monfre

      Member

      March 7, 2017 at 12:48 PM

      I may be wrong Steve but I think VS Tools is included with GP.  I’ll defer to someone else to make sure.  Anyway, you don’t need VS Tools to use the DLL included in the ZIP file.  Copy it to your test server and when you’re ready, copy it on all GP computers that require this.  We keep all computers including Terminal Server the same but you’re not required to do that.

      ——————————
      Tom Monfre
      Batteries Plus Bulbs, LLC
      Hartland WI
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 1:48 PM

      Tom,

      Thank you, I will install it on our TEST server.

      I see you’re registered for the Milwaukee Chapter meeting. I’ll see you tomorrow!

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 8, 2017 at 6:30 PM

      I was able to speak with Tom Monfre face-to-face at today’s Milwaukee Chapter meeting (my report here). In support of his solution, using a DLL he wrote with Visual Studio Tools — he figured that his solution was the easiest to set up since it just involves dropping the DLL in the GP Addins folder and letting GP recognize it and incorporate it into its startup process. Then, when the user lands on that Batch page, the check boxes are all automagically UN-checked. No muss, no fuss, no macros, even.

      For that, I’m awarding Tom a LESLIE VAIL badge, too!

      Lb1COh9SamkD6iBSBX8S_LeslieVail.gif

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Pamela Stephenson

      Member

      March 9, 2017 at 9:04 AM

      Just to offer up, the simple solution we do.  We don’t automatically apply credits when we build our check batches.  There aren’t that many credits, that we have, so we can evaluate the check batch once it is built, to see if we want to apply the credit or not.  No programming or modifications, required.

      ——————————
      Pamela Stephenson
      Director of Accounting and Finance
      Ashley Ward, Inc.
      Mason OH
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 9, 2017 at 10:03 AM

      Pamela,

      >> We don’t automatically apply credits when we build our check batches <<

      Right… but doesn’t that mean that you UN-check the appropriate check boxes under “Automatically Apply Existing Unapplied”? There doesn’t seem to be an option in native GP to set those check boxes to UN-checked by default.

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Sheila Jefferson-Ross

      Member

      March 14, 2017 at 2:50 AM

      Hi Amber,

      I really like your suggestion to setup a navigation list to see the credits that are open and either put them on hold or remove hold from there.  Credits are not easy to see without printing an entire trial balance and then you have to deal with the credits. I will be sure to pass that along to clients.

      Blue Moon has a product called Enhanced Voucher Selection that handle the credits in a better way and makes the method of selecting vouchers easier. Their check stub inquiry also shows exactly what was paid or applied on the check which is not available in standard GP.

      Thanks,
      Sheila

      ——————————
      Sheila Jefferson-Ross
      Senior Consultant
      Socius-AASG
      Rocklin CA
      ——————————
      ——————————————-

    • Amber Bell

      Member

      March 7, 2017 at 10:31 AM

      I just wanted to add…in support of my answer (and the contest for winning a Leslie Vail (my hero/the person who taught me GP) Badge!

      Placing the Payment or Credit Memo on hold will also prevent it from accidentally auto applying if you use the Edit Check Batch feature. This window also Auto Applies open Credit documents if they are not on hold (if you check the box by the Vendor)

      I had a client with this same issue, they just used Navigation Lists to control the holds and it worked beautifully! The issue with relying on changing the “Select Checks Window” is that many users utilize other windows to pay vendors. The Holds option protects from accidental application no matter how you pay your Vendors!

      Here is what happens if you check the box by the Vendor in the Edit Check Batch window and the payment or Credit is not on hold….it gets auto applied.

      7kHk9YqGSTmvuA7k0ill_AP Auto Apply.JPG

      ——————————
      Amber Bell
      Training Dynamo LLC
      Email: amber@trainingdynamo.com
      Website: http://www.trainingdynamo.com
      Twitter: @trainingdynamo
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 12:36 PM

      Amber,

      You definitely qualify for the LESLIE VAIL Badge!

      E74P0NEkT66nRYaIVTjj_LeslieVail.gif

      Thank you very much. I will run these past our Controller and our A/P lady.

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Bert Green

      Member

      March 8, 2017 at 9:10 AM

      Or if it will take a long time to get enough invoices to cover the credit memo you could put the vendor on hold and not pay any invoices until you have enough to cover the credit memo.

      Then setup a smartlist to show vendors on hold and what their balance is so it is easier to know when to take them off hold.

      ——————————
      Bert Green
      GP Developer/GP Administrator
      Berger Transfer & Storage, Inc.
      Saint Paul MN
      GP2015/MR CU11
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 8, 2017 at 6:31 PM

      Thanks, Bert. It’s excellent to have so many possibilities where we were stuck before.

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Jeff Martin

      Member

      March 7, 2017 at 12:05 PM

      6qegQ2FTx6CTlvGiHu7D_Remittance.png

      Hi Steve,

      You have gotten some great answers to the main issue of stopping GP from auto applying credits.  Kudos to all who replied.  Like Tom I’m a big fan of presetting forms with the default settings that work best for our users.  I use VBA instead of Visual Studio but the end result is the same, less mistakes and more efficient users.

      It seems that your secondary request of a more vendor friendly remittance form has not been addressed.  Holding or not applying the credits until they can be applied in full reduces the confusion because it makes it easy to understand where the credits are applied.  Unfortunately there are times when it is desirable to apply a portion of the credit.  When this happens the default remittance form layout makes it difficult to determine where the credit has been applied.  So we have redesigned our remittance form to be more vendor friendly.  This layout works well for us.  You may need to tweak it until it has the WOW you are looking for.

      ——————————
      Jeff Martin
      Director of IT
      DeRosa Corporation
      Wauwatosa WI
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 7, 2017 at 12:37 PM

      Jeff,

      Hmmm… I never thought of re-designing the remittance form. Makes sense. Thank you!

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Kris Elliott

      Member

      March 7, 2017 at 3:05 PM

      I too have been plagued by this frustrating “feature” in GP.  The way I’ve worked around it in the past is to make the invoice selection(s) for the vendor with an unapplied credit, then deselect the invoices, thus removing the auto-applied credit, and then reselect the invoices I wish to pay.  The credit does not auto-apply the second time.  Total pain in the you know what but thankfully we never really have many unapplied credits.  But I am so going to use Amber’s suggestion!  Much less hassle and since we use the Edit Check Batch feature, this will work perfectly!!

      Totally jumped on the message board to search for something else we are having an issue with can came across this topic.  Totally worth it! Really need to spend more time on here.

      ——————————
      Kris Elliott
      Controller
      Ovation Fertility
      Encino CA

      “You can take the girl out of WI but you can’t take the WI out of the girl”
      ——————————
      ——————————————-

    • Beat Bucher

      Member

      March 8, 2017 at 9:30 AM

      Wait Wait..
      Such a long thread without me !!! how come ?
      Just kidding.. 🙂  That was a great discussion and I surely will pass that along to our AP/AR person to see if there is any interest in applyig the suggestions. Thank you Steve for posting the original question.
      Have a great week all !

      ——————————
      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      +1-514-489-4267
      @GP_Beat http://dyngpbeat.wordpress.com/
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14
      ——————————
      ——————————————-

    • Kathy Kim

      Member

      March 8, 2017 at 10:25 AM

      Ditto (such a long thread without me 🙂 AND great discussion!).  This has been a pain point, but not a “make it to the top of my list” pain point.  Now I have several suggestions to consider and implement (especially since I currently have a temporary in-house consultant to make all of our dreams come true.  :-))

      ——————————
      Kathy Kim
      Director of Finance
      Donor Network of Arizona
      Phoenix AZ
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 8, 2017 at 6:36 PM

      Kathy,

      >> (especially since I currently have a temporary in-house consultant to make all of our dreams come true.  :-)) <<

      That’s an interesting question-begging statement. Do tell!

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Kathy Kim

      Member

      March 9, 2017 at 9:18 AM

      Simply put – i am the default GP admin which has become an issue in balancing my “Director of Finance” duties with my “Something isn’t working in GP” duties.  We use and independent consultant for issues I can’t solve, upgrades, etc.  We also use our partner for some support, etc.  Recently, my GP project list has grown and our independent consultant’s time is spread among many clients.  SOOOOO – as the Director of Finance, I added a consultant to the budget that is dedicated to me, me, me!  I have 3 months to get through a stack of projects, finish the upgrade our other consultant started (and has been waiting for my attention for 4 months) and so much more!  All my dreams come true!

      ——————————
      Kathy Kim
      Director of Finance
      Donor Network of Arizona
      Phoenix AZ
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 9, 2017 at 9:43 AM

      Kathy,

      Sounds like you’re going to be a busy lady for the next few months! Best wishes!

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Kathy Kim

      Member

      March 9, 2017 at 9:51 AM

      Sparkly Steve – hopefully the consultant will be busy and I’ll just push buttons and have everything work!  🙂  HA!  

      ——————————
      Kathy Kim
      Director of Finance
      Donor Network of Arizona
      Phoenix AZ
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 8, 2017 at 6:34 PM

      My pleasure, Béat! I feel such guilt that this thread didn’t involve you (and Kathy!) right away!

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • David Musgrave

      Member

      March 9, 2017 at 2:26 AM

      Just posting on the thread because I want a Leslie Vail badge….

      Hope you found this information useful

      David

      ——————————
      David Musgrave MVP, GPUG All-Star

      Managing Director
      Winthrop Development Consultants

      Perth, Western Australia

      http://www.winthropdc.com
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 9, 2017 at 9:42 AM

      David,

      Actually, there needs to be a separate DAVID MUSGRAVE badge for answers that live up to the astonishingly high technical standards you employ. I’m thinking something along the lines of your avatar… or that cool Australia pin you gave me at your GP Power Tools Academy course at Summit in Reno:

      N3o3g00pTe26VcoiXyhD_Ozpin.jpg
      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Leslie Vail

      Member

      March 10, 2017 at 1:27 AM

      LOL!!
      This is so funny! Thank you Sparkly. This has been a long day and I can’t tell you how incredible this makes me feel. What a fabulous way to end the day. I’m definitely putting this in my Feel Good File. I’m gonna have to get a new hat! My face hurts because I’m smiling so big. You guys are the BEST!
      Kind regards,
      Leslie

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    • Verone Leimer

      Member

      March 10, 2017 at 8:43 AM

      I’m a little late to the table on this one, but Blue Moon’s Enhanced Voucher Selection product is an inexpensive add-on that replaces/enhances GP’s Select Checks and one of it’s features is the ability to unmark the “Automatically Apply Existing Unapplied” boxes as a default setting.  It has several other features that we like a lot better than GP’s Select Checks, especially how easy it makes it to do partial payments.  It’s brilliant.

      Verone

      ——————————
      Verone Leimer
      Shareholder/Dynamics GP Practice Leader
      Run Business Solutions
      Amarillo TX
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 10, 2017 at 9:28 AM

      Thank you, Verone. That is yet another option. We’re going to implement the Purchase Order system in GP Real Soon Now. We may find that we need something a bit more flexible in this area.

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 10, 2017 at 9:25 AM

      Nobody smiles like you, Leslie!

      JoOlaA7rSGeiJPdEvzXa_LeslieAndMe.jpg
      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Kim Peterson

      Member

      March 10, 2017 at 8:40 AM

      I wish I knew GP like Leslie.  I want a LESLIE badge!

      ——————————
      Kim Peterson
      InterDyn BMI
      218-862-5002
      Kim.Peterson@InterDynBMI.com
      #KimPetersonBMI
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 10, 2017 at 9:32 AM

      Kim,

      This from the lady who should have a statue dedicated to her at GPUG HQ!

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Beat Bucher

      Member

      March 10, 2017 at 1:39 PM

      Great PlainsLet’s roll the RED carpet in Nashville at next GPUG Summit with a golden statuette !! #NewGPUGaward
      #GoldenGPUGglobe

      ——————————
      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      +1-514-489-4267
      @GP_Beat http://dyngpbeat.wordpress.com/
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14
      ——————————
      ——————————————-

    • Steve Burney

      Member

      March 10, 2017 at 2:00 PM

      Hey Beat – I will look and see where we can find some red carpet here in Nashville.

      We are really looking forward to everyone being here in Nashville in October for Summit 2017!
      I will posting soon some information on different places to go and see in Nashville while everyone is here.

      Steve

      ——————————
      Steve Burney
      Senior Financial Systems Administrator
      Correct Care Solutions
      Nashville, TN United States
      sburney@correctcaresolutions.com
      615-312-7272
      Twitter @SteveBurney
      ——————————
      ——————————————-

    • Frank Heslin

      Member

      March 10, 2017 at 2:07 PM

      This whole post just sums up how GREAT this community is, and why it’s the #BestUserGroupEver !

      ——————————
      Frank Heslin
      Financial Systems Administrator
      ExamWorks, Inc.
      Atlanta GA

      Member, GPUG Advisory Committee
      Chairman, Georgia Regional GPUG Chapter
      Summit 2016 Track Leader
      GPUG All Star 2016

      GP2015 R2
      MR CU14

      Follow me on Twitter: @Automate_It

      GPUGGA – http://www.gpug.com/Atlanta

      *** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
      *** If you solve your issue please share the solution to assist others! ***
      ——————————
      ——————————————-

    • Amber Bell

      Member

      March 10, 2017 at 3:37 PM

      What this post taught me:

      If you want a lot of input and quick response to an Open Forum post: include “LESLIE VAIL” in the title!

      ——————————
      Amber Bell
      Training Dynamo LLC
      Email: amber@trainingdynamo.com
      Website: http://www.trainingdynamo.com
      Twitter: @trainingdynamo
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 11, 2017 at 1:20 PM

      Amber,

      This thread has shown me that, even though there’s quite a lot of tongue-in-cheek, the prospect of recognition and acknowledgment helps bring out the best in people.

      Thank you!

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Joni Finnell

      Member

      March 13, 2017 at 4:56 PM

      I agree with Frank. We have an awesome community AND earning a LESLIE badge is a great achievement to have as a goal! It’s on my list. 😎

      ——————————
      Joni Finnell
      Project Accountant/GP Troubleshooter
      Consumer Support Services, Inc.
      Newark OH
      ——————————
      ——————————————-

    • Lou Spevack

      Member

      March 15, 2017 at 10:52 AM

      I’ll pitch in with a tip if you use Amber’s approach putting documents on hold.  I use PM aged trial balance reports a lot and it always bugged me that they don’t tell you when a document or vendor is on hold.  The solution is to create a conditional string field that marks the document or vendor with a HOLD flag.  I create one for the Vendor Master table and one for the PM Transaction Open Table. They look like this:

      fKUQkn9qRy23nanCFBgu_HOLD.JPG

      The Vendor Hold conditional field goes next to the Vendor name and the Document Hold field goes next to the Document Number on the PM ATB detail report.  Once the fields are placed on the report, I format them as bold so they stand out. 

      Both the document and vendor hold flags go on the ATB detail reports.  Only the vendor hold flag goes on the ATB summary reports.  And the same approach can be used for ATB reports in Receivables Management. If you make regular use of holds, this is a useful enhancement for your ATB reports.

      Cheers.

      ——————————
      Lou Spevack
      Systems Accountant | Dynamics Credentialed Professional
      American Council on Education
      Washington DC
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      March 15, 2017 at 1:23 PM

      Lou,

      I was just modifying an SSRS RM HATB report which has a similar calculated field to put an asterisk next to an unposted credit document.

      Thanks for the detailed tip. Changing RW reports isn’t for the faint-of-heart!

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439) / MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    Members

    DSC Communities replied 6 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!