Microsoft great plains integration executive ? functioning with text file - software
Microsoft Commerce Solutions main average bazaar ERP concentration - Microsoft Great Plains has compound integration options: MS SQL Scripting (stored procedures and views), ADO. Net programming, Microsoft SQL Attendant DTS packages. You emphatically can arrange such SDK tools as eConnect. In spite of this here we would like to show you how to agenda the simplest user gracious tool: Microsoft Great Plains Integration Manager. Multiple times in our consulting apply we saw the need to integrate Broad-spectrum Ledger transactions from one text file and here we give you this and even more complicated case, when accept and debit amounts are award on the same line with their own balance numbers. Let's begin to have that we have tab encircled text file, GLSOURCE. txt. Here is how the line looks:
"11242004" (date) "11020016000" (debit account) 212446. 68 (debit amount) "15260005400" (credit account) 212446. 68 (credit amount)
Pretty challenging, isn't it?
First of all and this is in all probability easy - you need ODBC DSN, use Microsoft Text Driver, alteration duck directory, choice the file and button to tab enclosed type.
Next, open Microsoft Great Plains Integration Director and coin two new queries - one will be for the Heading and the be with for circulation lines in GL transaction. In both cases use Difficult ODBC type of text queries.
GL Heading be supposed to accumulate by date, so in its SQL display enter this:
select F1 from GLSOURCE. txt group by F1
Now the lines - here we need unionizing and read-through if quantity is not zero:
select F1, F2, F3, 0 from GLSOURCE. txt where F3'' union select F1 F4, 0,F5 from GLSOURCE. txt where F5''
The one above is the most challenging part of this article. Entertain absorb it - we are splitting line into two by union, first we construct debit part and then we affix belief part, plus we are weeding out 0 amounts.
Next - we need to link two queries - basically link them by F1 field (date). Do it in query relationship. When you are done with linking, right click on the arrow, open properties and in Cliquey Bond Type display adjust to:
There can be 0 or more account in the child for each background in the master.
This is chief - we'll have more than one line in GL distribution.
The rest be supposed to be customary for IM consultant.
Select destination as GL Journal, assign transaction date and batch ID as F1 from Heading query, alter to entries and choice them from debit and belief parts of the lines query.
As extra tools in filtering your text query you could use VBA scripting and even translation.
Translation is the way to go when you need to interchange bill information from the text file with altered or translated financial records in Great Plains.
Happy integrating! if you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum. com
Andrew Karasev is Chief Knowledge Bureaucrat in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM customization company, allocation Chicago, California, Colorado, Arizona, New York, Texas, Florida, Georgia, Canada, UK, Russia, Europe and Australia and having locations in many states and globally ( http://www. albaspectrum. com ), he is Dexterity, SQL, C#. Net, Gem Information and Microsoft CRM SDK developer.
Cisco Certification: Inauguration To ISDN, Part III
Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that might cause the link to stay up, we need to look at ISDN substantiation schemes. The two methods Cisco qualifications candidates must be comfortable with are PAP and CHAP.
Blind CC (Bcc): Master Its Use When E-Mailing
If you use Microsoft Outlook (or analogous applications) for e-mailing, then you are accustomed with the fields at the top of a new mail message, right? Of course, in the "To..
Lotus Domino: Concentration Integration - A Programmer View
There are two approaches for attention integration:? Programmer's accost - for applications integration it is crucial to coin some course codes;? Integrator's accost - in this case distinctive software crop are to be used and the integration administer set up by those software settings. The subsequent tools may be used for the first approach:? ODBC.
Four Desktop Tools To Drastically Become more intense Your Productivity
What Stands After The Software Description?
With thousands of web pages added to the Net every day, it's in receipt of more and more frustrating both to acquiesce the in order to the interest of those, who are concerned in it and to find the in a row one needs.The challenge is even annoyed with the fact that customers be converted into more taxing to the crop they are offered.
Software Companies: Breed New Revenue Streams and Decline Costs with Custom e-Learning Content
It's no clandestine that software companies carry out in a very competitive space where competition is increasingly fierce and where profit margins can be razor thin. New, lesser software companies are emergent up each month and the important software companies persistently make brawny advancements ahead leveraging bulky cash flow reserves.
String in Java
Handling atmosphere strings in Java is supported by means of two final classes: Cord and StringBuffer. The Chain class kit incontrovertible creature strings, which are read-only once the chain has been produced and initialized, while the StringBuffer class kit dynamic atmosphere strings.
Great Plains Adroitness Customization Options - Overview For Developers
Looks like Microsoft Great Plains becomes more and more popular, moderately for the reason that of Microsoft muscles at the back it. Now it is under attack to the whole spectrum of horizontal and vertical promote clientele.
How To Identify, Cure and Avoid Spyware/Adware Infections
Just when you attention you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your central processing unit lacking your consent, spyware software monitors or gearshift your central processing unit use.
Can You Analyze Byzantine Monetary Calculations?
Are you a whiz at calculating pecuniary information? Not the easy personal stuff, like figuring out your monthly credit based on a fixed appeal rate for x amount of years, or how much money you have obtainable each month after all your bills are paid. (You can in all probability use your fingers to be included that one out!)But the hard stuff, you know, the belongings you need to know when you're in succession a small business.
Exactly What Does FTP Stand for and What Can it do for Me?
FTP stands for "file assigning protocol". FTP is chiefly a way of transfer files over the Internet.
Microsoft Great Plains Dynamics on Enveloping SQL.2000 Data Darn - Overview For DBAs
Some beginning into Great Plains Software products, now Microsoft Big business Solutions. Microsoft Great Plains becomes more and more popular, moderately for the reason that of Microsoft muscles after it.
C++ Tutorials: 3, Course Flow (If, Else, While, For)
Program Flow is what you think it is. How the course will flow.
Navision Attain Catalog contact via C/ODBC in ASP.NET Application
Navision Software was purchased by Microsoft and now it is supported by Microsoft Big business Solutions at once with Microsoft Great Plains, Axapta, Solomon, Microsoft Retail Management Arrangement and Microsoft CRM. Navision has exceedingly beefy arrangement on mid-size European and US markets, plus it has first-rate manufacturing solution.
Demand More From Your Lead Tracking Software
An central part of any attribute CRM approach is lead tracking software. This is the part of the coordination that helps you arrange consumer data from your sales force.
Theres Gold in Your Websites Ma?tre d' Log
Many Webmasters have never disturbed to view their website's attendant log. Ignoring your attendant log is like hasty with a blind pilot.
Microsoft CRM and No-Frills Cadillacs
In today's affair world it's all but difficult to avoid Microsoft. Both you're using MS applications, mounting your own, or negotiating your company's acquisition by this techno-behemoth.
Which Type of Shop Can Rely On A Home Built System?Not all shops are at a burden when it comes to shop their own system. To agree on which boulevard a shop be supposed to take, owners must know what type of shops allowance from a self built elucidation and what type is change for the better off purchasing one.
Microsoft Great Plains Integrations - Retail Management Sample
Microsoft Affair Solutions is emerging as very beautiful vendor for mid-size companies. The concentration of its foodstuffs is in their cross integration potential.
The Truth about Colossus: Are You Just A Charismatic Image?
What is Colossus?Colossus is software approved to about twenty-five assurance companies to aid in predicting the clearing value of claims. The cover conscientiousness maintains it is a beneficial tool as it considers a great many factors, and the clearing morals are just a range for use in any way the insurer wishes.
|home | site map|
|goldenarticles.net © 2018|