Navision attain c/odbc gemstone article ? customization case - software
Microsoft Commerce Solutions Navision is main ERP attention for European, Brazilian markets plus it serves vertical segments of the USA market, such as light manufacturing, POS, CRM. As our encounter indicates - Navision implementation requires more customization and tuning in assessment to an added mid-market ERP blend from MBS: Microsoft Great Plains. Our goal is to popularize Microsoft Commerce Solutions food and enlighten IT ancestors to do make to order Navision in-house.
Today, the main topic of this clause is running with native C/SIDE Navision Attain folder via C/ODBC interface, in distinct - Allied Ma?tre d'h?tel concept in Microsoft SQL Head waiter 2000 ecosystem and then Sales account aim in Gemstone Intelligence ver. 10. Let's begin:
1. We will use Navision Attain 3. 6 with Navision Catalog Server, Navision ApplicationServer and Navision Client. These module are installed on Windows XP Professional. To make possible C/ODBC border you need to fit this constituent from Navision Attain CD.
2. Let's build ODBC DSN for association to Navision database: Start -> Be in command of Panel -> Administrative Tools -> Data Sources (ODBC), then button to Arrangement DSN and click Add. We will use C/ODBC 32-bit driver. Give Data Basis Name Navision, Bond - leave it Local. As the folder (Database button) decide on Agenda FilesNavision AttainClientdatabase. fdb (this is demo DB). Then press Ballet company badge - in our case we use CRONUS demo database. Chief environment to endow with apposite association with C/SIDE catalog are adjust options for C/ODBC. Click Options close and look at the options accessible - we will pay consideration to Identifiers check out - this is where you setup identifiers to be transferred to client application. We will use these types: "a-z,A-Z,0-9,_" to make MS SQL Attendant 2000 work accepted with C/ODBC source. We are now done with ODBC DSN. Lets setup Allied Server
3. Open SQL Ma?tre d' Venture Manager. Open aim browser on the left side, choice Collateral and Allied Servers. With right click choice New Connected Ma?tre d'h?tel in the circumstance menu. In the emerging dialog window, in the menu Bringer Name choice Microsoft OLE DB Giver for ODBC Drivers. Let's name our Connected Head waiter as NAVISION. In the Data Find filament type in ODBC DSN name - NAVISION in our case. Connected Head waiter is ready. Cliquey tables list and we now see Navision Attain tables. 4. Now we need to conceive small method for Sales data extraction. Here is the text of the procedure: CREATE Formula NavisionSalesReport AS
SELECT * FROM OPENQUERY(NAVISION, 'SELECT * FROM Sales_Line sls, Consumer cust WHERE sls. Sell_to_Customer_No_ = cust. No_')
To elucidate its text: TRACEON(8765) directive allows functioning with the data fallout of capricious duration returned by C/ODBC driver. If we don't use this directive - we can't pull the consequences from Navision tables - we will get errors, like this:
OLE DB error trace [Non-interface error: Unexpected data distance end to end returned for the column: ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1']. Server: Msg 7347, Level 16, State 1, Line 1 OLE DB donor 'MSDASQL' returned an unexpected data distance end to end for the fixed-length editorial '[MSDASQL]. Ship_to_Filter'. The estimated data distance end to end is 250, while the returned data chunk is 1.
OPENQUERY assertion opens allied attendant and transfers its SQL command, and in its turn proceeds the consequence set. To test the formula type in this authority in SQL Ma?tre d'h?tel Query Analyzer: EXEC NavisionSalesReport 5. Now - launch Rock Reports, use average Wizard, coin new OLE DB (ADO) correlation with our MS SQL 2000 Head waiter and choice NavisionSalesReport method in the list. As the article fields we can use Description, Quantity, Line_Amount and Discount_Amount fields. You can group by name Name - this is buyer name. Our article is now ready! Happy customizing, implementing and modifying! If you want us to do the job - give us a call 1-866-528-0577 or 1-630-961-5918! help@albaspectrum. com
Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies - USA generally Microsoft CRM, Microsoft Great Plains customization company, portion Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Moscow, Europe and worldwide (http://www. albaspectrum. com), he is Microsoft CRM SDK, Navision, C#, VB. Net, SQL, Oracle, Unix developer.
Lotus Domino/Notes - Microsoft Great Plains Racing bike as ERP with Papers Workflow - Overview for IT
Lotus Domino/Notes - Microsoft Great Plains bike as ERP with ID Workflow - overview for IT SpecialistMicrosoft Commerce Solutions has the whole spectrum of affair applications, the good code seems to be Microsoft Great Plains and Microsoft CRM. In spite of this we need to admit that Microsoft is more or less new in the CRM advertise and also for large corporation it could not be a good idea "to put all the eggs into one basket".
5 Time-Saving Tips in Microsoft Word
Whether you have used Microsoft Word for years, have just switched from WordPerfect or are new to word processing, try these easy steps to save time and simplify your work in Word:Turn off Custom-made Menus and ToolbarsAlthough it is a default, Custom-made Menus and Toolbars is a terrible "feature" which restrictions your first view to choice toolbar buttons and menu commands. Do you only have one row of toolbars at the top of the screen? When you click on a menu, does it develop only after a few seconds? If so, you will save physically a lot of frustration by rotating off this adapted display:1.
Software Course of action Advance -A Lucrative Journey
Background: For many organizations like ours, the interim affect of achieving ISO 9001 or CMM levels is a disheartening task. Authority is no fun -Organizations eagerly acknowledge that go-getting to concentrate on projects according to ISO 9001 or CMM guidelines requires the conception of new procedures.
DVD Burning Tips
CD and DVD reproduction is a course of action that works by creating discs from scratch. Not to be bemused with duplication (the act of burning in rank onto readymade, commercially-available blank CD-Rs and DVD-Rs), copying relies on the use of molds to be the source of genuine discs that before now control digital data.
Great Plains Adroitness Description and Training Overview
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft Big business Solutions is in course of merging all its accounting applications: Great Plains, Solomon, Navision and Axapta into rather granular: Microsoft Financials, Microsoft HR, Microsoft Distributions, Microsoft Cast Accounting, etc. So the earliest conceive of Great Plains be supposed to be deemphasized.
Microsoft Small Affair Administrator eCommerce - Overview
Microsoft Affair Solutions Small Commerce Boss is scaled down Great Plains Adroitness based adaptation of Microsoft Great Plains or past Great Plains Dynamics/eEnterprise. Small Big business Administrator first delivery 7.
Beware of Spyware
One day, you rapidly accomplish that your cpu happening to work noticeably slower than it used to. You conclude to run de-fragmentation of your hard drive and add more virtual recollection to the system.
Microsoft CRM Customization
Microsoft CRM customization techniques are very diversified and based on the whole spectrum of hot Microsoft technologies. The main terms you ought to know are: Microsoft CRM SDK 1.
Crystal Intelligence For Microsoft Navision - Overview For Programmer/IT Specialist
Let us give you - developer some hints in the article creation. C/SIDE list - use C/ODBC to conceive the bond for your Rock Report.
Before September 1995, Microsoft Windows was an MS-DOS program. DOS was an easy to use charge line working coordination that provided you with absolute capacity to charge and troubleshoot your computer.
Crystal Hearsay for Microsoft Great Plains
Microsoft Affair Solutions - Great Plains is deliberate to meet and broaden the needs of small and mid-size organizations for its affair success. Its ample accounting and affair management applications also afford businesses with capabilities to make specially a range of modules of the Great Plains software to fit to their aspect needs.
Looking for an Choice to Microsoft Office? You Be supposed to Be!
Now is the time to look at an complementary to Microsoft Office.Are you protected into using Microsoft Word, Excel, and PowerPoint? Are you expenditure extra since you need a database, and Admission does not come with the basic Agency package?Well, the time has come to look at alternatives, or at least the one I¡¦ll argue here in a few moments.
Which Type of Shop Can Rely On A Home Built System?Not all shops are at a difficulty 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 advantage from a self built answer and what type is beat off purchasing one.
How To Identify, Cure and Check 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 exclusive of your consent, spyware software monitors or joystick your cpu use.
Microsoft CRM Indoctrination Secrets - Tips For Developers
This condition is for far ahead Microsoft CRM SDK C# developers. It describes the performance of aim SQL programming, when SDK doesn't have the functionality to do the job.
Microsoft Great Plains Central point East - Arabic Dialect Support
Microsoft Big business Solutions Great Plains is marketed for mid-size companies in North America, Europe, Asia Pacific, as well as in Central East.One of the strengths of Great Plains is its capability to be localized.
Microsoft CRM for Large Corporation - Security
Microsoft Big business Solutions CRM proved to be trustworthy elucidation in the whole spectrum of industries and marketplace niches: haulage & logistics, education, recruiting & placement, contribute chain management, pharmaceutical, oil & gas, aerospace & defense, manufacturing, extensive & retail. When corporation is looking into CRM claim to desire from - one of the fist questions is security.
A Guide To Purchasing Expert XP Icons Online And Enhancing Your Applications
Icons are used everywhere; right from software applications, to internet browsers, to in commission systems to websites and even in print media. But businesses have to waste a good deal of money and time in manufacturing icons on their own.
My Encounter - Assembly a Dream into Reality
Disclaimer: All the belief uttered are my views only! Your perception might differ..
Microsoft Great Plains Distribution, Barcoding, Load - overview for consultant
Microsoft Great Plains - ERM from Microsoft Commerce Solutions and formerly Great Plains Software is cute generic with its average set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization chronicle - Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Ability in print concentration has been and still is charismatic core platform for third party software change companies to write vertical and horizontal modules, in black and white as well in Great Plains Dexterity.
|home | site map|
|goldenarticles.net © 2018|