630
I have a user that prints checks in Great Plains and wants to make vendor request by name the default. It keeps defaulting to vendor ID. Is there a way to set this so that requesting by vendor name is default?
Thanks,
Justin
*This post is locked for comments
Here are the steps on how you will need to add the VBA code. It is workstation specific so each person that will want to use this option will have to use the VBA code.
1. In GP, open up the Select Checks window (Transactions | Purchasing | Select Checks)
2. On the Menu bar, go to Tools | Customize and click on Add Current Window to Visual Basic .
3. Go back on the Menu bar, go to Tools | Customize and click on Add Fields to Visual Basic
4. Then click on the Vendor Name field next to Select:
5. Go back on the Menu bar, go to Tools | Customize and click on Add Fields to Visual Basic and this will remove the checkmark next to the option.
6. Then you need to go back to Tools | Customize and click on Visual Basic Editor
7. Expand Microsoft_Dynamics_GP | Microsoft Dynamics GP Objects as I have pasted in the screenshot below.
Option Explicit
Private Sub Window_AfterOpen()
SelectPayablesChecks.Select.Value = 2
End Sub
This resolved my issue.
Thanks for the replies.
Justin
In Select Checks window, the "Select Vendor by" (Vendor ID, Vendor Name, Class ID and Priority ID) option is used to add the transactions to the Batch ID as per these filter option. This option is not related to the Print Checks reports. It always print by the Vendor ID order.
If you want to modify the order from Vendor ID to Vendor Name, modify the print checks report with using Report Writer.
In Cash Receipt, if you type R in the distribution type field, it will brings up RECV (based on the alphabet order). If you type the R double time, it will brings ROUND. Please check again and confirm the same.
Hope this helps!!!
This is how the use described it.
Accounts Payable, under select checks; it gives the option of Vendor name or Vendor ID. I have for 3 weeks selected by vendor name. The system defaults back
to Vendor ID and prints checks in ID order and should be by name as selected.
Accounts Receivable, under cash receipts; in distribution the type is receipt or round. Receipt is the correct one; but sometimes typing the R brings up round.
Thank you,
Justin
No, but check out Rockton Smartfill. That might work for you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (