[Steve Erbach]

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]

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]

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!

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]

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]

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]

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]

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]

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]

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

Purchasing > Transactions > Holds

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

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

[Tom Monfre]

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]

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]

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]

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]

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!

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]

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]

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]

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]

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.

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

[Steve Erbach]

Amber,

You definitely qualify for the LESLIE VAIL Badge!

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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:

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]

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]

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]

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]

Nobody smiles like you, Leslie!

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]

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]

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]

Let’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]

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]

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]

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]

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]

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]

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:

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]

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
——————————
——————————————-