Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager VB...
Microsoft Dynamics GP (Archived)

Integration Manager VBS Help

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I'm in process of importing Items into inventory using Integration Manager. The integration is successful but I need to make all the newly integrated parts INACTIVE. I would like to do it by using VBScript , unfortunately I'm not very savvy in VBS.  Is there anybody who done this before?

here is the sample that I put together with my limited VBS understanding:

INACTIVE.CheckBox.wState = cbChecked

This code comes back with "

DOC 1 ERROR: Error Executing Script 'After Document' Line 1: - Object required: 'INACTIVE'

" error

I also tried: INACTIVE.CheckBox.Value = 1 with the same result.

What am I doing wrong?

*This post is locked for comments

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Integration Manager VBS Help

    Thanks Karol,

    Now I'm getting more clear about what you want to achieve.. Are you using BOM's in GP ? if so, Manufacturing BOM or Inventory BOM ?

    Have  a look at this older post about how to import BOMs into GP :

    community.dynamics.com/.../import-inventory-bom

    This one above is about Inventory BOMs, but there is a tool that can import Manufacturing BOMs from Excel worksheets, sold by Willoware, an Dynamics GP ISV with quite a collection of tools around manufacturing. Have a look at it:

    willoware.com/.../bomimport

    If you intend to repeat this process a few times, it is probably worth buying the tool for the long term, though I believe you can fully try it out for 30 days.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager VBS Help

    Beat

    It is a Excel file exported from Autodesk Vault application. What we trying to do is to import items that were previously created by engineers in the cad applications and managed in PDM (Vault) solution. Since the IM for Inventory Items dos not have adapter for engineering nor planning table I have to make imported items inactive until they are fully populated by production personnel in GP to prevent sales to order half cooked products.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Integration Manager VBS Help

    Karol,

    where does the source data reside ? is it a temporary SQL staging table or an Excel file ?

    We're using SmartConnect from eOne, and I checked one of my maps that I used in the past to import new inventory, and the Status field isn't part of the field list.. which means you have to switch that after the inventory has bee created.

    Thus my suggestion to run a post-integration SQL script to switch the flag in the Item master table based on the list of imported items. It's easier of course if the Item list was previously uploaded into a staging table..

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager VBS Help

    Beat

    Thank you for your input, but from what you are suggesting it looks like that I need to use additional steps in this integration. I was hoping to minimize the step to minimum by using the scrip inbeded directly into IM.

    Karol

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Integration Manager VBS Help

    Hi,

    It's a long time that I haven't touched Integration Manager, but I was under the impression that you could provide the value for the 'Inactive' status within the import file ??? I'd have to setup IM to test this out..

    EDIT: I checked the IM documentation and it doesn't look like that the status field is an option for the import file.. seems like IM put it automatically as 'Active'.. But instead of using VBS, you could simply run an update script with the data based on you import field in SQL on table IV00101.. or run a macro by using the mail-merge technique based on your input file. The process is explained in various place in the community.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager VBS Help

    I think I'm making progress into right direction. I rewrote the code to following:

    FormFields("INACTIVE").CheckBox.Value = True

    This fixed the error with the object, but created new error "type mismatch"

    Karol

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans