This is a general question for everyone out there. What are the different methods available in GP 2010 to import a journal entry text file (either tabbed text or .csv) into GP 2010? Right now we are using a third party custom written application to import (works very well) that requires the user to manually activate the import process (i.e. enter batch name, batch date and select file) and then import the file. The utility then spits out the GL numbers that are not in the chart of accounts that are in the imported journal entry that need to be opened. The user opens those accounts and re-imports the file and posts the batch.
What I am interested in is automating this process. We need to eliminate the user from the process as much as possible. Is it possible utilizing the tools available in GP 2010 to import the above file and have that process somehow effectively handle the missing GL account (i.e. store the account until the user comes to work to allocate the account and then post the batch.)? We do not want to have GP 2010 automatically post any batches without first examining the batch so whatever the process GP 2010 uses needs to do that.
Any advice or guidance on this is greatly appreciated. Thanks.
Dave
Hello Dave,
Actually several methods are available, but the tough part is the account validation, take a look into options below:
1. Using Integration Manager: By using integration manager you can define the mapping between your file and the GL screen, you will need to write few lines of code to check if the account does not exist to be excluded and reported to the user, and you can schedule this to run periodically.
Logically this will work, but somehow I can't see enough stability measurements to accept this.
2. Using eConnect: If you have a developer, you can create a small application using eConnect to read your source file, exclude unavailable accounts or add the account with temp information and then integrates your journal, this is the best method but requires some developement.
3. Contact a Microsoft partner and find a ready made tool that do this for you, we at Dynamics Innovations has developed and integration adapter that will cover your needs and folks at SmartConnect might cover your needs as well.
4. Use GP Excel Paste, a tool provided for free if the GL is the only form you need, but for sure it cannot be scheduled and cannot validate accounts, instead it will simply copy lines from your file and paste it easily into Dynamics GP, take a look into the below link:
http://di.jo/GPExcelPaste.aspx
Hope that this helps.
Regards,
Mohammad R. Daoud MVP-MCT
Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx
Dave,
Adding to Mohammad's answer, SmartConnect from eOne leverages econnect but has a better interface more like Integration Manager. It can be scheduled to run, it can monitor folders and run when a file is arrives and it can isolate missing accounts. However, due to controls in econnect, if there are missing accounts, the file won't integrate. It can be archived off to a failed folder to be fixed later
To your request to simplify the process, SmartConnect can also integrat directly from Excel with the push of a button.
You don't say what the source is. If the source is being brought into Excel it's relatively easy to check the accounts against the live GP chart before integration using a refreshable Excel report or other SQL connection from Excel into GP.
For the dead simplest solution I would second Mohammad comments on GP Excel Paste.
Mark