tag:blogger.com,1999:blog-5285970135510371565.post4396143010505927831..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: How to import the Vendor 1099 Box with Integration ManagerMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-5285970135510371565.post-53857853055499306642009-09-26T09:17:23.877-04:002009-09-26T09:17:23.877-04:00Devo,
Unfortunately, not all fields are exposed t...Devo,<br /><br />Unfortunately, not all fields are exposed to IM, hence the reason why I created this post. The technique outlined at Developing for Dynamics GP is just another method of importing data.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-85690578759159578342009-09-25T19:10:11.748-04:002009-09-25T19:10:11.748-04:00I could not find that field in IM either so I used...I could not find that field in IM either so I used a macro as described in the following post:<br /><br />http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/30/how-to-use-word-mail-merge-and-macros-to-import-data.aspxDevohttps://www.blogger.com/profile/10196452057635976339noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-91701154463678660692009-09-25T19:09:12.767-04:002009-09-25T19:09:12.767-04:00Barbara,
Unfortunately, this is the only way. EFT...Barbara,<br /><br />Unfortunately, this is the only way. EFT is a good example too because EFT functionality is delivered via a separate add-in dictionary. So, the only way to access those tables is via SQL Scripting or VBScript.<br /><br />If you feel I can help you building this integration, please do not hesitate to contact me.<br /><br />Best regards,<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-7629691211832444332009-09-25T19:09:11.087-04:002009-09-25T19:09:11.087-04:00Barbara,
Unfortunately, this is the only way. EFT...Barbara,<br /><br />Unfortunately, this is the only way. EFT is a good example too because EFT functionality is delivered via a separate add-in dictionary. So, the only way to access those tables is via SQL Scripting or VBScript.<br /><br />If you feel I can help you building this integration, please do not hesitate to contact me.<br /><br />Best regards,<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-80993874656254273722009-09-25T17:26:42.513-04:002009-09-25T17:26:42.513-04:00Hi - GP Dynamics Super User/NON SQL coder here...i...Hi - GP Dynamics Super User/NON SQL coder here...is the process described the only way to add destination fields in to an IM adapter? I'm trying to import vendor EFT info via IM but that button under cards/purchasing/vendor/address is not an accessible field nor is the following EFT input fields.<br /><br />thanks!<br /><br />Barbaraatlbabshttps://www.blogger.com/profile/03658658017582577077noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-32880296207222876272009-07-29T15:41:49.202-04:002009-07-29T15:41:49.202-04:00Devo,
Glad to know you were able to apply the met...Devo,<br /><br />Glad to know you were able to apply the method discussed here. I completely agree on proper use of classes, but that's not always the case at some customers. For some customers, classes represent geographical locations, and not whether a vendor is trade or contractor, hence the post.<br /><br />Best regards,<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-54939598204635477012009-07-29T13:14:09.225-04:002009-07-29T13:14:09.225-04:00I was able to successfully integrate the Vendor 10...I was able to successfully integrate the Vendor 1099 Box using this method. Thanks Mariano for another tool in the IT belt!<br /><br />Having now completed the process and looking back though, I realize that there is an easier and more eloquent method of integrating the Vendor 1099 Box. That process is through properly defining and creating Vendor Classes. As vendors are integrated through classes, they inherit the properties of the class to which they are assigned, one property of which is the Vendor 1099 Box. Additionally, the proper use of classes simplifies vendor maintenance in the long run.Devohttps://www.blogger.com/profile/10196452057635976339noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-55086087329517352912009-06-05T17:21:04.108-04:002009-06-05T17:21:04.108-04:00Devo,
Your error is not referring to your field s...Devo,<br /><br />Your error is not referring to your field script, rather your After Document script.<br /><br />To correct the problem, edit your After Document script as follows:<br /><br />.<br />.<br />GPConnection.Open(oCn)<br />set oCmd.ActiveConnection = oCn<br />With oCmd<br /> .CommandType = adCmdStoredProc or adExecuteNoRecords<br />.<br />.<br /><br />Note I removed the ActiveConnection property from within the With..End With block.<br /><br />MG.-<br />Mariano Gomez, MVP<br />Maximum Global Business, LLC<br />http://www.maximumglobalbusiness.comMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-57977309867764331282009-06-05T16:41:26.834-04:002009-06-05T16:41:26.834-04:00I'm experiencing the following error in IM:
E...I'm experiencing the following error in IM:<br /><br />ERROR: Error Executing Script 'After Document' Line 25:<br />Object required: 'oCmd'<br /><br />My field level script is as follows.<br /><br />SetVariable "gVendorID", SourceFields("VENDOR_ID")<br />SetVariable "gBoxNumber", SourceFields("M1099_CD")<br />CurrentField.Value = SourceFields("VENDOR_ID")<br /><br />The integration will still run (giving the error above for each document) and I noted that the appropriate 1099Box cells are populated in the database table, but that they all have the value 7 instead of the values from the source text file. Also, putting a MsgBox at the end of the After Document script revealed that the script does not complete, as the MsgBox never appeared.Devohttps://www.blogger.com/profile/10196452057635976339noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-15421319093201009792009-06-04T19:10:37.560-04:002009-06-04T19:10:37.560-04:00This comment has been removed by the author.Devohttps://www.blogger.com/profile/10196452057635976339noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-75734130562542487082009-05-14T12:53:00.000-04:002009-05-14T12:53:00.000-04:00Different approaches. One of my preferences is for...Different approaches. One of my preferences is for the integration package to be as complete as possible. That way I'm not worrying about stored procs or views getting wiped out in an upgrade. It also makes it easy to tweak inside the integration if I've copied it to point to a different company. I don't have to ensure that a proc exists. <br /><br />MarkAnonymoushttps://www.blogger.com/profile/05825355320779919498noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-83293545056634101412009-05-14T12:21:00.000-04:002009-05-14T12:21:00.000-04:00Mark,
Thanks for the inquiry!
You can certainly...Mark,<br /><br />Thanks for the inquiry! <br /><br />You can certainly use VBScript all the way through without ever needing a procedure, by executing the same UPDATE statement via a command execute. However, I always try to separate front-end logic from backend logic, just as a matter of best practice. A stored procedure allows you build transactions or try..catch operations around an UPDATE that can evaluate and return the results of the attempted operation.<br /><br />As you can see from the stored proc, it returns a status which can then be written to the IM error log if something ever happens during the UPDATE operation. This provides greater control and does not assume the update will always be successful.<br /><br />Best regards,<br /><br />MG.-<br />Mariano Gomez, MVP<br />Maximum Global Business, LLC<br />http://www.maximumglobalbusiness.comMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-17363326243181179332009-05-14T11:48:00.000-04:002009-05-14T11:48:00.000-04:00Mariano,
Why not use VBScript during the integrat...Mariano,<br /><br />Why not use VBScript during the integration to populate the field as the records go in? You still get control of what get's populated and you don't need a proc.<br /><br />MarkAnonymoushttps://www.blogger.com/profile/05825355320779919498noreply@blogger.com