Microsoft Dynamics GP (Archived)

Modifier With VBA from Another Window

(0) Share

Report

Posted on by john.ellis

3,510

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

I have the same question (0)

All responses (5)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Thanks, Mariano!

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

John

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Thanks, Mariano!

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

John

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No