Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

• 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 customization and reporting 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

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: andrewk@albaspectrum.com

---

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More

Cisco Certification: Introduction To ISDN, Part IV

In part III of this ISDN primer, we learned that... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Preventive Maintenance Software Companies

Several software companies design programs for preventive maintenance. Most of... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Corporate Accounting System: Microsoft Great Plains ? Overview

Corporate ERP/MRP selection might be tough one, especially considering very... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Can Group Collaboration Software Meet Business Needs?

According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More