Presumably every Great Plains specialised advertising advisor is conscious the right way to construct somewhat one thing like Income Invoice integration, possessing two textual content material paperwork.  One could be doc header and the 2nd only one is doc traces file.  Hyperlink relies on Doc quantity.  Nevertheless, what in case you have solely only one file, the place doc quantity is present on each line?  Or if it’s a must to cope with textual content material file, which is coming from legacy billing method within the number of textual content material report, readable by human, nevertheless it has paragraphs, web site figures, headers and traces (and all these are coming from Unix field, which you might be unable to vary)?  How about this circumstance – you’ve Excel desk, the place you’ve a lot of objects talked about on the precise row?  What if data is sitting someplace in Oracle Databases and it’s so substantial, that it could possibly be impractical to drag it out into the textual content material file – instead it is advisable have to drag it straight from Oracle?  In these individuals or comparable circumstances you ought to think about deploying integration primarily based on Extremely developed ODBC question.  Let’s try to look at illustrations specified over and the way they must be handled:

1. Learn how to construct the combination from only one useful resource file, the place line has doc quantity and the merchandise quantity, description, amount and worth?  This instance is present in IM pattern integrations, assessment GL Entry with only one useful resource file.  It’s a must to group simply only one column doc quantity and this will provide you with header desk question.  In sure circumstances you don’t have doc quantity, however more than likely have some form of grouping column (transaction date, should you construct each day invoices, in case you have many consumers for each working day, than incorporate purchaser ID into grouping as properly)

2. CSV or Excel file, the place you’ve a lot of objects with portions on the precise row.  Right here you might be leaping into modern ODBC queries.  In modern ODBC question you need to use such SQL constructions as Union.  You’ll be able to unionize a lot of Discover statements, the place preliminary only one will get merchandise quantity and amount from the preliminary and 2nd columns, the 2nd Discover will get merchandise and amount from the third and fourth columns and so forth

three. Textual content material report coming from the Unix field within the number of readable by human Invoice, Receive Purchase doc.  Is it really attainable to by way of somewhat one thing like that straight to the Great Plains Integration Supervisor.  Anyone from GP consulting neighborhood may say – No method!  Nevertheless, lets fascinating down and speculate somewhat little bit about SQL and doc parsing.  How have you learnt which textual content material traces you wish to extract?  All of them are more than likely starting from the precise state of affairs, in addition to they’ve a lot of columns each of them additionally begins on the set state of affairs of the doc.  And now, more than likely all of the headers, room traces and web site figures have empty character on the precise preliminary state of affairs, the place you merchandise traces have respectable character.  So, the SQL assertion is more than likely not extremely elaborate, you simply use necessities Precisely the place preliminary character of the self-discipline quantity only one isn’t like room character…  And by the way in which, the precise ultimate results of removing room traces, headers and different non-legitimate traces – could possibly be realized in VBA scripting in Earlier than Doc celebration – however this can be a little one thing you’ll be able to try in your possess if you’re comfortable in VBA scripting

four. Integration  Supervisor because the useful resource to browse EDI formatted textual content material file.  In EDI (Digital Doc Interchange construction) you could properly have way more impediment, nonetheless IM affords you the vitality to specify dividing character (it could possibly be Coma, Tab otherwise you title the character, obligatory by EDI construction).  However even when your EDI protocol is definitely tough to parse, it is best to assessment Discover assertion with exact self-discipline formatting

5. Inspecting data straight from SQL primarily based ODBC compliant useful resource.  No matter it’s – Oracle, MySQL/PHP, Microsoft Receive, SQL Server, Pervasive SQL/Btrieve, Ctree, you title it, assuming that there’s ODBC driver to get hyperlink from Microsoft Residence home windows functioning method (as Integration Supervisor is available on Microsoft functioning method platform solely) to your databases.  One of many approaches we wish to advise is that this.  Think about creating Related Server design in MS SQL Server Administration Studio 2008, 2005 (or Firm Supervisor if you’re on SQL 2000).  Linked Server will current hyperlink by way of ODBC driver (ordinarily System DSN) to your third bash databases.  Second part is that this – you construct cross-platform SQL See.  And then you definitely construct your Extremely developed ODBC question primarily based on the have a look at, simply established in Microsoft SQL Server.  Such views could possibly be so extremely efficient that you could be properly try actually deep historic Income and Getting data conversion, by importing substantial Income butch of paperwork (for, say only one historic month) after which submit them in Dynamics GP client workstation (must more than likely think about uncheck publishing to and thru Commonplace Ledger, as you’ll do both GL first balances or consolidated common month-to-month transactions for historic GL data migration)

6. VBA Celebration Managing Scripts.  For those who think about, that you’re not so comfortable to code elaborate SQL Views (with issues and circumstance statements, stuff like that) – you are able to do the precise in VBA celebration handlers.  In our impression, SQL is somewhat one thing the place know-how powering is capitalizing on aggregation mom nature and because of this facet – SQL is a method faster, evaluating to cursor pushed logic, which you’ve when engaging in VBA scripting (SQL could properly nonetheless use aggregation, however each doc ought to forestall and wait round till VBA script in celebration handler does its work).  So, should you method to hold historic data out of your legacy accounting method (Peach Tree, QuickBooks, MYOB, SAP Enterprise Only one, Accpac, and so forth.), the place the quantity of information is substantial and you could properly must need to repeat examination conversions varied time, previous to the final conversion – we advocate you to do data therapeutic therapeutic massage in SQL Views straight, versus VBA celebration handlers

7. Extremely developed ODBC integration circumstance scientific assessments.  One among them could be eCommerce quasi genuine time integration, the place you browse ecommerce shopping cart transactions every, say 10 minutes and carry them over to Dynamics GP by way of Integration Supervisor SOP doc integration.  IM could possibly be scheduled to fireside integration every 10 minutes by way of Residence home windows macro plan and scheduled duties.  For those who use new know-how – eConnect connectors for the combination – these integrations don’t even require Dynamics GP client workstation to be usually on (reverse to plain IM know-how, the place Great Plains workstation was made use of as OLE Server and because of this it skilled to be jogging, consuming only one treasured Great Plains concurrent client license)

eight. eConnect or how one can break up by way of earlier Integration Supervisor efficiency hurdles.  In Dynamics GP version ten. (and of program present version 2010/eleven.) in Integration Supervisor now you can deploy integration targets, primarily based on eConnect connectors.  Let’s try to happen by way of some excurse into eConnect know-how alone.  eConnect was associated with Microsoft Problem Inexperienced (later remodeled into Microsoft Dynamics process), the place the plan was to deemphasize such commonplace Company ERP shells, resembling Great Plains Dexterity, coded in C programming language, and instead rewrite firm logic in SQL Saved Methods.  SQL Saved Technique must function faster, evaluating to Dexterity cursor, the place computation preliminary takes place in Dexterity Sanscript code, then it interprets into C++ code after which ultimately into Microsoft Assembler to switch steering to your AMD or Intel processor .  New design and elegance eConnect connector phone calls SQL saved methods to hold out the combination, evaluating to earlier know-how, the place preliminary it’s a must to provoke Dynamics GP OLE Server, then open Great Plains selection (on OLE stage), fill in each self-discipline, then submit it for validation and if something is sweet, preserve the file by way of the range Save button click on on

9. If we you shouldn’t have Integration Supervisor module license, is it Okay simply to do speedy SQL Insert assertion?  On this circumstance you must have an understanding of your decisions and hazard zone.  Nice Plains Dynamics and its successor Microsoft Dynamics GP allow you to do data restore and insertion straight into SQL company databases.  It’s a nice vitality, nonetheless, by engaging in so you could properly compromise firm logic and wreck your Company ERP paperwork.  Because of this we really feel that buying Integration Supervisor software licenses shall be improved possibility

ten. If we’re on earlier version of Great Plains and we do have Integration Supervisor license, what’s attainable and what’s not, evaluating to newest version of Dynamics GP 2010? Correctly, Integration Supervisor was launched with simply one of many preliminary releases of Great Plains Dynamics, the place it was primarily based on OLE Server know-how.  The one limitation we may level out is more than likely eConnect data connectors, the comfort must be extremely comparable and we don’t see the troubles to deploy Integration Supervisor

eleven. We’re upgrading our Great Plains Dynamics (version 5., 6., 7., 7.5, eight.) to Microsoft Dynamics GP ten (9., 2010/eleven.) and we use a lot of Integrations.  Is there enhance method for the Integration Supervisor?  There may be enhance method, it isn’t inspired for inside enhance, you must get in contact along with your Microsoft Dynamics GP Advertising advisor

12. I’m programmer and I wish to discover ways to program VBA handlers for Integration Supervisor.  The place must I begin off?  To start with allow us to level out that modern-day VB.Web programming language is somewhat bit distinct (or maybe improved to say a method way more distinct), evaluating to earlier Seen Important.  VBA (Seen Important for Apps) scripting is type of subset of earlier Seen Important.  You ought to look at such techniques as ADO (not the ADO.Web, however commonplace only one).  VBA scripting is the way in which to switch such Microsoft functions as Excel, Phrase, MS Receive (the place VBA scripting is the useful resource to animate MS Receive Sorts and Research).  There may be additionally VBA programmer handbook, available on Dynamics GP DVD/CDs, the place you’ll be able to uncover illustrations of VBA celebration dealing with codes

13. To ask for additional extra help, it is best to get in contact with us 1-866-528-0577, assist@albaspectrum.com We have to have to debate your playing cards in get to advocate you the best solutions, which isn’t contingent to our preferences.  We offer you Usa/Canada nationwide by way of distant help (net durations and phone/skype conferences).  Native assist is available in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston spot of the situation of Texas

You may also like

No Comment

You can post first response comment.

Leave A Comment

Please enter your name. Please enter an valid email address. Please enter a message.
Rankie WordPress Plugin