The Wayback Machine - https://web.archive.org/all/20050307064359/http://www.albaspectrum.com:80/
Index

Alba Spectrum Technologies - serving Microsoft Business Soltutions community, promoting Microsoft Great Plains customization: Dexterity sanscript & COM Object, SQL Server, Crystal Reports, VBA/Modifier, FRx, ReportWriter, upgrade for Intellisol, Mekorma, Kampdata, Wennsoft, Great Plains Accounting, Dynamics, eEnterprise; Microsoft CRM customization - Microsoft CRM SDK, C#/VB.Net programming; Microsoft Retail Management System (Microsoft RMS) integration, interface and custom development. Being developer, programmer, Database Administrator - publish your article and help IT people worldwide to support MBS Products

© 2005 Alba Spectrum Technologies. Alba Spectrum Technologies is worldwide trademark of Scitus Corporation, MBS Partner, ICS Advantage is our Navision SC

Microsoft Great Plains Microsoft CRM Microsoft Navision Microsoft RMS Microsoft CRM Customization Microsoft Great Plains Customization

Welcome to our Moscow office RONIX

Articles.  Welcome to our article submission section.  We are inviting authors write for us.  We accept articles on Microsoft Business Solutions Great Plains, Navision (former Attain), Microsoft CRM, Microsoft RMS products customization, installation, reporting, Crystal Reports, as well as Linux based antivirus and anti spam systems.  We do not guarantee the publication - but all the articles will be reviewed by our editorial team.  Submit Your Article.  You can write in English, Spanish, Portuguese (both: Portugal and Brazil), Chinese, Japanese, Russian, Polish, Lithuanian, Latvian, French, German, Italian, Greek, Arabic, Turkish.

 

German:

Navision Kundenorientierte Lösungen und Berichtssysteme – Tipps für Softwareentwickler und IT-Spezialisten

Die Software Navision wurde im Jahr 1984 entwickelt. Seitdem ist sie eine führende Entwicklung innovativer Business-Management-Software-Lösungen auf Unternehmensebene.

Navision Customization: Berichterstellung - Tipps für Softwareentwickler und IT-Spezialisten 

Wie sieht nun die neue Funktionalität Navision Business Notification aus?

Microsoft CRM – Entwicklung

In allen traditionellen CRM- Software (Siebel, Oracle) wurden die Applikationen unabhängig von der Designplattform entwickelt.

 

French:

Développement sur mesure de Microsoft Great Plains: Dexterity, VBA, SQL, Crystal, eConnect - vue d'ensemble pour le programmeur

Microsoft Great Plains est le principal progiciel de comptabilité de Microsoft Business Solutions pour le marché américain.  Il contient des outils multiples de personnalisation / modification / reporting. 

 

Spanish:

Customización y Desarrollo del Microsoft CRM: SDK, C#, SQL, Exchange, Integration, Crystal Reports –  un panorama general  para los programadores

Microsoft CRM és un nuevo participante en el mercado de softwares CRM. Toda La concepción  por detrás de CRM parece ser diferente.

Upgrade de la Customización Great Plains Dexterity – Cambiando para nuevas tecnologias: SQL, Crystal, eConnect

Este artículo és direcionado a programadores de Great Plains Dexterity de nível intermediário. El describe  las direciones para la transicción de las funcionalidades del Dexterity  y  su reemplazo por nuevas tecnologías.

 

Portuguese:

Seleção da Base de Dados para MS Navision: C/SIDE ou MS SQL Server

MSB Navision atende tanto ao mercado Europeu quanto Americano. Ele foi originalmente escrito na linguagem C/SIDE ( Client/Server Integrated Development Environment)

Navision – Customização, Integração e Geração de Reports: Dicas para o Programador ou Especialista em TI

Fundada em 1984,  a Software Navision é uma desenvolvedora líder no segmento de software para gerenciamento de negócios

Navision – Módulo de Vendas e Reports (Jet Reports, C/ODBC, XBRL)

A Navision, empresa de desenvolvimento Dinamarquesa, foi comprada pela Microsoft, juntamente com a Great Plains Software. Com estas aquisições, a MBS passou a oferecer os seguintes ERPs ao mercado: Navision, Great Plains, Solomon e Axapta.

 

Russian:

Microsoft CRM кастомизация программирование Closed Activity

Microsoft CRM есть CRM ответ от Микрософта и попытка отвоевать долю рынка у Siebel, Oracle и других традиционных поставщиков Client Relationship Management систем.

Microsoft CRM модификация программирование email activity атачмента

Microsoft CRM теперь полноправный игрок на сцене софтверного обеспечения и стремительно увеличивает свою долю рынка – частично видимо благодаря мускулам Microsoft Business Solutions и ее маркетинговой стратегии

Microsoft CRM – программирование Closed Activity

Microsoft CRM использует Microsoft технологий: .Net, MS Exchange, MS Outlook, MS SQL Server, репликация, индексирование, Active Directory, Windows 2000/2003, Web Service, XML, XLTP. Языки программирования C# и VB.Net, а также HTML и  JavaScript.

Navision модификация, кастомизация, программирование, отчеты - обзор для программиста

Основанная в 1984 году Navision Software являлась лидирующим производителем инновационного программного продукта для средних и крупных предприятий

Navision Attain C/ODBC Crystal Report – пример кастомизации

Наша цель – популяризация Microsoft Business Solutions продуктов и открытие возможности кастомизировать Navision вашей группе информационных технологий

Navision Attain Database доступ через C/ODBC из ASP.NET приложения

Navision Software было куплено Microsoft и теперь поддерживается и разрабатывается Microsoft Business Solutions вместе с другими аппликациями: Microsoft Great Plains, Axapta, Solomon, Microsoft Retail Management System и Microsoft CRM

Navision Database доступ через C/ODBC WebService/ASP.NET приложение

Navision (прежняя Navision Attain) сегодня вместе с Microsoft Great Plains, Axapta, Solomon, Microsoft CRM и Microsoft RMS поддерживаются Microsoft Business Solutions.  Navision имеет множество возможностей для кастомизации. 

Microsoft CRM Интеграция: Импорт Siebel Email атачментов  - C# и MS Transact SQL код

импорт электронных писем, сохраненных в файловой системе утилитой переноса данных из CRM Siebel в базу данных MS CRM

Oracle Программирование: JDeveloper 10G – Java, J2EE, EJB, MVC, XML - обзор для девелопера

В 2004 году Oracle Inc. сделала новый шаг по пути упрощения пути разработки J2EE приложений, выпустив новый RAD Oracle JDeveloper 10G.

Oracle 10G программирование: Oracle-MS SQL Server интеграция

Два мира, две идеологии, два непримиримых соперника – как еще можно точнее описать два столпа RDBMS мира – Oracle Database и MS SQL Server.

Microsoft CRM интеграция: доступ к Oracle базе из MS CRM

В качестве примера, мы будем использовать интеграцию MS CRM с ASP.NET приложением, осуществляющего доступ к данным покупателей, хранящимся в базе данных Oracle 10g.

Lotus Domino R 6 программирование, кастомизация и модификация: Новые возможности создания приложений

Domino Designer представляет собой IDE, которая обеспечивает разработчиков возможностями по созданию, управлению и размещению (deploy) приложений для платформы Lotus Domino. В версии 6.х  появились новые возможности по созданию приложений.

Microsoft CRM Интеграция: Импорт Siebel Email attachments (C# и MS Transact SQL код)

Microsoft CRM – это ответ Microsoft Business Solutions на потребность рынка CRM для средних и даже небольших компаний.  Microsoft CRM имеет очень агрессивную цену.

Microsoft CRM модификацияпрограммирование email activity attchment

Как нам улучшить Microsoft Exchange CRM connector.  В особенности как создать email attachment – это и есть основной вопрос статьи

 

English:

Microsoft CRM integration: Oracle database access from MS CRM

user web interface of Microsoft CRM.  As an example we’ll use MS CRM integration with ASP.Net application, accessing customer data access, when customers are stored in Oracle 10g database

Microsoft Great Plains BPO: Business Processes Outsourcing – cost reduction ERP solution

BPO is probably the future winning solution for aggressive company, pursuing its principal business goals and outsourcing its classic business procedures with cost reduction and efficiency increase

Upgrading Great Plains Dexterity Customization – switching to new technologies: SQL, Crystal, eConnect

Looking into the future we recommend you to analyze Microsoft Great Plains Dexterity customization for replacement it's portions with Microsoft SQL Server stored procs, Crystal Reports, direct C#/VB.Net web publishing, eConnect

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports - overview for programmer

 If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM – we are giving you directions in this article.

Microsoft Great Plains Custom Design & Development: Dexterity, VBA, SQL, Crystal, eConnect – overview for programmer

If you are developer who is asked: how do we customize Great Plains – read this and you will have the clues on where to look further.

Microsoft Great Plains Integration with Legacy Systems – overview for developer

If you are developer who is asked: how do we implement  Great Plains integration/interface  with your legacy or other system – read this and you will have the clues on where to look further.

Microsoft CRM Implementation & Remote Support – overview for V.P. IT

Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy...

Great Plains Dexterity Source Code Programming – overview for Developer

Assuming that you are developer who will be working with Great Plains Source code you need some introduction.

Microsoft Business Solutions Products Customization - Overview for Developer

Microsoft Great Plains, Microsoft CRM and Microsoft RMS have similar database platform - Microsoft SQL Server.  There are differences in the tables design between three - due to the fact that they were originally developed by three different companies.

Oracle Design: JDeveloper 10G – PL/SQL, Java, EJB, J2EE, MVC, ADF - Overview For Software Developer

Deployment capability for all major application servers – Oracle Application Server, IBM WebSphere, BEA WebLogic, JBoss. OC4J – J2EE container comes with this environment, which perfectly fits for application development and testing.

Great Plains Accounting Migration to Microsoft Great Plains - overview for IT Specialist

This is short article, written in question/answer/FAQ style to give IT Specialist/developer/programmer balanced top level information on Great Plains Accounting migration to Microsoft Business Solutions Great

Plains.

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve – tips for developer

Crystal Reports is the most flexible tool on the market and it has market recognition.  Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few.

Microsoft Great Plains Implementation – overview for IT Director/Controller

Microsoft Business Solutions is on the way to popularize it's ERP systems implementation.  Right now such products as Microsoft CRM and Small Business Manager are targeted to self-implementation by in-house IT group. 

Lotus Domino/Notes – Microsoft Great Plains tandem as ERP with Documents Workflow – overview for IT Specialist

If you have investment into non-Microsoft  platform from CRM side – such as Lotus Domino/Notes – we offer you integration with Microsoft Great Plains

Microsoft Great Plains Dynamics on Pervasive SQL.2000 data repair – overview for Database Administrator

Up to the version 7.5 Microsoft Great Plains, and if you are looking to version 7.0, 6.0, 5.5, 5.0 or 4.0 - then it was Great Plains Dynamics were available on Pervasive SQL.2000 or Btrieve.

Crystal Reports for Microsoft Navision - overview for Programmer/IT Specialist

Crystal Reports are becoming the good option for Navision with the introduction of Microsoft SQL Server database option by Microsoft and why Navision tool - Jet Reports still prevails on the C/SIDE database.

Navision Customization and Reporting – tips for Programmer/IT Specialist

Founded in 1984, Navision Software is a leading developer of innovative enterprise business management solutions.

Microsoft Navision DB Selection: C/SIDE or MS SQL Server - overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.  It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment).

Crystal Reports for Microsoft RMS – overview for developer/report designer

Microsoft Retail Management System (MS RMS), former QuickSell 2000 is very popular retail system, which is capable to automate the whole spectrum of retail businesses

EDI: Electronic Document Interchange for Microsoft Great Plains – overview for Software Developer/Programmer/DBA

EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields.

Great Plains Customization Upgrade– overview for CIO/IT Director

When  Microsoft bought Great Plains Software, then Navision it formed special subdivision - Microsoft Business Solutions...

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL – development options

Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. 

Microsoft Great Plains Integration Manager – advanced techniques

Integration Manager scripting and translation example

Microsoft Great Plains: Manufacturing or Bill of Materials - overview for IT Specialist

Great Plains Manufacturing and Bill of Materials short review and recommendations

Microsoft CRM Customization – programming email activity attachment

In Exchange handler/event sink you create Activity of email type in MS CRM and one of the tasks is transfer the attachment(s)

Microsoft CRM Customization – programming Closed Email Activity

One of the roles of our Exchange Event Handler/Sink is creation MS CRM Closed Activity in handling incoming and outgoing email messages

Great Plains Customization – programming Auto-apply in Accounts Receivable

We will be working with RM20101 – Receivables Open File and RM20201 – Receivables Apply Open File.

Microsoft CRM Implementation - US market lessons

Microsoft CRM is CRM answer from Microsoft Business Solutions.  If you compare it to other traditional CRM applications, such as Siebel...

Microsoft Business Solutions Partner – consulting in the time of post-recession

The way for US based companies, in our case Microsoft Business Solutions reseller/VAR, to stay in business is to use internet marketing and do a lot of publicity and community work on the internet, educating their clientele.

Navision Attain C/ODBC Crystal Report – customization example

Our goal is to popularize Microsoft Business Solutions products and enlighten IT people to do customize Navision in-house.

Microsoft Great Plains Integration Manager – working with text file

Great Plains Integration Manager advanced programming, working with text files, aggregation, unionizing, VB scripting, translation

Navision Attain Database access via C/ODBC in ASP.NET Application

The topic of this article is Navision database access from ASP.NET application via C/ODBC interface.  Our goal will be ASPX page accessing Navision Customers.

Navision Database access via C/ODBC WebService/ASP.NET Application

Navision Attain database access through Webservice, connected to Navision via C/ODBC based Linked Server – the mechanism available in MS SQL Server 2000

Microsoft CRM Integration: Siebel Email Attachments Import - C# and MS Transact SQL example

This article is for programmer, who needs data to be migrated from Siebel or other CRM to MS CRM.

Oracle Development: JDeveloper 10G – Java, J2EE, EJB, MVC, XML - Overview For Programmer

In 2004 Oracle, Inc. made its new step toward J2EE application development simplification, releasing new RAD Oracle JDeveloper 10G.

Oracle 10G Development: Oracle-MS SQL Server Integration Tips

Two Worlds, two different ideologies, two constant rivals – is it possible to give more precise description for two RDBMS World giants – Oracle Database and MS SQL Server?

Microsoft CRM Integration with Lotus Domino email Server - overview for programmer

There is competitor email server: Lotus Domino.  Some large and middle size customers, who decided to use Microsoft CRM - want to use Lotus Domino as their e-mail server.  In this small article we would like to give you top level technical overview

Microsoft Great Plains 8.0 - Microsoft RMS 1,2 Multi-Store Integration – overview

Recommended settings – targeting RMS Headquarters database (after daily transactions migration from Stores to Headquarter), however you could use linked SQL server to your Store Operation databases and pull daily transactions directly from there

Microsoft CRM Integration with Oracle – overview for programmer

How you can have lookups from Microsoft CRM into Oracle system.  Oracle might be custom database, designed for the business, such as cargo tracking system for freight forwarding company, or even Oracle Financials. The same technique should work for SAP, PeopleSoft, etc

Microsoft CRM Integration with Navision – overview for programmer

We suppose that Navision is installed with native C/SIDE database, because in the case of MS SQL Server this topic doesn’t make sense

Lotus Notes/Domino integration: ODBC connection – tips for programmer

Lotus / Domino integration has high interest among developers and IT specialists.  We are publishing here small articles on Microsoft Business Solutions Great Plains, Microsoft CRM, Navision plus Oracle and Lotus customization and integration.

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics – highlights

We would like to give you manager, information and guidance concerning the Sales module of Navision

Past articles:

Crystal for GP Dex customization options Exchange Programming GP Custom options GP Ctree What to do Ho to upgrade Dex customization IBM Customizations Lotus or Exchange MS CRM Overview Reports for GP GP Integrations GP Conversion GP Partner Selection GP Partner Interlational GP Queries for DBA MS CRM Programming Secrets Dex Programming Secrets Google Processing MS CRM Modification MS CRM Review GP Upgrade FAQ GP RMS Integration IT Skill to Support GP CRM MS CRM Development GP Upgrade 8.0 GP Reporting GP Custom Dev Dex Hist

Article submission guidelines.  Please send us article in Microsoft Word format.  Hyperlinks are OK.  Editors are welcome.  Priority will be given to Microsoft Business Solutions products reviews: Microsoft Great Plains, Great Plains Dynamics/eEnterprise, tips for developer, programming techniques.  We also are interested in MBS product integration with third party platforms, such as Lotus and Java

Andrew Karasev, Editor

About Become Client Brasil Case Studies Clients China Crystal Customizations Dexterity Distribution Employment FAQ Finance For MBS VAR Forum Japan France Great Plains Great Plains SQL Crystal Industries Instant Help Integration Manager International Lithuania Main Manufacturing Mexico Microsoft CRM .Net Nonprofit Placement Poland Products Represent Us Retail RMS Russia Services Services Spain SQL Switch Technologies VBA Whitepapers & Documentation How To Alba Old Site Cofounder Great Plains Certified Master Microsoft RMS Recovery Java JSP Lotus Domino COM/Web Services