|
|
| www.1001TopWords.com |
|
|
Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options
Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Now Microsoft Business Solutions offers following ERP applications: Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Formerly Navision had strong positions in Europe. Now it is promoted in USA and Europe. Navision has pretty advanced manufacturing module. We would like to give you: programmer, software developer, database administrator the orientation in Navision customization tools ? C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. C/SIDE is the foundation for all the business management functionality of Navision. It is made up of five building blocks, called object types, which are used to create the application. These five object types are shared throughout Navision to create every application area, and give it a unified, consistent interface. This powerful language allows for the internal construction of new business logic and sophisticated reporting. Because of the internal nature of modifications it's highly recommended that you develop all your code in "processing only" report objects and called from the native code base. By grouping all your code in logical units, upgrades and additional modifications are easier to manage. ? C/ODBC and C/FRONT - Both C/ODBC and C/FRONT enable you to easily use information from Navision in familiar programs such as Microsoft Word and Microsoft Excel. The Open Database Connectivity driver for Navision (C/ODBC) is an application program interface (API) that provides a way for other applications, such as the entire Microsoft Office Suite, to send and retrieve data to and from the Navision database through the ODBC interface. ? External Tool: Navision Developer's Toolkit - The Navision Developer's Toolkit enables your Microsoft Certified Business Solutions Partner to upgrade your Navision solution to the latest version. It is used to analyze and upgrade customer and vertical solutions Reporting Options - Aside from the powerful internal reporting tool which requires an in-depth knowledge of C/SIDE to make it useful the other options are: ? Jet Reports- Jet Reports is a complete reporting package utilizing Microsoft Excel. Using Excel you can create reports on any table of data from within any granule in Navision. ? C/ODBC - Using the ODBC driver, the entire Microsoft office suite and programs such as Crystal Reports can access the database. I would recommend using this tool for occasional reporting requests only. If you need to pull data out of the Navision database on a regular basis one of the other options is a better choice ? Business Analytics (SQL Server Required) - Using Online Analytical Processing (OLAP) from Microsoft SQL Server? 2000, Business Analytics organizes all of your business data into information units called cubes. Using a familiar Microsoft Outlook®-style interface, Business Analytics presents this information to your desk top where easy to use analytical tools allow you to carry out targeted analysis that is tailored by you, for you ? XBRL - Extensible Business Reporting Language (XBRL) for Navision enables simple and dependable distribution of all a company's financial information and ensures smooth and accurate data transfer. XBRL is an XML-based specification that uses accepted financial reporting standards and practices to export financial reports across all software and technologies, including the Internet Good luck in customizing and reports design and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com About The Author Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies ? USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia, Moscow and having locations in multiple states and internationally (www.albaspectrum.com). You can contact Robert: welcome@albaspectrum.com; roberth@albaspectrum.com
|
|
|
|
RELATED ARTICLES
Microsoft CRM Customization - Processing In/Out-Going Email Messages We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator. How to Evaluate Staffing Software If you are in the market for new staffing software, I suspect that one of the most daunting of tasks will be to sift through the many vendors that are now servicing the staffing industry. Windows Screensavers Explained In this article you will find some background information about screensavers and their history. You will also learn how Windows screensavers differ from other programs and how you can use it to your own advantage. Also there are some tips for users owning laptops, notebooks or CD-burning devices. Photoshop Files and Formats People often ask me: What image file formats will Photoshop open or save in? What are the advantages/disadvantages? The Hidden Power of Online Manual Writing software manuals is boring, isn't it? We often think: "My software is easy to use. The user interface is intuitive. Why should I waste so much time for writing the document which nobody reads anyway?" Sometimes it's true ? I've never read the WinZip or Internet Explorer manuals ? everything seems clear without explanations. Nevertheless, even if your manual doesn't help to your software users, it may help to you. Publish your manual online and turn its hidden power into the real benefits for your business. Online Manual Makes Your Web Site Visible User manual is a huge bunch of words, the highly targeted words, which are specific for your software market. For instance, if you develop a database management system, its user guide will certainly contain such words as "database", "query", "transaction", "table", "record", and etc. On the other hand, people use these words in their queries when they are looking for a database management solution on the Google, Yahoo, or other search engine. Let the interested people to find your web site and your product. Upload your manual on your web server and make it available for indexing by search engine spiders. This area specific content will make your web site and your software more visible to potential customers. Making the user guide available online will increase your web site rank in relevant search results and will bring highly targeted traffic to web your site. Let the manual to work not only for your users, but for you as well.Online Manual Saves Your Time A picture worth a hundred words. Those who are engaged in user support know this for sure. When replying to user concerns, very often we have to write sentences like this "Open the Document settings dialog. Choose the External modules tab. Select the 'ABC Spell Checker' in the module list. Enter your registration key and verification code in the corresponding text fields which will appear at the bottom of the window. Then, press Activate". If your application is simple the user will likely understand you right and will do everything as you have explained. However, if your application is a complex system with lots of setting windows which behave differently in various modes, the user may be puzzled which window and which fields do you mean. In this case you risk getting into a long conversation by repeatedly explaining the same things again and again. The screenshot could be a very helpful illustration of your explanations. You may run your application, go to the certain window, open that tab page, activate the corresponding item in the list. Then make the screenshot of the window by using Alt+PrtSc key combination or another screen capture tool, save the picture in a file, and finally attach it to your message. Sometimes it's also necessary to add callouts, annotations and other enlightenments to the screenshot picture. Thus, you have to launch your image editor and to manually draw all the elements required. As you see, it may takes up to a half hour to reply to a single message only. And how many messages are yet in the queue? Having the screenshots prepared is a good approach which may save your time. But having screenshots already prepared together with callouts, explanations, and annotations is a great approach which will save you much more time. Most likely, you have all that stuff prepared in your software manual but it's not very polite to reply to the user: "Read that fantastic manual". User may have no idea where the manual is on the PC and on what page is the looked-for solution located. On the other hand, you may also have no time to manually cut particular pages with screenshots and related instructions from the manual and to attach them to each support message. The solution is easy. Put your manual on your web site in the form of HTML pages. Make all the pictures, screenshots with callouts, descriptions, and instructions accessible for every user. When you are processing another support request, simply insert an URL link to the appropriate page of your online manual and add just a few clarification words ? more words and pictures are already on that page. You will save much time and nerves because you will be sure that the user is looking at the same thing which you are describing. At the same time, the user will get a fast solution which is supported by clear pictures and neat instructions.Online Manual Makes Your Products Trustworthy Besides the users get the faster and more helpful support, they also see that you did this tedious job ? writing the handy and well structured manual with great screenshots and clear explanations. They know that this job is boring and developers don't like to do it. Therefore, if you did it and if you did it perfectly, it means that you respect your customers, not only their money. Good manual means that you consider your business and product seriously yourself. This helps your business to look more credible and serious. So, make your manual available online and prove your respect to your existing and prospective users. Make them trusting in you and in your product before they even download a demo copy of it.Online Manual Brings SalesAs we see, the software manual which is a part of your web site generates a targeted traffic. The people may easily find your product because online help makes your web site more visible in relevant search results on the search engines. Those new visitors get more loyal when they see a well done help system. Also, if a prospect experiences difficulties with your software and asks for technical support, you may easily resolve the issue by referring the user to a certain page of your online help. With just a one click the user will see screenshots and explanations which will help them to settle the case. So, you have a motivated and targeted visitor, who feels loyal to your company and products, and whom you can easily help in case of a technical problem. The probability of such visitor ordering a license is several times higher than of the average one. String in Java Handling character strings in Java is supported through two final classes: String and StringBuffer. The String class implements immutable character strings, which are read-only once the string has been created and initialized, whereas the StringBuffer class implements dynamic character strings. All string literals in Java programs, are implemented as instances of String class. Strings in Java are 16-bit Unicode. Internet Relay Chat - A Basic Introduction What is IRC? Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM. This article is brief review of Microsoft Great Plains integration with Microsoft Access. This is also applicable to Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary - DYNAMICS.DIC and runtime DYNAMICS.EXE) and Great Plains Standard on MSDE or MS SQL Server.If you are developer who is asked: how do we implement Great Plains integration/interface with your MS Access-based system ? read this and you will have the clues on where to look further.Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables. The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option. By the way you can program Integration Manager with VBA. Microsoft Access is ODBC compliant and so you can do direct Integration Manager query to MS Access eConnect ? it is type of Software Development Kit with samples in VB.Net. Obviously the development environment should be Visual Studio.Net. eConnect will allow you to integrate master records - such as new customers, vendors, employees, etc., plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above) eConnect is rather for ongoing integration. It was initially created for eCommerce application integration to Great Plains. SQL Stored Procedures. Obviously you have unlimited control and possibilities with SQL queries. You need to know Great Plains tables structure and data flow. 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. Do not change existing tables - do not create new fields, etc. Also you need to realize that each GP table has DEX_ROW_ID - identity column. Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems. Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager. You can also deploy this tool for EDI export/import. You can have DTS working with Linked Server - SQL Server Construction for linking to Microsoft Access Great Plains Dexterity Custom Screens. Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration. Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues. Also - Dexterity is in phasing our by Microsoft Business Solutions. Modifier/VBA custom buttons on the existing screens - alternative to Dexterity is you are comfortable with VBA and ADO. SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL. This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report. Warning - do not place existing GP tables into Replication! - you will have upgrade issues.Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com Microsoft Great Plains RW: Report Writer Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). C++ Tutorial 1, Introduction to C++ Introduction to C++ Lotus Domino: Application Integration ? A Programmer View There are two approaches for application integration: Microsoft Blues With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum. Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation Usually workflow & messaging is realized in CRM and then transactions are just logged into Accounting/ERP/MRP. In the case of Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Axapta the natural CRM choice would be Microsoft CRM. However typical CRM application targets Sales automation, which is usually not applicable to government structure, non-profit or public company (community services, public utilities, churches, charities, etc.). Not-for-profit organization needs purchasing and requisition workflow, payroll approval workflow, and in certain cases special General Ledger (GL) transactions workflow. Microsoft CRM doesn't provide the functionality. Then how could this be realized? We'll provide two scenarios to realize this customization: Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant Microsoft Great Plains has substantial mid-market share in the USA plus due to the marketing efforts of former Great Plains Software (now part of Microsoft Business Solutions) in Spanish Speaking South America, South Africa, United Kingdom, Middle East, Poland ? we see strong position of Microsoft Great Plains in these regions (on these markets MBS promotes two mid-market ERP: Great Plains and Navision). Unofficial Windows 98 SE Service Pack 2.0 RC2 Microsoft has never released a service pack for Windows98 SE, but I made a Service Pack for Windows98 SE users. Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product ? Great Plains provides such horizontal solutions as Collection department automation. The most common question we hear in collection department is how we assign problem clients to specific collection manager and how she/he works with them one by one, simply by hitting next arrow button. This is not possible in Great Plains Accounts Payable module and this is where Collection Management module comes to the scenes. Off The Record - Tips For Picking Recording Software Need software to record your voice, streaming audio or musical instruments? There are dozens of great products on the market. Some cost up to five hundred dollars, but here are some of the low cost alternatives you might want to consider. A Simple Computer Software Definition What is Software? DVD Burning Tips CD and DVD replication is a process that works by creating discs from scratch. Not to be confused with duplication (the act of burning information onto readymade, commercially-available blank CD-Rs and DVD-Rs), replication relies on the use of molds to produce actual discs that already contain digital data. It is the preferred and recommended mode of mass production for quantities in excess of 500 units. Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:
|
| © Athifea Distribution LLC - 2013 |
