web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / Great Plains 10.0 Slow...
Microsoft Dynamics GP (Archived)

Great Plains 10.0 Slow Integration

(0) ShareShare
ReportReport
Posted on by Community Member

hello ,

i am currently using the normal standard Integration Manager to transfer my data into Great Plains.

my files are standard financial files but my problem is that they are big , i have more then a file with more then 30k Transactions.

i start off by creating a batch ID and mapping the info , i use 2 notepad files one for headers and one for Details

when i run the integration it starts off with at least 1 transaction a second and then it slows down a lot to around 2 3 seconds a transaction and then even more , up to 10 20 seconds per transaction making it impossible for me to enter my transactions.

i hope you could find the time to answer my question and help me out .

if you require more info to help me please do not hesitate to post and i will instantly post the answer .

thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Emouawad,

    It seems you have bulk trx data in your source file & during integration using IM, Macro or other integration technique. Thus system hangs for a while.

    so using eConnect schema, you can create a console application & schedule application to integrate the records.

  • Community Member Profile Picture
    Community Member on at

    hey Natarjan,

    thank you for your answer , but i fear it is not helpful since we were advised that Econnect can only integrate the functional currency and my file contains many currencies.

    looking forward for your reply

  • Community Member Profile Picture
    Community Member on at

    Hi Emouawad,

    what are the transactions you are going to integrate to GP?

  • Community Member Profile Picture
    Community Member on at

    these are the headers,

    Journal Entry Intercompany Batch ID Transaction Type Transaction Date Reversing Date Source Document Reference Currency ID Note Exchange Rate
    1 30092013DUBAI 9/30/2013 PIVOT NA AED
    2 30092013DUBAI 9/30/2013 PIVOT NA BHD
    3 30092013DUBAI 9/30/2013 PIVOT NA BTN
    4 30092013DUBAI 9/30/2013 PIVOT NA DZD
    5 30092013DUBAI 9/30/2013 PIVOT NA EGP
    6 30092013DUBAI 9/30/2013 PIVOT NA EUR
    7 30092013DUBAI 9/30/2013 PIVOT NA GBP
    8 30092013DUBAI 9/30/2013 PIVOT NA IRR
    9 30092013DUBAI 9/30/2013 PIVOT NA JOD
    10 30092013DUBAI 9/30/2013 PIVOT NA KRW
    11 30092013DUBAI 9/30/2013 PIVOT NA KWD
    12 30092013DUBAI 9/30/2013 PIVOT NA LYD
    13 30092013DUBAI 9/30/2013 PIVOT NA MAD
    14 30092013DUBAI 9/30/2013 PIVOT NA OMR
    15 30092013DUBAI 9/30/2013 PIVOT NA QAR
    16 30092013DUBAI 9/30/2013 PIVOT NA SAR
    17 30092013DUBAI 9/30/2013 PIVOT NA SDG
    18 30092013DUBAI 9/30/2013 PIVOT NA SYP
    19 30092013DUBAI 9/30/2013 PIVOT NA TND
    20 30092013DUBAI 9/30/2013 PIVOT NA TRY
    21 30092013DUBAI 9/30/2013 PIVOT NA USD
    22 30092013DUBAI 9/30/2013 PIVOT NA YER

    these are the lines , 

    Journal Entry Intercompany Id Account Number Debit Amount Credit Amount Distribution Reference Currency Id Rate Type Id Exchange Rate Receipt Id Payment Remarks Payment Reference Disbursement Application Id Disbursement Id
    1 0340100007536 1939 799900 AED
    11 0341100007751 2104.76 817723 KWD
    15 0340100008198 226.83 812983 QAR
    21 0340100007837 2.79 837017 USD

    i hope this is helpful

  • Community Member Profile Picture
    Community Member on at

    the table is not clear in the last post unless you use shift to select the rest and scroll right , the headers clearly are the following :

    Journal Entry

    Intercompany

    Batch ID

    Transaction Type

    Transaction Date

    Reversing Date

    Source Document

    Reference

    Currency ID

    Note

    Exchange Rate

    the lines are :

    Journal Entry

    Intercompany Id

    Account Number

    Debit Amount

    Credit Amount

    Distribution Reference

    Currency Id

    Rate Type Id

    Exchange Rate

    Receipt Id

    Payment Remarks

    Payment Reference

    Disbursement Application Id

    Disbursement Id

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Emouawad,

    i guess, if  you configured the Multicurrency Setup properly & the valid Exchange rate then the Above JE records are integarted successfully.

    please do a sample transaction with 1 or 2 records with Multi Currency transaction to check the integartion.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Hi Emouawad,

    If you want to integrate more number of transaction into GP with using IM. You should consider below are the points.

    1. If you using GP through Citrix client to integrate the transaction into GP. It will slow down your integration process based on your network connections.

    2. If you mapped file path is located in other than the Integration Manger installed machine(Shared folder). It will slow down your integration process based on your network connections.

    If you are meets any one of the above point, better you can paste the source file to GP&IM installed machine and run the integration. This will help you to increase your integration speed.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    Hey Soma , the integration is happening on the physical server.

    Natarajan , thank you for your reply . we do not have e connect at the moment but we will try to get it and test a couple of transactions and will get back here to post the results .

    please let me know if there is anything else to do besides e connect.

    thank you for your help guys

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    You mention your integration could potentially contain up to 30,000 transactions per run. IM was never designed for such volume. I have written custom integrations where it breaks up the import into batches. Perhaps in your cease I would try no more than 1,000 per batch. You can use Visual Studio and then eConnect or web services. If you want to use an integration tool there is Smart Connect from eOne. I believe they offer a 30 day free trial.

  • Community Member Profile Picture
    Community Member on at

    Dear Richard ,

    thank you for the helpful information.

    unfortunately i cannot break the file into batches , we will try to use any other alternative integration tools like suggested "Econnect or Smart Connect" .

    thank you again.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans