You’re offline. This is a read only version of the page.
Hi!
I would like to update the User Defined 2 ( on Vendor Maintenance Options) to add a drop down field and get a list of active users in the system.
Is there a VBA code out there I can use to do this? I have renamed the field, added the drop box and added the window/fields to VB and checked the modified fields in GP, just got stuck here.
I am trying to assign a group of vendors to a specific user. So, going forward, when we create a vendor card, I would like for the user to be able to select an active user ID from the drop down list that was just created instead of typing it each time.
Please let me know if this is a possibility.
Thanks!!
*This post is locked for comments
I have the same question (0)
Hi @Namrita,
May I ask why you want to do this ? This sounds quite adventurous, as your GP users might change over time and get deleted from the system.. How are you going to handle this ?
Why don't you try to use the built-in function in GP for Vendor Account? if the only goal is to know who's responsible for a group of vendors, then use that option which is independent of the GP users :
Purchasing >> Cards >> Vendor --> Vendor Account
Enter the account number that the vendor has assigned to your company
Not to mention that VBA code is always something to use with great care, as it might cause you troubles when it comes to upgrade GP.
Also your logic doesn't really make sense, since you want to be able to select a user from a drop down list of only active users in GP.. which limits the range of users, unless your goal is to self-assign the current user to the new Vendor ID.. What about existing users ? My tip would be to go with the "Vendor Account" and populate that field with the 'current' GP user name if that field is blank. This is located in table PM00200, field ACNMVNDR ('Account Number With Vendor').
Share
Report
All responses (
Answers (
28,058
