Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Please help me in the ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Please help me in the issue I am facing on using of VBA and Modifier in GP On PO entry form/Window

(0) ShareShare
ReportReport
Posted on by IT Analyst 10

​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.​

Categories:
Microsoft Dynamics GP
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,965 Most Valuable Professional on at
    RE: Please help me in the issue I am facing on using of VBA and Modifier in GP On PO entry form/Window

    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

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Please help me in the issue I am facing on using of VBA and Modifier in GP On PO entry form/Window

    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.

  • IT Analyst Profile Picture
    IT Analyst 10 on at
    RE: Please help me in the issue I am facing on using of VBA and Modifier in GP On PO entry form/Window

    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

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Please help me in the issue I am facing on using of VBA and Modifier in GP On PO entry form/Window

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans