Notifications
Announcements
No record found.
Hello, I am facing an issue in MS Dynamics GP. Long times back I had done some customization on PO Entry form in GP. Note that time, I did not add any new field or modified PO Entry form in GP using Modifier because that time the requirement was different. so I wrote down a VBA program as I wanted to perform some activity when user would click on SAVE button on original PO Entry form / window in GP. Now there is a new requirement due to which I added a text field on a Header section in PO Entry form /window in GP by using Modifier . After that I entered a new Purchase order on a Modified PO entry form / window but it did not execute my VBA program which I wrote it few years before. It looks like my VBA program is tied up with the original PO entry window and that's why my VBA program is not running on Modified PO Entry form /Window Can you advise me what to do ? I will appreciate your help.
Hi,
that is quite possible that you may to re-add in VBA the modified forms.. I don't remember as it's been a long time I did any VBA customization.
As a general rule you should try to stay away from VBA and convert any existing code to something else, as Microsoft announced a while back that VBA is no longer supported on new Windows platforms (2019 &up)
You may get in touch with David Musgrave to get some help on re-coding the customizations of VBA with some other tools.
But why MS has still VBA and modifier option on for GP 2018? My VBA program was running perfectly fine but when I added a text field on PO Entry window at header level, It stopped running my OLD VBA program. That's the only program we have in VBA
I'm not saying VBA has been removed from the GP modifier and report writer options..
Just saying that the Dynamics GP dev team has no control over VBA's future and it already happened that some disruptions were caused by Office updates deployed within Windows and rendered some GP apps with VBA code non-functional.
Going forward, GP is not going to support officially VBA anymore for future Windows versions.. thus trying to suggest you find another way to replace VBA code.
Hi
To "fix" your VBA code you will need to change the EventMode property (bottom left) from Original to Modified.
However, Beat is correct. You should be looking to move away from VBA as it is "End of Life" and does not work on new Windows Server platforms.
One of the best approaches to replacing VBA is to use GP Power Tools. See below:
https://winthropdc.wordpress.com/2019/08/12/gppt-replacing-vba-with-gp-power-tools-developer-tools/
winthropdc.wordpress.com/.../
Kind regards
David
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 584 Most Valuable Professional
André Arnaud de Cal... 499 Super User 2025 Season 2
Sohaib Cheema 254 User Group Leader
