SOP Entry – Defaulting Add Item Menu Option


It’s been more than 45 days since I had given this solution to a Consultant who had asked me about using VBA & Macro. Initially I redirected him to some of David’s articles. But eventually I thought of doing it myself to know how that work. Below is the gist of what I did with relevant screenshots:

1. Open notepad and type the statements shown in the below screenshot:

2. Save the file as [your_file_name].mac and copy it to the GP Application Folder. In my case, the file name is: SetSOPAddItemMenu.mac
3. Make sure to have the Modifier license.
4. Launch GP and open Sales Transaction Entry.
5. Add Sales Transaction Entry to Visual Basic Editor. Never mind if you see a message, that the window is already been added.
6. Open Visual Basic Editor and select “SalesTransactionEntry”. Right click on it and select “View Code”. Write the piece of code which is shown in the below screenshot:

8. Make sure that, you replace the macro file name (which is shown above as SetSOPAddItemMenu.mac) with the name that you had given.
9. Save this code and compile for any errors.
10. This will do the trick of selecting “Add Item” by default whenever you open the Sales Transaction Entry form.

There are so many ways to achieve this. I was quite excited with this method, as this is a plain VBA stuff and no Dex involved. The effort required to achieve this is not more than 10mins. And finally, it will work with much assurance.

You can find the package to import and use this little customization from the link: SetSOPAddItemMenu.zip.

I have attached an “Installation Readme” for a quick usage reference.

Your comments / feedbacks are most welcome.

Vaidy

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s