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

---

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Business Plan Software Review: Ultimate Business Planner?

One of the main reasons business owners and entrepreneurs use... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

Linux ? Keyboard Or Mouse

Just stress testing one of the latest Linux distributions. Been... Read More

Microsoft Great Plains Remote Support - Overview

Microsoft Great Plains is now standard mid-market ERP application, serving... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Screenplay and Script Writing Software

When it comes to screenplay software each screenwriter needs to... Read More

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

Microsoft Business Solutions Great Plains has substantial market share and... Read More

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

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

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Should I Use Windows Update?

Should one use Windows Update?This topic has good and valid... Read More

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

.NET :Solving the Multiple Inheritance Issue Under .NET Platform

.NET platform does not support multiple inheritance. Do not confuse... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

Is Your Small Business Ready For A CRM Software Solution?

I have yet to see a business that, sometimes in... Read More