Microsoft Windows Java ISDN Information
Computer Software Management Products
|
|
|
Microsoft Windows Java ISDN Information |
| ||||
|
| ||||
|
SEO Elite marketing software - Norton Anti Virus - Create easy web video - Great software downloads - Music Movies Games Software | ||||
|
You are free to use content from this page in your blog or website, in return for a link back to this page from that blog or website.
Navision Attain C/ODBC Crystal Report ' Customization Example
Microsoft Business Solutions Navision is main ERP application for European, Brazilian markets plus it serves vertical segments of the USA market, such as light manufacturing, POS, CRM. As our experience indicates ' Navision implementation requires more customization and tuning in comparison to another mid-market ERP solution from MBS: Microsoft Great Plains. Our goal is to popularize Microsoft Business Solutions products and enlighten IT people to do customize Navision in-house. Today, the main topic of this article is working with native C/SIDE Navision Attain database via C/ODBC interface, in particular ' Linked Server creation in Microsoft SQL Server 2000 environment and then Sales report design in Crystal Reports ver. 10. Let's begin: 1. We will use Navision Attain 3.6 with Navision Database Server, Navision ApplicationServer and Navision Client. These component are installed on Windows XP Professional. To enable C/ODBC interface you need to install this component from Navision Attain CD. 2. Let's create ODBC DSN for connection to Navision database: Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC), then switch to System DSN and click Add. We will use C/ODBC 32-bit driver. Give Data Source Name Navision, Connection ' leave it Local. As the database (Database button) select Program FilesNavision AttainClientdatabase.fdb (this is demo DB). Then press Company button ' in our case we use CRONUS demo database. Important conditions to provide proper connection with C/SIDE database are correct options for C/ODBC. Click Options button and look at the options available ' we will pay attention to Identifiers screen ' 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 Server 2000 work correct with C/ODBC source. We are now done with ODBC DSN. Lets setup Linked Server 3. Open SQL Server Enterprise Manager. Open object browser on the left side, select Security and Linked Servers. With right click select New Linked Server in the context menu. In the emerging dialog window, in the menu Provider Name select Microsoft OLE DB Provider for ODBC Drivers. Let's name our Linked Server as NAVISION. In the Data Source string type in ODBC DSN name ' NAVISION in our case. Linked Server is ready. Select tables list and we now see Navision Attain tables. 4. Now we need to create small procedure for Sales data extraction. Here is the text of the procedure: CREATE PROCEDURE NavisionSalesReport AS DBCC TRACEON(8765) SELECT * FROM OPENQUERY(NAVISION, 'SELECT * FROM Sales_Line sls, Customer cust WHERE sls.Sell_to_Customer_No_ = cust.No_') RETURN To clarify its text: TRACEON(8765) directive allows working with the data results of variable length returned by C/ODBC driver. If we don't use this directive ' we can't pull the results from Navision tables ' we will get errors, like this: OLE DB error trace [Non-interface error: Unexpected data length 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 provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].Ship_to_Filter'. The expected data length is 250, while the returned data length is 1. OPENQUERY statement opens linked server and transfers its SQL command, and in its turn returns the result set. To test the procedure type in this command in SQL Server Query Analyzer: EXEC NavisionSalesReport 5. Now ' launch Crystal Reports, use standard Wizard, create new OLE DB (ADO) connection with our MS SQL 2000 Server and select NavisionSalesReport procedure in the list. As the report fields we can use Description, Quantity, Line_Amount and Discount_Amount fields. You can group by name Name ' this is customer name. Our report 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 nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Moscow, Europe and internationally (http://www.albaspectrum.com), he is Microsoft CRM SDK, Navision, C#, VB.Net, SQL, Oracle, Unix developer.
Cat 18793 |
|
|
|
RELATED ARTICLES
Photoshop Files and Formats People often ask me: What image file formats will Photoshop open or save in? What are the advantages/disadvantages? Microsoft Great Plains Nationwide Remote Support ERP Consulting industry is on the way to serve clients nationwide and even worldwide, when the client is multinational corporation. There are several reasons to specialize in remote support. In this small article we'll give you these reasons and the advantages of remote installation, customization, integration, programming, reporting. Making The Decision To Automate Your Software Testing Not every software testing project can or should be automated. Before your department accepts a new test automation project, you should establish a process by which projects are reviewed and either accepted or rejected. This can be done with a simple Test Automation Acceptance Checklist. Microsoft CRM Implementation & Customization: MS CRM Fax Gateway With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion. Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ' Future Directions IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem. Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging in MS CRM through Domino. Our customers suggest future direction for the connector. Considering our consulting practice experience in MS CRM and Lotus Notes customization, upgrade, integration ' in this small article we'll reveal our half year development plans Software: What Suits Me' Almost all new and major brand of PCs come with bundled software packages that can handle both business and personal needs. Screenshots Vista Windows Features Additionally, Vista will include many other new features. How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software Fortunately one of the most common reasons cited for the high failure rate of CRM systems - poor data quality - is also one of the easiest to avoid. Your CRM software is only as good as the information it contains. As the old programmers motto goes 'garbage in, garbage out'. Microsoft Great Plains Project Accounting ' Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. Great Plains Project accounting future is uncertain - it will not ( according to rumors in Microsoft) become the base for one of the Microsoft suites. However right now it is used by variety of businesses and has good functionality to fit general project accounting needs. Microsoft Great Plains Payroll Module Customization Scenarios It is now common thing when large corporation selects mid-market ERP or so-called standard functionality MRP solution as its corporate accounting system. Microsoft Business Solutions Great Plains is very good candidate. As all MBS ERPs it has MS SQL Server 2000/2005 database platform and allows you to deploy customizable and altered solution, serving large corporation HR department. If you use US / Canadian Payroll module as paycheck solution for internal employees ' you probably don't need custom logic. In this small article we'll show you the way of tailored integrated solution for nation-wide placement agency. Destination: Desktop for Google First we had the original Google search that evolved into the leader in its class. In fact, it became so popular that the word "google" worked its way into our everyday language as a verb, as in "to google" something. Google later introduced a toolbar that was plug-in for some browsers like Internet Explorer. The Google toolbar features a direct Google search box with quick access to image and group searches, a pop-up blocker, and for Internet marketers mostly, a PageRank (PR) indicator. Microsoft Great Plains Multicurrency ' Overview For Implementation Consultant When you first think about multicurrency ' you probably have in mind the revaluation question. Currency triangulation ' which was the need when European currencies were fixed to Euro is not an issue any more. ERP Software Financing: the Future? ' Overview for Company Owner In our case ' we serve Microsoft Business Solutions ERP and CRM products: Microsoft Great Plains, Microsoft CRM, Navision, Microsoft RMS, as well as we do customization and integration to these products. We would like to share with you our experience with financing through Microsoft Financial Corporation, the entity handling software financing for Great Plains, CRM, Solomon, Navision & Axapta. What is Groupware' Vince Lombardi once said that, "The achievements of an organization are the results of the combined effort of each individual." If this is the case, then what do we need to do in order to insure success in our companies? How can we combine the efforts of each individual as Mr. Lombardi said was so key to the success of a particular organization? While there are many possible solutions to these questions, I have found something that will help your company become more organized, and your employees more unified in their work. I am talking about groupware. Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ' overview Microsoft Business Solutions Great Plains has substantial market share and strong support by Microsoft on the US market. Currently we see the trend in the vertical markets when companies with custom-built accounting application, usually written on legacy platform are switching to standard and proven ERP solution and customize or tailor it to fit their vertical market requirements. We'll be publishing series of vertical articles: Logistics, Distribution Centers, Warehouse Management, Barcoding, Shipping/Receiving, eCommerce, EDI, Wholesale. Today we'll give you Wholesale tailoring scenario Implementing ERP for Large Publicly Traded Corporation ' Microsoft Great Plains We would like first emphasize the change in the paradigm. If you look back ' 20 years or even 10 years ' those days you saw ERP/MRP monster applications/systems winning time. Everyone wanted to be looking large and, especially due to traditional business consulting sales efforts ERP applications were sold to large and mid-size clientele. The proposed strategy was: you need three components: Accounts Payable: A Powerful Document Management and Workflow Solution Accounts payable is just one area of office management where problems arise because of the sheer complexity of transactions, and the vast amount of paperwork that is generated. Microsoft Great Plains Reporting ' Overview for Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ' Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports. If you are developer who is asked: how do we create report for Microsoft Great Plains ' read this and you will have the clues on where to look further. Great Plains Report Writer (ReportWriter) ' this is built-in reporting tool. All the original report in Great Plains are written in ReportWriter. ReportWriter itself is Dexterity module. You should use this tool if you would like to modify existing Great Plains reports, such as Blank Invoice Form - here you can place your company logo, change the positioning, fonts, colors, etc. ReportWriter will allow you also do new reports - simple option if you want to export all the records from one Great Plains table - use it. New report, however doesn't have interface where you would enter parameters - so it is not useful for real custom reports. Another limitation of ReportWriter - you can not do cross-modules report - when you need sales and purchasing info on the same report for example. FRx. This is excellent tool when deal with financial reporting - it works on the General Ledger level (Balance sheet, P&L, Cash Flow Statement, etc.). It also allows you to do multiple companies consolidation - when you do consolidated Balance Sheet (with inter-companies transactions elimination). Smart List - Export to Excel ' this is nice feature in Great Plains - you could create a list with simple criteria and then export it to Excel. Crystal Reports. It gives you unlimited functionality. Obviously flexibility requires you to know Great Plains table structure: Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ' it should be RM00101 ' customer master file. If you need historical Sales Order Processing documents ' they are in SOP30200 ' Sales History Header file, etc. Create ODBC connection to GP Company database. Use the same technique as when you create standard ODBC connection for GP workstation ' but change default database to targeted company database. Create SQL Query to probe the data ' we always recommend tuning your query and see that you are getting adequate results ' in any case ' Crystal Report is just a nice tool to show the results of your query. Direct Web Publishing off Great Plains databases ' yes - it is easy now with Visual Studio.Net and you can hire good programmers. This is good - Microsoft Business Solutions products: Great Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Business Portal - which will have web interface - you can get the idea if you look at Microsoft CRM web client - so direct web publishing is good taste. SQL Queries. If you have SQL background - this is great field for you. You know - with properly formatted SQL query you can realize simple EDI export/import for the integration with legacy systems. Happy designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com The True Meaning of Freeware The vast majority of us will have, at some point, had freeware games or applications installed on our systems. If you've played an online Java or Flash based game, you've used freeware. In a very real way the Internet itself is freeware, a massive collections of scripts, information, tools and resources that are, for the most part, totally free. But what is it that motivates so many people to put so much work into a project, and then release it totally free of charge? There are a few misconceptions about freeware that I would like to clear up. CRM 101: Customer Relationship Management for Beginners Customer Relationship Management, abbreviated "CRM," is the term for a business strategy that is designed to improve customer service. CRM is also designed to increase customer satisfaction and gain new customers, thus increasing a business' revenue. CRM is a term that can be applied to software and an entire business strategy.
|
 |
| Copyright © 2009 www.dovada.net.au |
