Software Upgrades Arent Always the Best Move
When I finally got around to buying accounting software in 2003, I researched to see what would best meet my needs. But if it doesn't have your software, use Google and enter the software title along with the version number.

COSMIC: A Small Improvement on the Symons Method
The COSMIC group reviewed existing functional size measurement methods, namely the work done in the late 80's by Charles Symons in the UK. (2002) Advantages of the COSMIC-FFP method, Online, http.

Brand Your Websites URL With a Favicon
At the beginning, only large websites had a favicon, but now you too can create one and use it to brand your website. The first thing you have to do is to create your favicon.

Bill of Lading - Custom Reporting for Microsoft Great Plains - Overview for Consultant
ReportWriter - this tool will allow you modify existing Picking Ticket, Packing List or Invoice form to produce Bill of Lading. Microsoft Business Solutions Great Plains might be considered as ERP platform, ready for customization.

Microsoft Great Plains PM: Payables Management
Great Plains Payables Management (PM) module improves control over your payables. ? Control Account Management - Manage your payables control accounts by reporting segments, such as cost center, division, department, program or fund, and display a breakdown by segment values of your central control payables account.

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More
- as a result of this decision - you can't conduct your business with Microsoft Business Solutions any more. Old-days Great Plains Dynamics on Ctree or Pervasive SQL/Btrieve was excellent and inexpensive solution.

Microsoft Great Plains Integration Manager: Using Continuum - Overview for Developer
Microsoft Business Solutions Great Plains has I'd say end user integration tool - Great Plains Integration manager. In order to enable custom integration you need to have this license - which costs $750 for Great Plains Standard.

Professional Software Icons For Your Standalone Application
Icons are the easiest way to differentiate your application, while still keeping a note of familiarity. Also, there must be a way for all the people - and it's really a mystery here - who like the same old icons and colors on all their applications.

Who Is Minding Your Sensitive Data?
And protecting data is definitely your responsibility if you are an accountant or you specialize in other types of financial businesses. Data that is encrypted is safe from prying eyes which means that your business data is safe.

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software
If the software company does not offer either one of these options, you might want to reconsider your decision. His company specializes in providing impartial purchase assistance to individuals and businesses looking for software to meet their specific needs.

When Microsoft introduced MS SQL Server 7. In the past we saw a lot of Great Plains Integration Manager usage, today the trend is to deploy SQL scripts and stored procedures, including eConnect and its extensions (such as automatic transaction posting. Internal development should be done by SQL programmers, web exposure - by VB. In the case of large publicly traded company, you should probably dedicate internal Great Plains support person, who will be trained by consultant and then will provide training for end users. In this case you will avoid having consultant train the same common interface feature multiple time to different groups of users.

In order to work correct with MS SQL Server 2000 with C/ODBC source we need to use these type. Msg 7347, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL. To test the procedure you can give its name in MS SQL Query Analyzer - EXEC NavisionCustomers. ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'. Next place on the page the component SqlDataSourceControl and tune it's - Connection String.

So, lets assume that you are on MS SQL Server. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. So, this is very challenging to replicate allocation logic. RM00101 - is Customer Master, RM00102 - customer address master, etc. This is usually the core of eCommerce development - transactions should go into SOP tables (with SOP prefix.

Beginning with Domino version R4 it has integration with the Web, and the server itself becomes a HTTP-server. Developers are to take care themselves for loading balance putting into different parts often changed and more static data. Gottmann is a technical writer in Ronix Systems ( http. If look through the codes of full-blown Web-sites, designed on Domino technology, then, for example, in Domino forms we see only fields, all extern design is based on DHTML. HTML-pages generation in passing surely takes the server resources, so if the application is poorly constructed, it may cause the server failure.

At the same time MS SQL Server - MS CRM DB platform is perfectly relational. Windows Active Directory, SQL Server, MS Exchange, BizTalk (integration with MS Great Plains, and soon with Navision), Message Queuing,. The second drawback - you are actually copying document into MS SQL Server database and you may quickly increase its size and degrade efficiency. Also it is possible to have Lotus/Domino playing the role of email server (instead of MS Exchange) - but this is outside of the scope. This is probably the best MS Office documents repository which could be seamlessly integrated with MS CRM, in this case MS CRM links to the repository, not imports the whole documents into MS SQL database.

You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools. MS SQL Server - the batch record is stored in Batch Header table. Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script. Now we would like to stress you the need to move away from Pervasive SQL 2000/Ctree platforms - you are in trouble - Microsoft Business Solutions cuts technical support for Microsoft Great Plains 7. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data.

Great Plains is MS SQL Server based application and if you base your Crystal Report on the stored procedure in SQL Server - you can easily get random selection. Microsoft Great Plains doesn't have this feature out of the box, and you have to implement it via MS SQL Server Data Transformation package, Stored Procedure or Great Plains Dexterity customization. Microsoft Business Solutions offers several lines of ERP systems. We don't want to state here that in the future Microsoft will be only ERP systems provider, but it certainly is and will be one of the major players on the ERP/MRP market. The way you implement local language or Unicode characters support - you translate several screens for GP local users and extend Dexterity with Unicode enabling software utility.

These queries might be triggered or placed as MSSQL Server overnight job. Microsoft Great Plains sits on MS SQL Server platform and typical technologies are. This should be realized as Great Plains Dexterity custom window, with two scrolling windows on it, where you should list SOP Invoices and POP Shipments with Invoices. Use the same Great Plains Dexterity custom window technology. Transactions come to Sales Order Processing (SOP) and Purchase Order Processing (POP) modules, where they are placed into batches.

IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need audit trail on approval cycle and decision making. The most important is that it will be synchronized by MS Outlook and will allow you as a salesperson to work offline. You can always have us help you with MS CRM customization, implementation, support & MS CRM SDK data conversion. With Alba Spectrum Technologies MS CMR Lotus Notes Domino connector you can switch email messaging to Lotus Domino. As the second phase we plan to implement lookups from MS CRM Account to cases with custom fields and Lotus notes lookup tab.

The nice thing about MS SQL Server - it has linked server technology - you can establish the link to virtually all ODBC ir OLEDB compliant databases. Great Plains Dexterity integration with Great Plains process server. This integration technique uses SQL stored procedures and views to pull data from your legacy or third party application and push it into Great Plains. Oracle, DB2/Unidata, Sybase, Ingress, Lotus/Domino, Pervasive SQL/Btrieve, Ctree/Faircom, Microsoft Access, Foxpro to name a few. When Microsoft Windows platform won the OS market (the last battle was in 1997 with PowerMac) Great Plains recommended OLE Server approach.

Domino applications are client-server applications. Notes Client does not support the same level of limitation and security as the server does. Domino also supports HTTP protocol, which allows Web browsers access to the applications located on Domino server. Items as well keep information for kept data type. Domino server is a buffer between the operation system and the application.

Office Outlook Connector for IBM Lotus Domino enables using Microsoft Office Outlook 2003 or Microsoft Outlook 2002 to access e-mail messages, calendar, address book, and To Do (task) items on an IBM Lotus Domino Release 5. Taking into account that the products value is approximately the same worldwide, new ideas of the platforms integration have appeared. Microsoft supports free add-on for Microsoft Outlook client, which allows connection to message/collaboration server Lotus Domino. Principal CLP IBM Lotus Domino 6 Application Developer. Certified Professional E-commerce Concepts Analyst.

But the idea was to catch or switch winning/losing database platform - nobody could predict if MS SQL Server, Oracle or DB 2 become a dominant DB platform, like Windows among OS. Net and ASPX platform, server based scripts are replaced with. This is how you design and test your queries. Tool->Resource Desciption->Tables, re-sort by Table Group technical name, then make test transactions in Great Plains (SOP module) and see where records go. You usually need consultant help, however you could try to make maximum work done at home.

Nowadays, however - and this is a good thing - most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures. SQL queries - as a developer you have unlimited potential in using SQL queries, because the database in MS SQL Server. IM validates 100% of business logic and uses hidden GP forms - so it maybe slow for big on-going integrations, when you have thousands records per day - in this case you rescue to eConnect or directly to SQL store procedures. Plus you probably want to have several SQL stored procs. If you are familiar with VBA customization for Access or Excel - you have all the skills needed - then you just attach your scripts to the buttons and fields on GP forms (you can modify these forms with Modifier - or just tough them with it.

The other way is having all the stores as linked servers from Headquarters MS SQL Server Enterprise Manager. Microsoft RMS is SQL Server-based application, so we will consider SQL programming - SQL queries, views and stored procedures. Also Microsoft RMS could be integrated on the SQL level with other applications, such as Microsoft Great Plains, Microsoft CRM and non-Microsoft applications, such as Lotus Notes/Domino. RMS normally replicates transactions from the stores to Headquarters upon the store business hours close. The customization scenarios, described in this article deal with the chains, when Microsoft RMS has multiple stores databases and Headquarters.