How to import data into modified G.P window using Integration Manager.

(0) Share

Report

Posted on by Community Member

I have modified Receivables Transection Entry window and add one date field. Now want to import data using integration manager through GP Adapter. As it is described in MS documentation integration manager can't import data into any modified window. Is there any way to import data in modified window too?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

RE: How to import data into modified G.P window using Integration Manager.

You can extend integrates using VBA. For a custom field like you're describing the bulk of the VBA would best be placed in the After Document; you'd create the ODBC in the Before Integration and pass the objects through in a global variable.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to import data into modified G.P window using Integration Manager.

Thanks Ian,

Can you please elaborate it or hint me some documentation/Blog regarding this particular issue.? I am bit confused.

I would be highly thankful for your kind consideration.

Thanks & regards.

Amir Reza

K.S.A

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to import data into modified G.P window using Integration Manager.

Just be sure to set your security to the original form while you do the integration and then you can set the security back to the modified form.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: How to import data into modified G.P window using Integration Manager.

Amir,

Are you also wanting to import data into that new field? If yes, then as Ian mentioned you would use VB script, but you would still use the original window. The reason Integration Manager doesn't like modified windows is because it's actually running a macro to accomplish the integration. The user manual for integration manager has some information on how to use VB Script. Also, there is a script library that comes with integration manager.

Blogwise, Mariano Gomez has some good articles on making the data connection. There is a training manual available as well, though it hasn't been updated since version 9 I think. The 'data connection' parts of the manual would be obsolete. Best to follow Mariano's examples.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to import data into modified G.P window using Integration Manager.

Hi Leslie

Thank you so much for providing such useful information. I will through the documentation and VB script . If get problem will get back to you.

Thanks & Regards.

Amir Reza

K.S.A

Was this reply helpful? Yes No