Released on: 12, September 2008
, Author: Alba Spectrum
, Audience: Software related
If your Microsoft Dynamics GP environment contains several companies and you deploy GP Intercompany module, and your Vendor Invoices are coming through external system, integrated with Dynamics GP, then here are highlights for consultant on designing integration in GP Integration Manager. As you will need to build AP transaction GL distribution lines, this integration is not recommended for initial introduction to IM and probably should be trusted to Dynamics GP consultant or better to say Great Plains Technical Consultant. If you have external EDI system, or you will need to pull records via SQL queries, available in Advanced ODBC data source, chances are high, that you will have to use one table, where you will have to group records for invoice header and then use SQL union to add second half of the distribution, usually AP account
1. Intercompany Transaction flag. If you want to enable cross company posting, then you should set intercompany flag in Invoice header to true.
2. Intercompany Distribution. As you know, in AP intercompany invoice, you add company ID in the GL distribution line, and usually for Purchasing account, while Accounts Payable account remains in the source company
3. Adding AP account. In your advanced ODBC source you can select existing records, and AP account you add through union addition to your normal select statement. If you use text file driver this work is extremely buggy, but if you use ODBC connection to MS SQL Server table, then union addition should be relatively easy programming routine
4. Microsoft Text Driver known issues. When you create new ODBC DSN, based on the text file, there seems to be problems, and they are consistent for Windows XP, Vista, Windows 2003 and R2. We recommend you if you face these problems do not use column type and width guess wizard
5. Additional Notes. If your export file is text EDI code, you may try to first import it to SQL EDI tables to resolve text driver limitations and then work with more established SQL Server Advanced ODBC source
Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions for the customers in CA, IL, WI, NY, FL, IN, MI, TX, GA, NE, NM, AI, NC, SC, OR, WA, DC, DE, PA, VI, AZ, LA
Related downloads
PASSPORT Host Integration Objects offers a programmatic, Windows-based method of integrating 3270 and 5250 host applications with other ActiveX or .NET applications. Includes the object components, documentation, test programs and source code.
BlueSky Integration Studio is a visual integration design environment for extracting, transforming, and loading (ETL) data from any data source – to any data source allowing you to write code behind to transform your data in standard VB.NET!
Some News is a customized news-themed browser that delivers easy access to the major news media networks. Read some news delivered from Fox, CBS, CNN, ABC, NBC, the Nando Times, News.com, and Yahoo with ease by utilizing tabs.
News Talk Radio 24/7 Toolbar right on your browser. Listen to Hannity, Radio Factor, Fox News Radio and more compelling talk radio like Rush Limbaugh free. This toolbar also delivers news alerts, video and more to your browser.
Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven game-accompanied sound-topics and changing backgrounds gives Blocker Plains a long prolonged motivation.
Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven sound-topics with different listener-positions and changing backgrounds gives a long prolonged motivation.
With jk-ware Theater Blocker Plains, Color LIFE Sound and Perpetuum mobile can be started multiple times and run simultaneously. Think and purpose of jk-ware Theater is to test the capability of modern computers playfully.
The Trader Notes allows:
To watch changes of the portfolio in a real-time at in securities trading at stock exchange;
To enter the accomplished transactions;
To create personal notices and records which will help to achieve discipline
Automatically searches news on certain keywords from around the World Wide Web and keeps track of the latest news. Once updated news is available, you would be informed by a Desktop Alert.
.NET News Vista Gadget is a project developed by Blocks4.NET in order to notify .NET users / developers community about latest .NET components news.
