web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Taking vendors off hold and putting them on hold

(0) ShareShare
ReportReport
Posted on by 7

Could anyone tell me if there is an easier way to do this.  When we're processing our credit card statement we enter all invoices in GP. Currently we need to enter the invoice against the PO which is issues to a specific vendor.  Then we have to do a manual payment to move it from the Vendor to our CC company. The terms in GP for 800+ vendors is CC terms.  We have to manually take each vendor off hold in order to process the manual payment, then go back and put them on hold just so the CC invoices doesn't get processing in a check run since GP does not recognize not to process a check for CC terms.  We can spend an hour just taking vendor off hold, then another hour putting them on hold.

Unless someone has a suggestion on how not to get CC term vendors to process in a check run.

Thank you,

*This post is locked for comments

I have the same question (0)
  • Patrick Roth Profile Picture
    Microsoft Employee on at

    I don't believe there is any way that you aren't going to automatically filter out vendor checks without some sort of customization.

    From a GP out of the box perspective, you could use the Vendor Navigation list.

    Here you can run the "Vendors" list and fill with your vendors.  Only problem is that we can't filter by the Payment Terms ID (which is what you are looking for if i'm not mistaken).

    But you can filter on user defined 1 and user defined 2 (they are named whatever the names you have set up are.  In Fabrikam User Def 1 is "type").  SO you can put CC or whatever in one of these and filter on that instead of "payment terms id".

    there is an action to put that vendor on Hold and seems to work fine.

    Unfortunately there is no "take vendor off hold".  So you'd still need to do that manually.

    I was thinking perhaps SmartList Builder using the Navigation List Builder.

    So this is better in that we can put in Payment Terms ID in as a field and filter on that.  But it has the same action as GP - "Put Vendor on Hold".  There is no "Take vendor off hold" action.

    So slightly better but not great.

    The only other thing I can think of is SmartConnect.

    You can make a "SmartList Data Source Map" that you can use to put the vendors on hold.  Then you can make one to take them off hold.

    Now by loading the SmartConnect GP Addin, you would run a Vendors smartlist (or however you need it) that you filter however you want (ie the payment terms id).

    Then the addin would put a "Run Map" on the additional menu and when selected would show you the maps(s) that you created.

    You would select the "put vendor on hold" map.  This pulls the data right out of the smartlist and uses it as the map source and would put all those vendors on hold.  800 records would probably only take a few minutes.

    Then you do your checks normally.

    After finishing, choose the "take vendor off hold" map and it would run the 2nd map and take those same vendors off hold.

    A bit of work to set that up (plus having SmartConnect of course) but should work.

  • mm123 Profile Picture
    2,535 on at

    Ktrenfny, If you are interested we can offer custom automation solution based on your exact above needs, that will eliminate your hours of manual work. Please drop an email to learn more.

    samr(at)expsoltech(dot)com

  • Suggested answer
    Almas Mahfooz Profile Picture
    11,009 User Group Leader on at

    This can be done by custom coding, it's better to have small application developed for the same if you need to do this in future again.

    Or you can do this through macro but it also need some technical skills.

  • Joseph Markovich Profile Picture
    3,995 on at

    Could you possibly use the Payment Priority field in Vendor Maintenance?

    In Select Checks, this is one of the filters to use when building the check batch. When doing a check run for the non-CC terms vendors, use that as a filter from say 1 to 1.

    For the CC terms vendors, set them as priority of 2 or something higher?

    This is me just thinking out loud to use something out of the box to solve the issue you're having.

    Thanks.

    -Joe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans