Related Posts
  • Forum Post: Re: GP10 and IM10

    Good afternoon, JudyG. I saw that nobody has responded, so I'll give it my best shot. The order that transaction come into GP should be based strictly on the order specified on the source files inside of Integration Manager. Open integration manager, right click on the source files one by one...
  • Forum Post: GP10 and IM10

    We've just upgraded to GP10 (from 8) and are heavy users of Integration Manager -- I'm wondering if anyone else has seen this or knows a way to change the following. Previously: After using IM to upload data from Excel into GP we would access the journal transaction screen to research error...
  • Forum Post: Importing into Proj Acctg

    I am implementing Dynamics GP Project Accounting, and need to import payroll hours. In r10 it appears that the only option is eConnect. Anybody have experience with this, or alternatives? Thanks, Marty
  • Forum Post: Re: Integration Manager v10.0

    I think i already open the fiscal year before posting: Microsoft Dynamics GP\Tools\Setup\Company\Fiscal Periods, then select the Year to post, uncheck all months that need to be posted, click OK. But still it didn't let me integrate. Please advise. Thanks.
  • Forum Post: Re: Integration Manager v10.0

    I can post for any month in FY 06-07, 07-08. But cannot go back to FY 05-06, 04-05, etc...
  • Forum Post: Re: Integration of Purchase Orders

    I don't usually give away free code as I need to feed my family, etc., but I'm having a good afternoon. What you need to do change the source for the item mapping to use a script. In the script, you have to do something rather fancy. You need to connect to the GP company database in SQL, and...
  • Forum Post: Integration Manager Message

    SOP integration fails when using markdown fields. Message: "The following problem was encountered during destination uninitialization: Could not determine the window for scrolling window 'SOP_Entry'of form 'SOP_Entry'(6,619,0,1,0). You may need to create an association. Sales...
  • Forum Post: Re: GP 10 / Integration Manager and Autodim

    We are getting ready to design an integration from a couple different enterprise systems and we hope to use integration manager. I am curious to learn more about this utility and exactly how it is used and perhaps what your integration architecture is (which systems are invovled, what data is being...
  • Forum Post: High Volume GP User

    All, Has anyone had any experience in using GP in a high volume environment? We have a client that plans to process asmany as 3-4 MILLION sales transactions per year. They have told us they do about 300,000-350,000 transaction per month. I am looking for input on how GP handles this large of a...
  • Forum Post: Re: error on budget interation gp 10

    I would first check to see that you have the latest service pack for IM installed. Other than that, in order to import budgets, a user must have rights to the account cards as well as the budget windows. So if you are using the preexisting tasks in GP10, the task ids that should be included in your role...
  • Forum Post: Integration Manager error: "Automation Error"

    First steps with Integration Manger and GP 9.0. No matter which Destination Source I provide, Integration Manager throws: "The destination could not be initialized due to the following problem. Automation Error. The specified module could not be found". I have turned on trace logging...
  • Forum Post: Re: Unable to import XML source file in Integration manager 10

    Hi Sarah. You probably did not install the Source XML adapter in the first place. I have found that older Dynamics v10 CDs did not include this adapter in the installation. The latest media from Microsoft is a DVD that has all the installers in one media. That one will install the XML Source adapter...
  • Forum Post: Re: Importing Price Levels on Inventory Items

    Hi Todd-- Depending on your requirements, integration manager does allow for the importing of price lists to each item. It is part of the item master import, which can be set to update existing items. In the destination mapping, there is a Pricing node, with Items below it. The Items object allows you...
  • Forum Post: Re: Integrating Payroll Employee Data into HR Module

    Hi Jane, Will this be a one time integration or on going? Your best bet is to use the Integration Manager tool to import the file into GP. This tool provides a relatively simple interface for mapping fields from the CSV file to GP and then running the import. If this will be an on going integration...
  • Forum Post: IM.mdb - multiple user access errors

    I have a customer that when they use Great Plains Integration Manager, they are experiencing file locking errors when multiple people are accessing the application. Is this something common? are there settings for the file share that should help this? either through a windows file share or a CIFS NAS...
  • Forum Post: Integration Manager and GL Account Beginning Balances

    Is there a destination adapter for Integration Manager that will provide a destination mapping for beginning GL account balances? We've been able to import our GL accounts but were unable to find a destination mapping for the beginning GL account balances.
  • Forum Post: Vendor Email Addresses Won't Integrate

    I am integrating our Vendor information into GP with Integration Manager. I have created a tab-delimited file containing the Vendor ID and general Vendor information, and another tab-delimited file containing multiple Vendor physical/email addresses. (One email per address row.) Query relationships...
  • Forum Post: IM won't allow additional fields to integrate

    I successfully used Integration Manager to import our vendor and vendor address information into a test company. However, it was determined that additional vendor and vendor 1099 data should also be included. I have modified my integration to include these additional fields but every time I run it, it...
  • Forum Post: Integration Manager

    We are using integration manager to import information from ADP. We downloaded a test payroll TEXT file from ADP, set up integration manager and successfully imported the file to a batch file in the GL. One month later we downloaded another file from ADP and the integration said it was successful but...
  • Forum Post: Employee Suffix VBScripting

    I noticed that Integration Manager does not have a "suffix" mapping for an employee name, much like it does not have a 1099 box mapping for a vendor . I am not that familiar with ADODB commands and am having difficulty getting my SQL update command and parameters to work. Any help would be...
  • Forum Post: Re: Re: Integration Manager with Analytical Accounting

    Thanks allen for the sample file. But is there any alternative way whereby if i do not want to have the journal number being setup in the source file? i tried once i remove the journal number mapping, system gave me the following error message and the integration fail. DOC 1 ERROR: System.Data.SqlClient...
  • Forum Post: Re: Re: Copying Company set up information to a new company

    Integration Manager is the best tool to import chart of Accounts other than anything else. It's quite easy in terms of COA integration. Just bring the COA from the other system in an excel format, import it using IM.
  • Forum Post: Re: Updating Item Vendors using Integration Manager

    Jennifer, Have you set the Source Recordset to point your Source file for Item vendors. When you click Vendors on the left side, You'll see Options Tab on the right side. In that check this setting. Thanks Janakiram M.P. http://janakirammp.blogspot.com
  • Forum Post: Auto-fill for Business Portal

    Is there a way to have business portal use a function like IE's auto-fill? I'm trying to find a way to simplify non-inventoried items my users enter on requisitions using requisition management. As of now we can only lookup inventoried items. It would be nice to have a lookup for non-inventoried...
  • Forum Post: Updating Item Vendors using Integration Manager

    I have a txt document containing item number and vendor number. I want to use integration manager to update item vendors (Item Vendors Maintenance window) in order to pull the correct list of assigned vendors in Requisition Management. The integration run successfully but the vendor is not successfully...