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)

Select checks is not selecting all

(0) ShareShare
ReportReport
Posted on by 117

End users are trying to run the select check option (EFT, check or credit card)

The report is not pulling the invoices that fall within the selection criteria - we've even run it with a simple filter of due date less than 12/31/2019 and it returns a $0.00 when build batch is selected.

We can then edit the check batch and manually select the vendors/vouchers but this is not normal

Has anyone ever encountered this?  Possible fixes?

We're on GP2016

*This post is locked for comments

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    If you go to Inquiry->Purchasing and look at an invoice you think should be included what is the due date? Check the payment terms.

  • tjr2jtr2 Profile Picture
    117 on at

    That's been done a million times already.  Some vendors appear but some don't.  All the bank info is correct as is the due date and discount date.  We may run check links next.  We can manually select the vendors/vouchers but we don't know why the vouchers are not being select when running the build batch process.  This worked earlier this week but not today

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    Are you saying invoices that were being selected earlier are no longer appearing or new invoices that should be included are not being included? This must be date sensitive. Check links may help but you will improve your chances by removing all records from the PM00400 TABLE. Make sure you perform a backup before doing anything.

    Go into SSMS and run TRUNCATE TABLE PM00400 against the company database.

  • tjr2jtr2 Profile Picture
    117 on at

    what should be in the PM00400 table?  currently there are a few thousand items

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    That is the PM Key Master table. Every PM transaction will create a record in this table. By removing all records and then running check links on the payables open and historical records it will repopulate this table. Make sure to before a backup first.

  • tjr2jtr2 Profile Picture
    117 on at

    and if you run checklinks without removing these items, will it rectify itself anyway?

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    Removing the records completely will guarantee a complete refresh. If you do not remove the records it may or may not correct the issue. There is no harm done removing the records. This will only increase your chance for success.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans