Integration Transaction Order Issue

We just switched from using Integration Assistant for Excel to Integration 
Manager 9.0.  The integrations are defined the same way for both programs.  
When the General Journal integrations run they complete without 
errors/warnings.  But when you view the transactions in the batch in Great 
Plains the transactions are not in the same order as they were in the Excel 
spreadsheet.  They seem to be very random.

The total dollar amounts balance and the integration runs successfully but 
we can't get the transactions to maintain their order from the Excel 
spreadsheet.  We can't use a sort order in the query because they are not in 
any sort order in the spreadsheet.

Thanks in advance for any assistance you can provide.
0
Ryan (208)
9/10/2007 10:06:00 PM
greatplains 29623 articles. 3 followers. Follow

3 Replies
828 Views

Similar Articles

[PageSpeed] 58

Ryan,

There is a KB article that talks about this issue for sales transactions, I 
have not tried, but it could be the same for GL transactions.  Here is the 
link to the article:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;924857

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.


"Ryan" <Ryan@discussions.microsoft.com> wrote in message 
news:13B9ED6D-C979-4D50-A440-29453F74BBE6@microsoft.com...
> We just switched from using Integration Assistant for Excel to Integration
> Manager 9.0.  The integrations are defined the same way for both programs.
> When the General Journal integrations run they complete without
> errors/warnings.  But when you view the transactions in the batch in Great
> Plains the transactions are not in the same order as they were in the 
> Excel
> spreadsheet.  They seem to be very random.
>
> The total dollar amounts balance and the integration runs successfully but
> we can't get the transactions to maintain their order from the Excel
> spreadsheet.  We can't use a sort order in the query because they are not 
> in
> any sort order in the spreadsheet.
>
> Thanks in advance for any assistance you can provide. 

0
victoria (3340)
9/12/2007 11:14:56 AM
Victoria,
I don't know how to say this other than, you rock :)
This solution worked perfectly.

You answer all of my questions.  Thanks for all of your help once again!  

"Victoria [MVP]" wrote:

> Ryan,
> 
> There is a KB article that talks about this issue for sales transactions, I 
> have not tried, but it could be the same for GL transactions.  Here is the 
> link to the article:
> 
> https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;924857
> 
> -- 
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions, Inc.
> 
> 
> "Ryan" <Ryan@discussions.microsoft.com> wrote in message 
> news:13B9ED6D-C979-4D50-A440-29453F74BBE6@microsoft.com...
> > We just switched from using Integration Assistant for Excel to Integration
> > Manager 9.0.  The integrations are defined the same way for both programs.
> > When the General Journal integrations run they complete without
> > errors/warnings.  But when you view the transactions in the batch in Great
> > Plains the transactions are not in the same order as they were in the 
> > Excel
> > spreadsheet.  They seem to be very random.
> >
> > The total dollar amounts balance and the integration runs successfully but
> > we can't get the transactions to maintain their order from the Excel
> > spreadsheet.  We can't use a sort order in the query because they are not 
> > in
> > any sort order in the spreadsheet.
> >
> > Thanks in advance for any assistance you can provide. 
> 
0
Ryan (208)
9/12/2007 11:02:02 PM
Awwww, thanks!  Glad to help.

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.


"Ryan" <Ryan@discussions.microsoft.com> wrote in message 
news:B9FE7FB7-3B75-45F4-B796-259AEFE2DC83@microsoft.com...
> Victoria,
> I don't know how to say this other than, you rock :)
> This solution worked perfectly.
>
> You answer all of my questions.  Thanks for all of your help once again!
>
> "Victoria [MVP]" wrote:
>
>> Ryan,
>>
>> There is a KB article that talks about this issue for sales transactions, 
>> I
>> have not tried, but it could be the same for GL transactions.  Here is 
>> the
>> link to the article:
>>
>> https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;924857
>>
>> -- 
>> Victoria Yudin
>> Dynamics GP MVP
>> Flexible Solutions, Inc.
>>
>>
>> "Ryan" <Ryan@discussions.microsoft.com> wrote in message
>> news:13B9ED6D-C979-4D50-A440-29453F74BBE6@microsoft.com...
>> > We just switched from using Integration Assistant for Excel to 
>> > Integration
>> > Manager 9.0.  The integrations are defined the same way for both 
>> > programs.
>> > When the General Journal integrations run they complete without
>> > errors/warnings.  But when you view the transactions in the batch in 
>> > Great
>> > Plains the transactions are not in the same order as they were in the
>> > Excel
>> > spreadsheet.  They seem to be very random.
>> >
>> > The total dollar amounts balance and the integration runs successfully 
>> > but
>> > we can't get the transactions to maintain their order from the Excel
>> > spreadsheet.  We can't use a sort order in the query because they are 
>> > not
>> > in
>> > any sort order in the spreadsheet.
>> >
>> > Thanks in advance for any assistance you can provide.
>> 

0
victoria (3340)
9/13/2007 8:08:48 AM
Reply:

Similar Artilces:

Address issues sending to our Fax Machine
We have a Panasonic DX-2000 fax machine to which we fax tiff files, etc through our e-mail clients. We recently upgraded to 2003 exchange server from Groupwise and we are getting the following error when trying to send faxes though Outlook: "The e-mail account does not exist at the organization this message was sent to." Our normal addressing is as follows: send#"add fax number"@fax."domain".com I have changed the global recipient email address policy to include smtp @fax."domain".com What is the problem here. ps...our "fax."domai...

SMTP issue #3
Hi, I did setup virtual SMTP server on my web server, and I want to test the virtul smtp to see if I can send e-mail to out side. I did configure the outlook express, I opened a new mail and send it to a knowen address, when I click on send/receive it semas that mail had been send out side, but when I look at the Queue in mailroot all the e-mails are there. I am useing 2003 web edition, this server is in DMZ, I use netstat and port 25 is open. So I have no idea what is going on here! Any idea? Why Web edition? Which Queue is it stuck in? Does it have access to DNS? Can the Exchange serv...

Integration Questions
Where do I go or how do I get the CRM to integrate with Great Plains, I think there is supposed to be an integration tool somewhere, but I cannot find it. There is an integration CD which you will have received if you are a CRM partner or customer "Nathan Tidd" <NTiddSPAM@douglas-associates.com> wrote in message news:0d1a01c3b421$ec4437c0$a501280a@phx.gbl... > Where do I go or how do I get the CRM to integrate with > Great Plains, I think there is supposed to be an > integration tool somewhere, but I cannot find it. It is much more than a "Utility", i...

Scheduling Integration for Integration Manager
Hi, Does anyone have any step by step procedure or documentation for scheduling integrations for Integration Manager? I hope there is a workable way for not so technical users to use so that I won't need to customize a functionality for this in Dynamics GP. They want to update their price list if possible using integration manager. However, they want it to be scheduled, like for example the manager will create the integrations today, then it will the update (integration), the end of next week without human intervention. Reason being is that updates/integration can run during ...

CRM Integration with an other SQL db
I'm looking to bridge Navision on SQL with CRM. Any body got some suggestions on the best way to built that real time link? -- Benoit How "Real Time" do you want it. If you want, you can use PostCallouts to implement this kind of integration (and there is a paper on MSDN on this subject) where you post changes to Accounts, new Orders, etc. from CRM to your Accounts package. For the other direction, bringing Accounts and sales information from the Accounts package into MSCRM then I would look at using a package like Scribe (BizTalk is also an option) to do this on a sch...

Default Printing Issue
We are using GP in a Terminals Services enviroment. All users access GP via a Terminal Server. The issue we are having is that the default printer for each user changes (In GP ONLY), the default printer for the TS desktop stays as it should. What could be the issue. I'm having a bit of an issue determining which printer is defaulting and which isn't. And which that you want. But I guess suffice to say it isn't the one you want. I would guess your issue is one that another customer I was working with was running into - they were using I think Windows 2008 Remote ...

ACT! Address Book integration
When integrating or using an address book in Outlook, the display name is automatically appended with the name of the address book the 'look up' found the name in... example: Jonathan Dorfman (ACT!) Is there any way to edit this feature or suppress it? Thanks in advance. Jonathan ------------------------------------------------ ~~ Message posted from http://www.OutlookForum.com/ ~~ View and post usenet messages directly from http://www.OutlookForum.com/ ...

