Creating a check batch in Microsoft Dynamics GP can be an easy task, and can be made even easier by entering restrictions when you create the batch.  You must, however, enter the restrictions in a certain order, or you may not get the results you want.

I’ll show you how to create a check batch using a date restriction in Microsoft Dynamics GP in this blog.

Step 1: Navigate to Purchasing > Transactions > Select checks.  The Select Payables Checks window opens:

Step 2:  Enter your batch name by typing it directly into the Batch ID field.  I’m calling mine AP04122017.  Tab off of the Batch ID and a dialogue window will appear, asking if you’d like to add the batch.  Select Add.  The Payables batch Entry Window opens, so you can enter your batch information.  The Checkbook ID is a required field, but you may want to enter other fields in this window for your own recordkeeping, or depending on your security setup:

Step 3:  Click Save and the batch window closes, taking you back to selecting your checks.

NOTE: You MUST enter and save the batch before entering any batch restrictions in the Select Payables Checks window, or your restrictions will be lost and you will not get the anticipated result.

Add Restrictions

You can narrow your check selection down by choosing an option from the Select drop-down menu.  There are numerous options available to choose from:

Vendor ID
Vendor Name
Class ID
Payment Priority
Voucher Number
Document Number
Due Date/Discount Date Cutoff-did with the document date.

Click the Insert button to lock in this selection.  Now, the system will look at due dates, and will pull any document with a due date before 04/19/2017 and any document at all with a discount available.  Here is what my Select Payables Checks window looks like before I build the batch:

Click the Build Batch button to build your check batch.  If you go into your batch to edit the checks (Purchasing > Transactions > Edit Check batch) you will see that it restricted the batch to items due before 04/19/2017.

Want more how-to’s and tips? Visit the Crestwood blog.

Submitted by: Misty Galbreth, Support Analyst at Crestwood Associates LLC, and Illinois Dynamics GP Partner.

March 31, 2016 by Misty Galbreth, Support Analyst at Crestwood Associates LLC

Email | Print

Ask The Author

Tags: Microsoft Dynamics GP How-to: Creating a Payables Check Batch Using a Cutoff Date
Posted in About Microsoft Dynamics GP, User - ERP User Posts | Comments Off on Microsoft Dynamics GP How-to: Creating a Payables Check Batch Using a Cutoff Date

More Posts By Crestwood Associates

1. Going for the Gold – Crestwood Obtains its Second Microsoft Gold Competency for Cloud Hosting
2. Cloud Services: The Good, the Bad, & Things They Don’t Tell You
3. The Crestwood Story: Celebrating 20 Years and Growing Strong
4. Top 10 Reasons Your Business Should Move to the Cloud
5. Time Saving Keyboard Shortcuts for Dynamics 365

Related Posts

1. Dynamics GP Video Tip: Editing Quick Links – How to Customize the Home Page Part 2
2. GPUG (Microsoft Dynamics GP User Group) Summit 2013: 5 Reasons to “B” There
3. FRx Row Linking: How to Replicate Reports in MS Management Reporter
4. Upgrading Dynamics GP: Why Should I do It? What are the Benefits?
5. Convert Sick and Vacation Time Accrual from Payroll to HR Module