Search
Recommended Products
Related Links


 

 

Informative Articles

Can You Restore Your Data From Your Backup?
Can You Restore Your Data From Your Backup? -By Per Strandberg (c) 2003 data-backup-and-storage.com Making backup is vital! For small business people the value of their business is often stored on their computers. Emails, contracts, PowerPoint...

How To Fight Spam
HOW TO FIGHT SPAM (AND TAKE CONTROL OF YOUR INBOX) BY BB LEE (C)2002 (600 words) Spammers send out thousands of emails per day. They know most of the emails will be deleted but for every thousand they know one sucker will bite. The result,...

How to make good Elearning succeed in your Organization
1.What will good ELearning do for your Organization? According to a study by the IDC, worldwide spending on ELearning will surpass $23 billion by the end of 2004. However, with the current economic climate, companies are less inclined to spend...

Microsoft Great Plains: Interest Calculation Example – stored procedure for Crystal Report
This is intermediate level SQL scripting article for DB Administrator, Programmer, IT Specialist Our and Microsoft Business Solutions goal here is to educate database administrator, programmer, software developer to enable them support...

No Operating System
Imagine a computer with no operating system. If you can do that, you can imagine a computer that is extremely difficult to hack into. A computer that is almost immune to viruses. A computer that rarely crashes. Too good to be true? No, such a...

 
Google
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

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