Integration Transaction Order Issue
We just switched from using Integration Assistant for Excel to Integration Manager 9.0. The integrations are defined the same way for both programs. When the General Journal integrations run they complete without errors/warnings. But when you view the transactions in the batch in Great Plains the transactions are not in the same order as they were in the Excel spreadsheet. They seem to be very random. The total dollar amounts balance and the integration runs successfully but we can't get the transactions to maintain their order from the Excel spreadsheet. We can't use a so...

Custom Background Issue
First, I am not even close to a professional computer anything! Last week I pulled in picture to use as a background for a flyer that I am doing. Everything was fine- it printed fine and was viewed fine. Yesterday I received a new "template" from our design company and did exactly the same things and when I pull it in to the more backgrounds area it looks fine on the background panel and in the print preview area. Yet the screen where you insert text boxes or design your flyer is black and I can barely see the background. Please help! -- T What happens if you insert the back...

CRM to GP Integration CD Builds
Hi, We are missing our GP to CRM Integration CD and waiting on delivery of a new one. However, we do have the Release Candidate 2 CD dated 3/25/2003. Can anyone tell me if this CD is the same as the RTM CD that went out? I can't remember if there was another build afterwards. Alan ...

Integration Mgr with Excel ODBC
I'm trying to use an Excel workbook (xlsx) as a simple ODBC source. After specifying the path for the source file when I click the Table button IM pauses for a few seconds and then closes. Same thing happens if I try using xls format. This is on GP 10 SP2 with IM 10.00.1134. Any ideas what would be causing this to happen? Changing the spreadsheet to XLS would be a good first step. -- Charles Allen, MVP "irishjamr" wrote: > I'm trying to use an Excel workbook (xlsx) as a simple ODBC source. After > specifying the path for the source file when I click th...

Baseline Date Roll-up Issue in 2007
I am evaluating supplier schedules submitted to a prime contractor in a new technology development project. The suppliers are required to align their activities with the Prime's activities by placement of Prime activity IDs in user defined text fields in each supplier's project file. I am now doing a roll-up of activity status by the Prime's activity ID. The issue in Project 2007 (12.0.6211.1000) SP MSO (12.0.6425.1000) is that the summary roll-up picks the LATEST baseline start date - not the earliest. I have checked this out in a number of different scenarios. ...

Using a SQL Job to run an unattended Integration with Integration
Is there a way to run an Integration using a sql job instead of using a Windows Scheduled task. I am using SQL Optimizer so I do not need to log into Great Plains first. Lewis: Yes. You would first create a .bat file (DOS program). In this batch file, you move to the Integration Manager folder (optional), then you would use the command line called IMRun.exe located in this folder (IMRun.Exe "IntegrationName" -Refer documentation) . Once you create the batch file, you would call this batch file using a DTS package within SQL EM. Then you would schedule a SQL job to call this D...

Entourage issues with Gmail lately
Lately Entourage (and also Mail) have been having issues with Gmail. I get a message in Entourage saying that I need to re-enter my password. Perhaps this is a server issue I don't know. Do you? John -- Are there errors in the Bible? Do Animals go to Heaven? Is drinking Alcohol a sin? Is the KJV the only translation to be used? If you want to learn, get answers, and be able to defend the faith, CERM is your place. http://www.cerm.info/ On 2010-03-03 05:17:47 -0500, John Wolf said: > Lately Entourage (and also Mail) have been having issues with Gmail. I get a >...

CRM Integration 1.2 for Great Plains
The CRM Integration 1.2 for Great Plains seems to only support integration between one Great Plains company databse and an installation of CRM. Does anyone know if it is possible to integrate more than one Great Plains database to a CRM installation using the the standard CRM Integration 1.2 for Great Plains and Biztalk server. CRM <=> GP Integration only supports integraiton to one GP company DB. >-----Original Message----- >The CRM Integration 1.2 for Great Plains seems to only support >integration between one Great Plains company databse and an >installation of CRM....

can excel change number 1532 to 1235 running order
I need help in excel,formatting of numbers. Example 1548,6981,1032,6710 to display in excel in order preferences as 1458,1689,0123,0167. Thank you. Not possible -- Regards, Peo Sjoblom "Bluesy69" <Bluesy69@discussions.microsoft.com> wrote in message news:3AE2D2A0-DF8D-4877-8556-4F74C171D26B@microsoft.com... >I need help in excel,formatting of numbers. Example 1548,6981,1032,6710 to > display in excel in order preferences as 1458,1689,0123,0167. Thank you. "Bluesy69" <Bluesy69@discussions.microsoft.com> wrote in message news:3AE2D2A0-DF8D-4877-85...

Scheduled Integration via Integration Manager
Hi! I in dire need of help and would need to know if there is any way that I can schedule integrations using integration manager. For example, my client would want to update the price list via integration manager. Is there a way for them to just enter a date to run the integration, and if possible a time as well, then it will automatically run the integration at that specified date and time? Any workarounds, ways and step by step procedure on how to achieve that, would be very very great. Thanks! -- Bryan Hipolito The IM user guide covers that in detail. If you don't already ...

Integration DB Size
Our integration database is growing at a very rapid pace (about 200 MB per day) ... compared to the pace that our GP & CRM databases are growing. Is there some way to "shrink" the Integration DB? -- Brandon ================== Presentations Direct - http://www.presentationsdirect.com > Binding Machines http://www.presentationsdirect.com/binding-machines/gbc-binding-machines.asp > Laminators http://www.presentationsdirect.com/laminators/gbc-laminators.asp > Paper Shredders http://www.presentationsdirect.com/paper-shredders/gbc-paper-shredders.asp...

Duplicate transactions & Old Data
I recently upgraded Money 2004 to 2005, Premium. A whole series have issues have developed since this upgrade. First, when downloading checking transactions from Bank of America into the register, no downloaded transaction match against manually entered items. Thus, duplication transactions are created. I must delete all of the downloaded transactions to get the correct bank balance. Second, investment balances downloaded from T. Rowe Price are correct. However, Money again is not able to identify individual transactions. Rather, Money says I need to adjust the number of shares ...

Re: Integration Manager Error
"6538" <lbeach@remingtonconsulting.com> wrote in message news:... > Running a JE integration and receive the following error. I have checked > the source documents and previewed and all appears fine. > > This integration cannot be run because of the following problem(s): > Source Recordset '1' not round - used for Record Source option on > collection 'Entries' > > ...

Mas90 integration
I am trying to find out if RMS is compatible with Mas90 (MAS 90 is a 32-bit accounting, distribution and light manufacturing software) If the integration is possible where can i find the steps on how to set it up, or if there is a module for this where can I purchase it from? Thanks, HaikHR@gmail.com Try the Peachtree 3.0 export. It is very close. MAS had and import tool to import the file, as I remember it is and module they offer. Good luck. mt "Haik" <Haik@discussions.microsoft.com> wrote in message news:E5028623-B547-4399-B1B3-1146BD3015B4@microsoft.com... >I ...

Bank Reconciliation Integration Problem #2
We are receiving "No Matching Transaction found for Transaction Number" warning message during a bank reconcilliation integration for the XFR type. Have checked that the transaction number is correct in CM20200, and we can clear the XFR types manually. Is this transaction type not allowed for some reason? Or is there some other reason why we get this warning? Scott Here is the response I got from MBS Developer Support: This has been logged as bug 26212: SUMMARY: When running a bank reconcilation integration if one of the transactions is a bank transfer with a type of XF...

Sharepoint Integrate with CRM
Hi all, Does Any one know virtual pc image that had integration sharepoint with crm for demo purpose available for download ? thanks to all in advance ...

Site integration--Reverse Proxy
Hi, I am working on a project to integrate another site into our site. What happened is like this: 1. I have a iframe with the src referenced to a special folder (SiteIntegration) in our site (original site). 2. I have a HTTPHandler which acting as reverse proxy to make request to the target site and I have the following config in web.config <add verb="*" path="SiteIntegration/*" type="ReverseProxy.ReverseProxy"/> 3. I created a request to the target url in the ReverseProxy-- ProcessRequest sub. (Adding right authentication), and I got r...

Macro interferes with tabbing order
I've been seeing this problem for a little while now, but I've only just discovered what was causing it. I have a form with a number of fields where users type in large numbers. To make this easier, I wrote a macro called "addZerosToNumbersMacro" that translates keys like "T" into three zeros (thousand) and "M" into six zeros (million). I put this into the onChange event in any field where it makes sense. Works great! Except for one thing. If you type in the number longhand and press tab, the field validates and moves onto the next field in the tab...