Microsoft Dynamics GP (Archived)

Modifier With VBA from Another Window

(0) Share

Report

Posted on by john.ellis

3,530

Hello:

A GP 2016 client has its Sales Transaction Entry window modified with Modifier and VBA.

They have recently purchased a third-party add-on containing its own Sales Transaction Entry window.

The client would like to take a field from this third party's Sales Transaction Entry window and place it on its own modified Sales Transaction Entry window.

Is it possible to do this?

Thank you!

John

*This post is locked for comments

All responses (5)

Answers (0)

Sort by

Richard Wheeler 75,854 Moderator on at

Like (1)

Report
Copy link

Link copied!

Sure but since it sounds like you will be using the form from the third-party product you will need make the same changes to this new form as you did to the GP SOP form. Most likely you will need to start over as far as the modifications go.
Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

You cannot take a field from the third-party SOP Entry window and place it directly on the customer's own modified SOP Entry window. What you can do however, is to add another field to the customer's SOP Entry window and add VBA logic to do all the CRUD operations with that field.
john.ellis 3,530 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Mariano!

Is there any documentation on how to do this? :)

John
john.ellis 3,530 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Mariano!

Can you please give me a "hint" as to how the coding for this would look, after adding the field?

John
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi John,

1. You have your own Sales Transaction Entry window modified with modifier and VBA code.

2. You have 3rd party Alternate Sales Transaction Entry window with custom fields on the window.

Task: you want some fields from 2nd window to 1st one.

There are 2 ways to do this task. First one is to find the name of tables those custom fields are saving, most probably they will be find in 3rd party custom tables by adding code in existing VBA you can read those values in your modified window. For this you have to create fields through modifier and then drop them on the window and fill them by vba code.

But keep remember that in this way you will only be reading the existing values , you will not be able to save or update the values in custom fields.

Another option is just do the modifications in 3rd Party alternate sales transaction entry window as you did in your sales transaction entry window and past the vba code, so your modification will be there as well as all the 3rd part product functionality will be available, which you don't need to care about. And there will not e more coding. You just need to mark alternate modified sales transaction Entry window in security.