Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Select checks not incl...
Microsoft Dynamics GP (Archived)

Select checks not including all vendors\documents

(0) ShareShare
ReportReport
Posted on by Lynn Zickefoose 370

GP version 2010 - When using select checks, vendor is not being selected for payment. The vendor is active, not an EFT vendor and not using multicurrency. The voucher's current transaction amount equals the document amount and is not on hold. Nothing has been applied to this document. If we go into Edit Check Batch and select the vendor, as they are shown in the vendor listing, it will not select the voucher or the vendor. However, we can choose the voucher in the Edit Check Batch window.

Any help would be greatly appreciated. 

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Select checks not including all vendors\documents

    This reminded me to look in SY06000.  We have just started using EFT, but a predecessor of mine loaded data from a non-GP system into the table.  setting the country to NONE worked without going through SQL as 'NONE' deletes the row.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Select checks not including all vendors\documents

    Hi Brad,

    Thanks for the reply.  We are using Dynamics GP 2013 and experiencing a similar problem.  We have some Vendors with terms 1% 10 days, Net 30.  If you run the select checks with a date before the discount days lapse the voucher will get selected.  If you run the select checks with no criteria then the document will get selected.  However, if the discount days have expired and the select check date is after the due date, then the document does not get selected.  The vouchers are not on hold and they can be selected.  We have no EFT records setup for these two vendors and I also checked the SY06000 table in SQL to make sure.

    Normally, we run the select checks by Vendor Name with a cutoff and discount date about 2 weeks out.  We are not using Multi-Currency and we do not track discounts in the GL.  I've run check links on the payables series and I've run reconcile on the Vendor Fiscal Year, Calendar Year and Batches.

    Any additional suggestions and help would be greatly appreciated.

    Thanks

    Joe Guyton

  • BrennerKlenzman Profile Picture
    BrennerKlenzman 65 on at
    RE: Select checks not including all vendors\documents

    If you are using EFT, or ever have, the Vendor Address EFT info is stored in SY06000.  When you click the Build Batch button is runs a stored procedure called pmPopulateSelectChecksVendorTemp.  In GP2010 this stored procedure has been changed (compared to v10), to include a section where it kicks out any Vendors that have a Vendor-Address EFT record in SY06000.  If you cannot figure out a reason why Vouchers are not being included for a Vendor, query SY06000 (in the company database) to see if there are any records for the Vendor.  If you do not use EFT for that Vendor, you can delete the records from the table for that Vendor, or, from inside GP select the Vendor Address, click the EFT button, and set the Bank Country/Region to NONE, then click OK.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Select checks not including all vendors\documents

    I have got the resolution for the same. if you are not using EFT then disable EFT payable from Registration. If you are using EFT and your vendor is not EFT Vendor then Check Vendor maintenance. If  EFT information is provided to that Vendor then select None at Bank Country/Region and save. It will run check run for this vendor.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Select checks not including all vendors\documents

    Hello Brad and Lynn,

    Recently I am having same issue like Lynn had. I had tested and checked with Z Vendor Name but there is no Problem with that Vendor for Check Run. I have total 643 Vendors and total 5023 Open Invoices with me. out of which for Check run 239 vendors and 658 Invoices are got selected while I done Select Check Process with all Vendors. I had Checked PM00200 & PM20000 tables but I have not found anything wrong. I had also done Check links several time. Anybody will please help me on this? On production box my Check processing is working fine but that box is of GP10 and I am doing Test on GP2013. I am Facing problem on GP2013.

    Please help me I am really struggling on this issue.

    Regards,

    Sanjay Parab.

  • Bradley Gehrls Profile Picture
    Bradley Gehrls on at
    Re: Select checks not including all vendors\documents

    Hello Lynn,

    Thank you for using Microsoft Online Communities. I understand that you are processing a check run and many of the vendors are not being included in the check run. This happens regardless if there are Restrictions or not.

    I was able to test this further in my system and I was able to replicate the issue that you are seeing. I would like to verify that you are seeing the same results based on my testing.

    When I enter an invoice for this vendor I have a remit to address that is different from the address id in the Payables Transactions Entry window. The remit to address is linked to EFT information for the vendor.

    If I then process a payment for that vendor for a normal check run not eft the vendor will never pull into the check batch. If I create a EFT batch and process through the payment process the vendor then is included in the payment process.

    So if the vendor has EFT information and when you have a different remit to address on the invoice the only way the invoice will pull in the check run is if the batch is set to EFT.

    Please let me know if this is what is happening in your system.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx

    This posting is provided AS IS with no warranties, and confers no rights

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Select checks not including all vendors\documents

    I just discovered that somebody attempted to set this vendor up as an EFT vendor, and then tried to take the info. back out.  Now I have to figure out how to undo that. 

     I can select the voucher in the right hand side of the edit checks batch window without an issue. 

     

  • Lynn Zickefoose Profile Picture
    Lynn Zickefoose 370 on at
    Re: Re: Re: Re: Select checks not including all vendors\documents

    Try changing the vendor name to "TEST" and see if that works.

    Did you verify that the voucher is not a multi-currency voucher and the vendor is not an EFT vendor?

    Can you select the voucher in the right hand side of the Edit Checks batch window without issue?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Select checks not including all vendors\documents

    Great, except my vendor name starts with K.  We have other vendors who start with K and have not had this issue...

     Congrats on your resolution. 

     

  • Lynn Zickefoose Profile Picture
    Lynn Zickefoose 370 on at
    Re: Re: Select checks not including all vendors\documents

    Your not going to believe, this but we contacted support and found that vendors with vendor name beginning with an "Z" will not select!!

    We tested by changing the vendor name and sure enough, it was selected.

    Check back for a hot fix or SP1 fix!!!

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans