4/01/2006 03:20:00 AM|W|P|Nishanth Technologies|W|P|

If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.

Comprehensive Help Desk Functionality

A good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole). Computer users can be made to submit their requests by mail, phone or through the web interface provided by the product. These requests gathered centrally will be attended to by technicians (who already are automatically notified about the request). Adding memos/notes to the requests & viewing the history of Requests can help too.

Buildable Knowledge Base (KB)

Even before a complaint is registered, Users can be made to search a prebuilt KB which will result in time savings for the Help Desk Personnel. The KB will also result in increasing the first call resolutions. The Help Desk personnel should be able to add on to, edit & delete from the existing KB.

Asset Managenment

What is considered here as an organisation's Assets are typical hardware components like PCs, Printers, Scanners etc & Licensed Software like MS Office, Adobe Photoshop etc. The product should allow these assets to be well tracked & their records to be maintained - from their purchase till end-of-life. It should also allow easy software license tracking which will contribute to a significant cost saving for the organisation.

Contracts (AMCs) Management

Most hardware components in an IT organisation come under some Annual Maintenance Plan. The product you choose should allow you to create & maintain various AMCs with the various vendors. If the product reminds you days before a contract ends (say, through an auto-generated email), it will be an added advantage.

Purchasing

Your IT department is constantly in need of spendable Hardware (floppies, CDs, printer ribbons, printers, PCs etc) and software. All these needs will be typically taken care by a separate Purchase Department. Seamless tracking between the two departments is an essentiality which will result in getting the required needs on schedule & their optimal use. Also, see whether the product you choose lets you mail the Purchase Orders to Vendors & track them too.

Out-of-the-box

The product installation should go on like a breeze. Moreover, it should be put into operation with nil to minimum initial configuration & all the features should be inbuilt with no extra development effort.

User friendly UI

The product you are looking at should have a very user friendly client interface as it'll be used by all employees in your organisation. The UI should be simple & at the same time offer easy-to-use features. If the product is web enabled, it'll make things much more easier - any user can login from anywhere using just a browser.

Pricing & Licensing

Most Help Desk products in the market are prohibitively costly with many hidden costs associated with them. Coupled with this, the products' licensing models can be tedious to understand & implement. Make sure the product you choose offers affordable pricing with an easy licensing model.

|W|P|114389046793615688|W|P|HelpDesk & Asset Management Software - Choosing The Right One|W|P|venkat@sgdnetworks.com4/01/2006 03:16:00 AM|W|P|Nishanth Technologies|W|P|

What is a Web Database?

A web database is a database for the internet. You can get access to your data via the internet from anywhere in the world. Or, you can create a database driven website by using such databases. A web database stores large amount of information in an organized format that is easily accessible from scripting languages (like PHP).

In web databases, modifications, like the ones constantly used by e-commerce sites, for example, can be performed without any hassles .That makes the dense editing of the html code obsolete. Repeated types of data, like contact information, can be generated automatically in your website through a web database.

Daffodil DB: A web database

Daffodil DB is a J2EE-certified, SQL-99 and JDBC standards compliant Java RDBMS. It is the first java database which is compatible with PHP. With the release of PHP extension module, Daffodil DB has joined the select list of Java enabled web databases.

Daffodil DB is an ideal for anyone who is looking for a web database. It can be embedded within any application and delivers high performance with minimum system resource usage - thereby striking the right balance between size, features and performance. At less than 3 MB, Daffodil DB is a small/compact database.

Daffodil DB can run on virtually any platform as it supports all platforms for which a Java Virtual Machine (JVM) is available. These include Windows, Linux, Solaris and UNIX. With the help of Daffodil DB, developers can build applications for any platform and these can be compiled and delivered on all other major platforms.

PHP

PHP (PHP Hypertext Preprocessor) is an open source server-side scripting language that is particularly suited for web development and can be used to generate dynamic web content.

PHP scripts are embedded within web pages along with HTML, similar to other web scripting languages such as Microsoft's ASP or Sun Microsystems’s JSP. Like ASP and JSP, PHP runs on the web server when a page is requested via HTTP, rather than on the Web browser or other client.

PHP lets you insert instructions into your Web pages that your Web server software (be it Apache, Personal Web Server, or whatever) will execute before sending those pages to a browser that requests them.

PHP is easy to use for web development because it has been designed from the onset for the web environment. PHP has many built-in functions that make web programming simpler, so that programmers can focus on the logic of programming without wasting precious development time.

PHP as a language has its own way of doing things, and at the same time, has borrowed features from other languages. But for many people, the main reason for learning a scripting language like PHP is because of the interaction with databases it can offer. Moreover, PHP is cross platform i.e. it allows you to use/develop your solution on multiple OSs.

PHP is one of the fastest growing server side scripting languages around and you need to add it to your current arsenal of Perl, ASP, JSP, JavaScript, VBScript, Java...

PHP and Daffodil DB: Together…?

Daffodil has come up with a PHP extension module that makes Daffodil DB/One$DB compatible with PHP. It is a database extension module driver that is required to work with Daffodil DB in PHP. This extension module uses the capabilities of a Java database and extends it to your web infrastructure.

By using this extensive module, PHP developers can create sophisticated data-driven web applications, having Daffodil DB as a web database, in a fraction of the time and with reduced cost.

PHP extension for Daffodil DB provides a simple, yet effective means for connecting to Daffodil DB from within PHP. The JVM is created using JNI invocation interface and everything runs in-process.

This PHP Extension module will boost open Source activities around Daffodil DB. Moreover, open Source stack -Linux, Apache, One$DB, and PHP; all being open source products, will give an ultimate combination to web development community.

PHP is platform independent, Daffodil DB is platform independent. PHP is free; so as Daffodil DB (open source version).PHP is open source; Daffodil DB has an open source version. So What about using the powers of two most promising technologies, PHP and Daffodil DB, together…?

The capabilities of Daffodil DB & PHP can make up what must be the best blend for data-driven Web sites on the globe.

Users can use PHP and the Daffodil DB database to access/store information on the web and include it into their website. By using PHP as a front-end and Daffodil DB as a back-end web database, users can benefit from huge savings on the licensing costs of commercial alternatives.

Here are some practical examples where PHP and Daffodil DB, used together, can do wonders

• Designing a database driven website

• Add, edit & delete Web site content without using HTML

• Banner Rotation

• Forums • Apart from all above mentioned applications, there are some more areas where users can use Daffodil DB-PHP 'dynamic-duo'.

• Optimize the loading time of the website

• Build an ecommerce shopping cart

• Automatically send email on triggered events

• Handle file uploads using HTML forms

• Build a Web-based file repository or photo gallery

• Utilize sessions and cookies to track site visitors •

|W|P|114389024959121840|W|P|Daffodil DB: Web Database|W|P|venkat@sgdnetworks.com4/01/2006 03:15:00 AM|W|P|Nishanth Technologies|W|P|

In the case when you represent mid-size or mid-size-to-large business, it is not a surprise that you have to do ERP selection and switch to new technologies, doing your own research. If you a trying to stay with Microsoft technologies and try Microsoft Business Solutions products: Microsoft Great Plains, Microsoft Navision, Solomon, Axapta with integration to Microsoft CRM, you should know the history of Great Plains Software and Navision partners over the last 10 years.

• Great Plains Dynamics VAR of earlier 1990th. These companies were a mix of CPAs, received application consulting training. Second feature – these companies were concentrating on the local market, the preferred method was on-site visit, sales technique – cold calls with following hard pressuring sales.

• Great Plains Dynamics C/S+/eEnterprise VAR of 1995-1999. This time, due to the fact of increasing competition on Graphical OS market and Microsoft aggressive market take over, consulting firms had to hire more technical consultants and programmers. These employees were engaged into data conversion, data repair, Great Plains Dexterity interfaces, VBA, ReportWriter, Crystal Reports customizations and web development. This was the time of technology diversification and golden time for programmers. At the same time the importance of application consultant CPA was in the decrease, one of the explanations could be – universities picked up in educating future controllers in basic CPA, standard ERP and financial reporting

• Microsoft Business Solutions nowadays VAR/Partner/Reseller. We see segregation of duties, however it is not transparent to the end customer. Regional Partners are still deploying strong sales techniques, but they have rather strong sales force. Consulting job is subcontracted to independent consultants and customizations challenge is subcontracted to nation-wide customization partners, such as Alba Spectrum Technologies.

• Nation-wide partner specifics. You are probably lucky if you got nation-wide customization partner directly, because you can save 30% in local implementation and customization rates, due to the fact that nation-wide partner doesn’t participate in the bidding, but rather is subcontracted by the winner of the bidding battle.

|W|P|114389015919022396|W|P|Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization - Overview|W|P|venkat@sgdnetworks.com4/01/2006 03:14:00 AM|W|P|Nishanth Technologies|W|P|

It would be easy to think, like most people apparently do, that stress and the computing (and especially programming) industry were unlikely bedfellows. The habitual image of long-haired young "geek" programmers churning out ‘software’ from their teenage bedrooms is one that many still associate with mainstream programmers. Stereotype or not, this image is still commonly held, and the armies of deadline-bound, overworked and stressed-out programmers in the real World are all but forgotten in the melee that is the result of the technological age.

Stress is widespread within the computer industry, perhaps even endemic. From the assembly-line manufacturers forever looking to increase throughput to the debuggers whose time requirements weren’t in the original production schedule, pressure on those who work in the industry is at an all-time high and it is only going to increase as margins drop and further efficiencies are required.

Even getting into the industry can be stressful – like private companies, many educational institutions are now usurping control of the code written on their campuses via "ownership" clauses which leave the originators of ground-breaking code with nothing to show for their efforts. Having something to show at interview is becoming increasingly difficult not just for existing programmers, but for the "new wave" just emerging from colleges and universities with excellent qualifications, but nothing they "own" to demonstrate.

Once the elusive job does come along, things rarely improve. Our "immediate" society is a result of the computer age and effortless sourcing of products and services via the internet. How many programmers have faced the challenge of meeting impossible deadlines with the threat that the next job will go to cheaper labour overseas that can do it in half the time? This leads to longer working hours, less rest, exhaustion, errors and then the cycle starts again - is that really what we expected when we entered the industry? So how can you reduce the stress put upon you by this relentless march of "progress".

First of all, an ounce of prevention is better than a pound (or should that be a ton?) of cure. By ensuring that your contracts are fair and considerate to both sides, you could remove a lot of stress later on. Here are five easy steps to help prevent stress in you next contract:

1. Be Honest

If a deadline is too short – say so. If it seems short now, it will only seem much shorter later.

2. Be Realistic

When you are assessing the requirements of a job, make sure you’ve got some wiggle-room. Nine times out of ten, you’ll need it (or at least appreciate it!)

3. Be Certain

Check your facts, figures, requirements and timings. If you have made an error, you want to find out now, not later when you’ll be held to what you quoted.

4. Be Flexible

It helps to have an ace up your sleeve. If things really go wrong, where can you get extra help. Build contingency arrangements with others in your field and help each other out when you need it.

5. Beware

Stress creeps up on you unexpectedly. Do routine reviews against your plan and make sure you’re still on course. If not, DO something about it and always, ALWAYS let the client know.

|W|P|114389011005441206|W|P|Managing Stress in the Computer Industry - Five Steps to a Stress-free Life|W|P|venkat@sgdnetworks.com4/01/2006 03:13:00 AM|W|P|Nishanth Technologies|W|P|

Following tips help you to learn a software in lesser time and in an efficient manner:

1. After installing a software package, look for any README file in the installed folder. Besides company and product details, it may give an overview of features, usages and limitations of the software.

2. Next run the software and have a feel of the look of the software. Identify the different parts of its main screen.

3. Look for the information shown in the TITLE-BAR of the main screen. Usually, it shows the product name. If the application is SDI (Single Document Interface like Notepad) or MDI (Multiple Document Interface like MS Word) then title-bar will also contain name of the opened file. Similarly, there may be STATUS-BAR at the bottom that shows the operation being performed.

4. Then comes the main MENU-BAR. Most of the GUI based software have common menu-items. So its better to learn once-for-all. Some of the common menu-items are:

FILE, EDIT, VIEW, TOOLS, WINDOWS, HELP.

Each of these names are intuitive itself.

-The FILE menu will have operations NEW, OPEN, SAVE, SAVE AS, PAGE SETUP, PRINT,CLOSE and EXIT.

-Similarly, EDIT menu contains editing operations like CUT, COPY, PASTE, FIND AND REPLACE.

-The VIEW menu helps in controlling the view of the software GUI. You can switch on-off various toolbars.

-The TOOLS menu usually have options to customize the software you like and also other supporting functionalities like Read-Aloud function in a word processor package.

-The HELP menu may contain GETTING STARTED tutorial, detailed indexed and searchable help and ofcourse, a popup dialog-box that shows information about the software. It may also contain a link to website of the product.

5. Once acquainted with different menu and their menu-items, look at each menu again to find shortcuts to them. For example, Alt+F will take you to File menu. Some common shortcuts are:

Ctrl+N - New Ctrl+O - Open Ctrl+S - Save Ctrl+Shift+S - Save As Ctrl+P - Print Ctrl+X - Cut Ctrl+C - Copy Ctrl+V - Paste Ctrl+F - Find

6. Next have a look on various tool-bars that are present below menu-bars. They provide a visual shortcut to the desired operation. Examples are a paper folder on top right corner for NEW, an opened folder for OPEN, a scissor for CUT, two papers for COPY, a paper on clamp-pad for PASTE, floppy icon for SAVE and printer ICON for PRINT. A book or question mark icon represents HELP.

7. If the package is a development tool then start with the sample applications provided with it. It will help you understand what functionality level the package can provide. Also, you may need not start your application from scratch; it can be dervied from one of the sample application (provided source code is available).

8. Mostly, the menu-item name will tell its functionality. Even if it does then also try each operation available in the package.

9. You can master a software with its usage and little study. The best place for getting some help is the in-built help provided in the package itself.

10. Remember Internet is always there to solve your problem. Use a search-engine with appropriate phrase to get the best material available as solution to your query. You can visit my website: http://www.geocities.com/zainvi_sf for Tips and Tricks for various softwares, programming langauages and links to ther useful material available on the Internet.

|W|P|114389005965056604|W|P|10 Ways to Learn a Software|W|P|venkat@sgdnetworks.com4/01/2006 03:12:00 AM|W|P|Nishanth Technologies|W|P|

The most important things you can do for your computer right now is to install adware and spyware blockers. Everyone is aware of computer viruses and run an anti-virus program to guard your computer against them.

But only a fraction of computer users are running any kind of adware and spyware blockers software. It is believed that 90% of today's PCs are infected with some form of adware and spyware. Most of the time you are not aware that your computer is even infected.

Adware and Spyware are less noticeable than computer viruses but can be much greater danger to your computer. So what is the danger posed without removing spyware from computers and how do you block spyware and adware on your PC?

If your computer becomes infected, the results range from minor nuisances such as pop up ads to more serious threats including identity theft. Even your passwords and credit card numbers could end up in hacker's hands and you wouldn't know it happened until the damage was done.

Spyware and adware files hide in your computer and are loaded down as you browse the Internet. Common culprits include pop up ads, shareware, freeware and instant messaging. However, there are less common ways to become infected.

Some computers contain adware and shareware files even before you purchase them. Because of this fighting spyware and adware and removing spyware from computers is becoming even harder today.

Spyware and Adware has become such an epidemic that it is the latest target of NY Attorney General Eliot Spitzer. "Spyware and adware are more than an annoyance," Spitzer said in the statement. "These fraudulent programs foul machines, undermine productivity and in many cases frustrate consumers' efforts to remove them from their computers. These issues can serve to be a hindrance to the growth of e-commerce."

There are many programs that you can download to block adware and spyware from infecting your computer. Protect your privacy, and get the right Internet privacy tools installed on your computer immediately. You need to install adware and spyware blockers now so you can enjoy the Internet without the hidden dangers.

|W|P|114388998629996542|W|P|Adware and Spyware Blockers|W|P|venkat@sgdnetworks.com4/01/2006 03:11:00 AM|W|P|Nishanth Technologies|W|P|

When you buy a computer, it most likely comes with Microsoft Windows preinstalled. And when you need a word processor, spreadsheet, or other software, you probably buy it from a computer store. That software is vital. Without it, a computer is just an expensive paperweight.

But you can find free and low-cost alternatives to commercial software. Free software has been available for years but has never been so accessible to everyday computer users. These programs have long been the domain of, well, geeks - experts who were willing to download huge programs from the Internet and who knew how to compile the programs from source code. But free software is entering the mainstream, thanks to faster Internet connections and easier-to-use installers that don't require a degree in computer science.

Free software appeals to those on a budget as well as anyone who simply wants another choice. Examples of free software include GNU/Linux, an operating system that replaces Microsoft Windows; OpenOffice, a word processor, spreadsheet, and presentation manager suite; and The GIMP, an image editor that rivals Adobe Photoshop. A PC with GNU/Linux preinstalled can cost hundreds of dollars less than a Microsoft Windows PC.

Free software takes time and money to run, and Microsoft will eagerly tell you that the total cost of ownership for GNU/Linux is umpteen times higher than Windows. But advocates of free software say cost is not the only issue.

"Free software means the users are in control," says Richard Stallman, founder of the not-for-profit Free Software Foundation. "Each non-free program has an owner, a feudal lord in effect, who dominates the program and its users. The owners of non- free software often impose changes on the users, changes meant to suit them, not us."

Free software advocates say there are two kinds of free: free as in "free beer" and free as in "free speech." They're both good but for different reasons. The mantra of the Free Software Foundation is "Free software' is a matter of liberty, not price." Commercial software licenses - those wordy, legalese-filled documents that no one actually reads before clicking "I Agree" when installing software - usually impose strict limits: You can't install the software on more than one computer; if it doesn't work the way you want, you can't change it; and so on. Free software often has a license too, but it's far less restrictive. Users can amend the software to make it better.

"The main advantage is the community of people who will continue to improve the software on a voluntary basis, especially as it relates to security flaws," says Irwin Taranto, treasurer of the International Computer Users Fellowship of Rotarians. Case in point is Mozilla Firefox, a web browser that’s emphasizes speed and security. The program has taken a quick foothold amongst Internet users who are tired of the security flaws in Microsoft Internet Explorer.

Most free software can be downloaded from the Internet. The programs are sometimes large, so a fast Internet connection helps. Some programs are sold in stores. Many free software licenses allow others to sell the software. Although it may seem ironic, free software users often opt to pay in exchange for value-added features such as printed documentation, a CD installer, and technical support.

The next time you need software for your computer, you might consider free alternatives. It may not be as free as free beer, but it can be as liberating as free speech.

|W|P|114388993708418836|W|P|Free Software - Powerful Alternatives to Budget-Busting Software|W|P|venkat@sgdnetworks.com4/01/2006 03:11:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Great Plains may be recommended for international freight forwarding / transportation company. Great Plains has such features as multicurrency (Euro, Pound, Yuan, Yen, Peso, Real), Spanish, French, Brazilian Portuguese (and if needed Unicode-specific languages such as Chinese, Japanese). If you have operations in East Europe – you can have Polish version as well as you can have several screens (SOP Entry, Inventory Item Maintenance, Customer/Vendor Maintenance, etc) translated to Russian, Lithuanian, Latvian. Plus – if you consider Great Plains as a platform for custom tailoring and developing – you can have reasonably priced solution for horizontal business, such as freight forwarding, cargo delivery, consignment, transportation. Let’s consider industry specifics and the way to implement them in Microsoft Business Solutions Great Plains

• Agent Settlement. Freight forwarder usually deploys agents to deliver shipment. And agents are usually paid on the monthly or semimonthly basis. This means that you should have agents as customer.

• Daily Agent MBL invoices/statements. Assuming that agent is handling several shipment with Master Bill of Ladings (MBL) and House Bill of Ladings (HBL) per day – freight forwarder emails to the agent daily invoices. Then these daily invoices are settled and paid one time per months

• Cargo Tracking System. This is usually custom in-house made system, specific to each freight forwarder or industry specific stand alone software. The important requirement is the integration between Shipment Tracking System and ERP, such as Great Plains

• Accurate in-time payments. Payments are required to stay in highly competitive business, such as freight forwarding

• Bill of Lading report. Where you usually need additional info to standard invoice form: Carrier, MAWB, Airport of Departure, Airport of Destination, Flight #/ETA, Weight in KG, Lbs, number of packages, etc. Technologies and customization tools:

• Great Plains Dexterity. This is Great Plains Software and currently Microsoft Great Plains programming language and IDE. It will allow you seamless integration with Great Plains user interface. You should realize agent settlement screen and inquiry, MBS/HBL profit/loss inquiry form and probably Bill of Lading in Great Plains Dexterity.

• SQL Integration. Integrating with Cargo Tracking/Delivery system should be done via SQL stored procedures. Use ODBC Linked Server to link to your tracking system database (MS SQL Server, Oracle, DB2, Unidata, Pervasive SQL, Ctree/Faircom, mySQL).

• Web Order Entry. Use eConnect to avoid high user license cost in Great Plains. eConnect is SDK to reference Great Plains objects – you will need SOP and POP orders entry

• Customer/Vendor Consolidation. For agents, who are customers and vendors at the same time use consolidation module. It is available for Great Plains Professional only – if you’d like to stay with Great Plains Standard – use Great Plains Dexterity to program the consolidation.

|W|P|114388989290075906|W|P|Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup - overview|W|P|venkat@sgdnetworks.com4/01/2006 03:10:00 AM|W|P|Nishanth Technologies|W|P|

It’s all about turn times in the eMedia industry! The speed with which your vendor can get your CD or DVD project completed is vital to many customers. However, responsibility for these projects meeting their completion dates starts with the customer and ends with the vendor. It’s a partnership that shares the responsibility. Just follow the 6 easy steps below:

1) Complete Credit Reference

- When submitting a credit application, be sure to fill out all sections. - Contact your references and advise them to complete the required form that will be faxed to them by your CD/DVD vendor. Also, remind them to return the paperwork to your vendor as soon as possible.

2) Communicate All Details of the Project to Your Sales or Customer Service Representative

- Provide all shipping details to your sales or customer service representatives (changes in shipping information must be communicated as soon as possible).

- Provide the information that you would like on the mirror band of CD-ROMs and DVD-ROMs.

3) Protect Yourself

- Fill out, sign and return the Intellectual Property Rights (IPR) form to make sure content ownership is properly handled. A completed and signed IPR form usually must be provided with every order prior to your job being scheduled for production.

4) Submit a High Quality Master Disc

- Always use high quality media. - Avoid burning from a network source. - Avoid burning on a laptop computer running on battery power. - ALWAYS “finalize” your disc. - Don’t use packet-writing method to burn the master disc. - Avoid impact or movement of the drive during burn. - Use the “burn-proof” feature if available. - Avoid having multiple applications open when burning, especially those that access the internet or network. - If possible submit two copies of the master disc.

5) Complete Your Screen Print Artwork - Follow the artwork specifications. - Send physical copy of artwork or send file to the vendor’s FTP site.

Inform your sales or customer service representative when sending a file to their FTP site.

- Supply color and specification information along with a hard copy of your artwork or e-mail a PDF of the artwork to your sales or customer service representative. Be sure to include all fonts that are a part of your project.

- Include e-mail address where PDF proof should be sent.

- Approve verifications quickly, while still being thorough.

6) Send the Vendor Your Materials

- Customer-supplied printed materials should arrive at least three days prior to projected ship date. Some vendors require 15 percent overage of all printed materials.

- A packing slip should accompany all customer-supplied materials. A purchase order number or job number must appear on the packing slip.

|W|P|114388985284923131|W|P|6 Easy Steps for a Smoother CD/DVD Order|W|P|venkat@sgdnetworks.com4/01/2006 03:09:00 AM|W|P|Nishanth Technologies|W|P|

#5 All your hardware components like Printers, PCs etc come under various maintenance contracts with different maintenance vendors. Do you know which batch of PCs are under warranty & for what number of PCs is the warranty about to expire (so that you can plan for an AMC)? Can you split up & tell how much AMC charges do you pay for each hardware component & how much for each vendor? Can you re-calculate the costs if an AMC with a vendor is to be renewed?

#4 Typically your company gets hardware parts and accessories from different vendors. Is your purchasing done centrally? Can you get the information of all vendors & the products they offer on a single click? Can you compare prices & other information before placing an order? Can you modify a purchase order (PO), have a revision history & email the vendor the updated PO? Can you track POs till all the items mentioned in a PO arrive?

#3 You might have entered into contracts with various vendors. Do you maintain & keep track of all your maintenance & support contracts in one place? How about having soft copies of actual contracts that are available to you through a web browser and is always a single click away?

#2 Your company has a variety of hardware like PCs, printers, scanners, OHPs etc and a plethora of software ranging from MS Office to Adobe Photoshop (all of various versions). Are you still using spreadsheets & manually tracking all these assets? Can you tell whether all the software you have comply with licensing? Can you tell how many of these hardware components & software copies are available with you at any instant? Can you tell how much of these are under utilized or not utilized at all?

#1 Your employees come up with different service requests ranging from "Not able to print from my PC" to "Cannot send mail". How do you ensure that such requests are taken care of by your support staff, that too efficiently? How do you ensure none of the requests fall through the cracks? Is there a Knowledge Base which can offer self-help for the employees? How do you keep track a high volume of requests?

|W|P|114388981753030030|W|P|Top Questions to Ask Before Buying a Help Desk & Asset Management Software|W|P|venkat@sgdnetworks.com4/01/2006 03:08:00 AM|W|P|Nishanth Technologies|W|P|

Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business – Bill of Lading with multiple custom forms should be present there. However if you need the extension to standard ERP/Accounting application – you may be looking at the option to customize the system. Microsoft Business Solutions Great Plains might be considered as ERP platform, ready for customization. Let us give you customization highlights.

• Sales Order Processing – SOP is the module, where you create customer order, transfer it into invoice upon the completion, fulfillment or allocation. So, naturally Bill of Lading should be originated in SOP. Also nice feature in SOP is multicurrency (Dollar, Euro, Yen, Yuan, Peso) support, so Bill of Lading report could be produced for international shipment

• MBL/HBL – House Bill of Lading may include several Master Bill of Ladings, associated with the shipment to specific customer. Microsoft Great Plains naturally associate invoice with single customer, this is why House Bill of Lading should be light Great Plains Dexterity customization, where you combine several shipments into one container (HBL). Simplified solution is just to use user defined fields for HBL & MBL.

• Cargo/Shipment Inquiry – you might also need to see the profit/loss on the shipment/HBL. This window should include all AR and AP invoices associated with HBL with drill down to original documents functionality. This maybe done as Dexterity, C#/VB.Net application, publishing SOP tables (SOP30200, SOP30300), or just a report

• Technologies. Microsoft Great Plains Dexterity is programming language and development environment of Great Plains. Great Plains Software has Great Plains Dynamics/Dynamics C/S+/eEnterprise and currently Microsoft Great Plains lines of products developed in Great Plains Dexterity. ReportWriter – this tool will allow you modify existing Picking Ticket, Packing List or Invoice form to produce Bill of Lading. ReportWriter has some restrictions: in order to place fields from your custom tables or from third party modules on ReportWriter report you need light Dexterity customization (rw_* functions). VBA/Modifier will allow you to modify Great Plains forms and attach VBA scripts to buttons. Crystal Reports – with Crystal Reports Designer you could produce the report of maximal complexity, including the report pulling info from heterogeneous databases (as if portion of your Bill of Lading info resides in Oracle, DB2 custom database).

|W|P|114388974543042874|W|P|Bill of Lading - Custom Reporting for Microsoft Great Plains - Overview for Consultant|W|P|venkat@sgdnetworks.com4/01/2006 03:07:00 AM|W|P|Nishanth Technologies|W|P|

(1) Avoid using the same variable again and again for different purposes.

This happens with us that we think that more and more memory will be wasted if we declare seperate variable for each purpose. But, if any debugging is about to be done and program is quite a typical. Then, debugger will get confused and Dry-Run will also not work in such a scenario. So, if your program is small then, you can use the same variable. But, if it is complex, then do not use the same cheap practive.

(2) Use capital letter to variable name for global variables.

You should use capital letters because, there should be distinguishable difference between a local variable and global variable. There should not be any confusion while dry run or debugging.

(3) All the variables should be declared at one place.

This helps the programmer to analyze whether some variable is yet declared or not. If we declare them at different locations, then, a proper manner can not be acheived in your programming. The variables should normally defined just below the function declaration.

(4) There should be proper indenting in whole program.

Indenting helps you understand the program and the logic behind the statements well. This is cheap practice to write the functions, iterations and conditional statements without indenting. It looks like a junk also. There should be a proper demarkation in your mind and the same concept should be followed in all the portions of your program.

(5) Commenting.

Commenting is very much important. Although, there is no relation of them from your logic and programming. But, once you debug your program or new amendments are done, it becomes tedious to understand the logic behind that coding section. That is why, commenting is very neccesary in programming.

(6) Do not use labels.

In some programming languages like BASIC, there is scope of providing labels. Experts say that using such labels produces extra burden in the operating system. So, you should avoid them.

(7) Do not declare unused functions or variables.

This practice is also prohibited. You should not declare such a variable which is not getting used anyewhere. You should check it out when you are going through dry-run also.

(8) Coupling should be avoided cohesion should be increased.

Coupling comes to picture when the output of a function is input to other. This produces a sort of ripple effect and debugging becomes a problem and error-prone programming is found in such state.

(9) Always write the program or check the logic then, come to type.

This is a general practice that people directly sit on system and try to build logic and all the necessary corrections are done. But, such anactivity may produce problems like unused variable (regular declaration and descarding) , unused functions (declare and forget to call or just checking), moving in the wrong direction of logic. So, you should decide things before you come to portray them.

(10) Do not learn programs, try to develop your own logic.

|W|P|114388970450356819|W|P|10 Programming Tips|W|P|venkat@sgdnetworks.com4/01/2006 03:07:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity Requirements Planning, Job Costing, Master Production Scheduling, Materials Requirements Planning, etc. However Microsoft Great Manufacturing serves so-called discrete manufacturing market niche. At the same time Great Plains fits to mid-size companies, where manufacturing processes might be categorized as light assembly. One of our clients, mid-size crane trucks manufacturing facility recently outsourced all the parts assembly to overseas partners and concentrated on sales, distribution, leasing and only light final assembly. This small article describes you how you could deploy Microsoft Great Plains Bill or Materials in process manufacturing. We will describe combination of Sales Order Processing (SOP) module to get customer orders, Bill of Materials (BOM) to assembly for the order, Inventory Control (IV) to allocate materials and Purchase Order Processing (POP) to replenish inventory

• Order Taking. In SOP you create Sales Order and you use standard functionality – place order in the batch and then upon the completion you transfer order to Invoice to bill the customer. If you participate in international business, you should take advantage from Multicurrency (MC) feature, expanded on SOP (Euro, Yen, Yuan, Peso, Real, etc.).

• Manufacturing. In the case of light process or discrete manufacturing we recommend you to call Bill of Materials engine upon the saving of Sales Order to allocate assembled part into final product. This is classical Great Plains Dexterity customization, which should be tuned to your specific customer needs and this work could be done by Great Plains Dexterity Source Code partner only.

• Catch Weight. If you are in process manufacturing – your raw materials are purchased in random weight units, and you need to account them in these units: cases, rolls, casks, etc. Typical solution in Great Plains is to have Great Plains Dexterity custom logic to associate the cask with Serial or Lot Number and record it in your inventory in pounds or kilograms. In this case you can return defective unit back to your supplier, identifying it by serial number and make correct inventory adjustment

• POP/Replenishment. Purchase Order Processing has PO Generator to automate replenishment by ABC code, reorder level and other criteria

• Inventory Adjustments. In process manufacturing you have variable input to get fixed output. The simplest way to realize the variances – make Inventory adjustment transactions on the regular basis.

• Reporting. As the solution we recommend is definitely budget one, lacking functionality should be covered with accurate and flexible reporting. We recommend you to have Crystal Reports programmer helping you in pilot project. Be sure that she/he has good knowledge/experience to work with Microsoft Great Plains tables structure.

|W|P|114388965995630035|W|P|Great Plains Bill of Materials Setup & Customization for Process Manufacturing - Overview|W|P|venkat@sgdnetworks.com4/01/2006 03:06:00 AM|W|P|Nishanth Technologies|W|P|

This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.

Defining OLAP Solutions

The data warehouse offloads data from a multitude of sources. The cleaned, validated and loaded data is voluminous and daunting. This data needs to be organized, categorized and arranged in meaningful order for analytical purposes. OLAP solutions are specifically designed to cater to this need.

OLAP solutions used by Data warehouses are:

Multidimensional views of data. Data in the data warehouse is organized into subject oriented categories and tables. Fact tables are constructed and linked to various dimensional tables in star or snowflake schemas or combinations of them to form multidimensional views of data. Cubes are built using these multidimensional schemas. Rapid browsing and querying then becomes possible. These views are independent of the way in which data is stored in the data warehouse.

Interactive query and analysis of data is another OLAP solution that enables users drill down, drill up and slice data by using multiple passes. Users can drill down to successive lower levels of detail or roll up to higher levels of summarization and aggregation.

Analytical modeling is an OLAP tool that is a calculation engine for deriving ratios, variances etc., involving measurements and numerical data across many dimensions.

Functional models are made available by using OLAP for forecasting, trend analysis etc. They support users in data analysis.

Graphical OLAP tools are used to display data in 2D or 3D cross tabs and charts and graphs with easy pivoting of axis. This is important for users who need to analyze data from different perspectives and the analysis of one perspective leads to business questions that need to be examined from other perspectives.

Rapid response to queries is a must in any analysis of data and the measure of success for the OLAP tool. Nigel Pendse and Richard Creeth, authors of the OLAP Report developed the FASMI (Fast Analysis of Shared Multidimensional Information) test to judge whether or not an application qualifies to an OLAP tool. Their contention was that an OLAP tool should provide fast browsing capabilities (<>

Multi dimensional data storage engine stores data in arrays. These arrays are logical representations of the business dimensions.

Understanding Data Warehouse design

At a very global level, construction of the data warehouse is a business project by itself. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.

The general questions that are asked may be as below...

Do we need a data warehouse?

How will it help the business?

What will it mean in terms of cost?

What are the current data analysis methodologies being adopted?

In what way are they deficient?

Will setting up the data warehouse help in reducing these deficiencies?

What kind of reporting and analysis do we really want?

What is that we are getting now?

Will such data analysis make the business more efficient?

Will it help the business improve its services and customer relations?

Once the replies to the above questions have been asked, the organization needs to examine other very crucial issues that will determine the wrap and hoof of the data warehouse that is being set up.

What are the kinds of data that are being generated by the enterprise? What kinds of data storage technologies are currently being used to backup and store historical data?

What other external sources of information do we need to tap to make the data in the data warehouse meaningful for analysis?

What kind of hardware and software will be required to set up this data warehouse?

Who will be the personnel to handle the process of creating the data warehouse?

Which departments will benefit from the data being created?

Will the data warehouse be scaleable?

How will it connect to the different data sources for data?

How will we ensure that quality data is generated?

What kinds of tools will be deployed to support end user needs for reports and analytics?

The answers that emerge from these questions will be a set of business requirements. These requirements will determine the kind of data warehouse that will be ultimately set up in the enterprise. The first steps would be to define the global parameters that will shape the design of the data warehouse. The design can be a top down approach as recommended by Bill Inmon or a bottom up approach recommended by Ralph Kimball. It can be a combination of the two called the Hybrid approach or it can be a federated approach. Let us have a brief look at what these different approaches mean.

For more visualization of this article along with the screen shots and complete free training tutorials on Microsoft Analysis Services visit

|W|P|114388962178366577|W|P|Defining OLAP Solutions and Data Warehouse design|W|P|venkat@sgdnetworks.com4/01/2006 03:05:00 AM|W|P|Nishanth Technologies|W|P|

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERP.

What is ERP?

Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve and support multiple business functions. An ERP system can include software for manufacturing, order entry, accounts receivable and payable, general ledger, purchasing, warehousing, transportation and human resources. Evolving out of the manufacturing industry, ERP implies the use of packaged software rather than proprietary software written by or for one customer. ERP modules may be able to interface with an organization's own software with varying degrees of effort, and, depending on the software, ERP modules may be alterable via the vendor's proprietary tools as well as proprietary or standard programming languages.

Brief History of ERP

The focus of manufacturing systems in the 1960's was on Inventory control. Most of the software packages then (usually customized) were designed to handle inventory based on traditional inventory concepts. In the 1970's the focus shifted to MRP (Material Requirement Planning) systems that translated the Master Schedule built for the end items into time-phased net requirements for the sub-assemblies, components and raw materials planning and procurement.

In the 1980's the concept of MRP-II (Manufacturing Resources Planning) evolved which was an extension of MRP to shop floor and Distribution management activities. In the early 1990's, MRP-II was further extended to cover areas like Engineering, Finance, Human Resources, Projects Management etc i.e. the complete gamut of activities within any business enterprise. Hence, the term ERP (Enterprise Resource Planning) was coined.

Why is it Necessary?

By becoming the integrated information solution across the entire organization, ERP systems allow companies to better understand their business. With ERP software, companies can standardize business processes and more easily enact best practices. By creating more efficient processes, companies can concentrate their efforts on serving their customers and maximizing profit.

Market Leaders

The top five ERP vendors, SAP, Oracle Corporation, Peoplesoft, Inc. (now Oracle Corp.), JD Edwards & Company, and Baan International, account for 64 percent of total ERP market revenue. These vendors continue to play a major role in shaping the landscape of new target markets, with expanded product functionality, and higher penetration rates. SAP dominates the $6.7 billion ERP applications market in Europe with 39% market share. Oracle and PeopleSoft come second and third respectively, followed by SAGE Group and Microsoft Business Solutions.

The Future of ERP

Industry analysts expect that every major manufacturing company will buy the software, which ranges in cost -- with maintenance and training -- from hundreds of thousands of dollars for a small company to millions for a large company. AMR Research of Boston says consolidation among the major players will continue and intensify. ERP vendors are expected to put more effort into e-commerce, CRM and SCM initiatives, with leaders redirecting between 50% and 75% of their R&D budget to these projects.

According to Gartner research group, the rapid evolution of ERP has already lead to a new corporate must-have, ERP II, which is supposed to help businesses gain more competitive edge in the future. The major difference is that ERP II involves collaborative commerce, which enables business partners from multiple companies to exchange information posted on eCommerce exchanges.

In the next tutorial we will talk about popular ERP Products and the Modules and Application related to them.

|W|P|114388956907250945|W|P|Enterprise Resource Planning Overview|W|P|venkat@sgdnetworks.com4/01/2006 03:04:00 AM|W|P|Nishanth Technologies|W|P|

MicroWorld Technologies, Inc. the leading solutions provider in the area of Anti-virus and Content security, has announced the launch of its new version of MailScan Ver. 4.5, the antivirus and content security software for mail servers.

The new version of MailScan provides additional security features to allow users to monitor the TCP connections on their systems, and use enhanced Anti-SPAM control to fight SPAM.

The new security feature interface displays all the active TCP connections to your computer. It lists information about the processes, protocols, local addresses, remote addresses and Process Status on the computer. It allows you to identify any unauthorized access to your mail server and take effective counter measures to safeguard your system.

MailScan 4.5 provides the user with real time access to Relay Blackhole List at for IPs of known Spammers. The site maintains active real-time Blackhole list that you can use to verify if any IP that connects to your MailServer is listed as that of a known Spammer, and take appropriate action.

MailScan 4.5 is the next step in the continuing process to provide added security to mail servers against virus attacks, SPAM and other forms of security threats to networks via e-mail.

|W|P|114388951267744132|W|P|MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software|W|P|venkat@sgdnetworks.com4/01/2006 03:03:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Business Solutions Great Plains serves to the wide spectrum of horizontal markets and could be also considered as generic ERP/MRP/Accounting platform for light and advanced customization to fit verticals. In this small article we describe distribution sector with the example from metal distribution - Dealer/broker of industrial nonferrous by-product scrap, de-tins and de-oils industrial by-product scrap and finished parts. It might sound a bit complex – but we think this is typical for this horizontal market niche. The language of the article is targeted to primarily technical consultant and in-house programmer/software developer. In our opinion – ERP applications should be implemented with the leveraged help and support of internal IT people – we are entering into the epoch of technical specialists and IT departments – smile.

Industry specifics:

• Cost / Price with 5 decimals of the dollar. Well – if you sell thousands of pounds with the price per pound – then every tiny fraction of the cent makes a difference in vendor selection. In Microsoft Great Plains you have reserved 5 digits in the currency datatype to be able to track 5 decimals of the $. In case of Euro or other currency in multi currency environment – this should be applicable to your local currency: Rand, Peso, Real, Pound, Yen, Chinese Yuan.

• Settlement Report. This report is typical for distribution and logistics type of business. In case of metal distributor – this report shows either monthly transactions log or HBL (House Bill of Lading) /MBL (Master Bill of Lading). Again we should implement 5 digits fractioning of the main currency. This report is classical Great Plains Dexterity or Crystal Report – depending on the level of integration with Great Plains screens (Dexterity gives you seamless integration – Crystal requires Modifier/VBA scripting to call Crystal Reports engine)

• Historical Customer Orders. When order taker gets order by phone she/he should have instant access to customer’s recent purchases and comparisons with average recent sales for the specific alloy or metal item. The customization you need is Great Plains Dexterity sales pad and instant item sales inquiry. Both should pull info from Sales Order Processing (SOP) module and have item lookup to Inventory Control (IV)

• Compliance Reporting. We recommend you to use Crystal Reports – this tool should stay for five years and plus. These reports should publish Great Plains company database data at your will and the requirements of the federal or state authority

• Customization & Modification. You should consider using these tools: Great Plains Dexterity (requires some training and experience), Crystal Reports, Visual Studio.Net web publishing, MS SQL Server stored procedures for data integration and feeding.

|W|P|114388945019509479|W|P|Microsoft Great Plains in Metal Distribution: Implementation & Customization - Consultant Overview|W|P|venkat@sgdnetworks.com4/01/2006 03:02:00 AM|W|P|Nishanth Technologies|W|P|

It is really interesting that a bug can create problem for a learned person even the bug is not alive. One day my one friend was working and a bug created much problem. It was not easy to track the bug. evrytime bug was challenging any other different problem.

What is bug : When there is a defect in a software program, we call it a bug. If we start the product and it crashes, there is a bug. If one find a typo in the help system, that's considered a bug too. The report which is about software problem is called software problem report (SPR), which is the same as a bug report.

What is bug tracking: A bug tracking system is designed to track the bug. It is considered as a database. The bug tracking may be homegrown or it may be a commercial system. In any case, a bug is entered as a record in the database, where it can be assessed and tracked. The user interface for bug tracking usually consist of navigable views and forms for editing existing bug reports or writing new ones. In bug tracking a unique login ID and password is provided to every user. When a user writes a bug, adds comments or changes a status field, a good bug tracking system will log the ID of the person, creating or amending the record. That is the way a true history of a bug report for bug tracking is maintained. One of the most important feature of bug tracking is keyword searching. For example while saving a file any user finds a crash bug. The bug tracking system software should have the facility to perform a keyword search on "crash and file".

|W|P|114388940063056075|W|P|How a Bug Challenges to a Software Professional|W|P|venkat@sgdnetworks.com4/01/2006 03:02:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Business Solutions Great Plains has full-featured manufacturing set of modules. In this small article we would like to give you highlights on what kinds of light customization you could deploy, before jumping into Microsoft Great Plains Manufacturing realm. Great Plains Manufacturing is targeted to discrete manufacturing clientele, which is opposite to process manufacturing – food processing, mining, including precious metals/gold/platina, oil and gas / chemicals / agriculture. Manufacturing from accounting stand point is moving inventory into work in progress and then into finished goods. And this is where we have fundamental difference between discrete and process manufacturing.

• Barcoding – this would be the help in allocating your inventory to the manufacturing activity. We saw clients who were asking about full-featured manufacturing, but later on we realized that they were envisioning barcode scanning people walking through their warehouse

• Bill of Materials – well if barcoding doesn’t do the job for you – you should look if Bill of Materials module will automate your operations. In Bill of Materials you could program light manufacturing. We saw the machinery manufacturing/assembly client in Chicago area who asked us to help them phase out Kiwell manufacturing, because of high annual maintenance cost. So – our opinion is if you are manufacturing client in the USA – you should probably first look at the outsourcing part of the business – if 90% of manufacturing of going to China – you should consider Great Plains Bill of Materials module implementation only with light manufacturing extensions

• ERP/ Capacity planning - well this is were you have to consider manufacturing suite. Great Plains Manufacturing has complete set of discrete manufacturing modules: Bill of Materials, ERP Capacity Planning, Cost Center.

• Reporting. In our opinion the best way to save software money is to replace highly priced module with similar reporting. Reporting is rather static, but in its prints outs it allows you to avoid expensive license fee (if you decide on SAP or Oracle Financials – this will triple your software expenses)

|W|P|114388935146757638|W|P|Manufacturing Solutions for Microsoft Great Plains - Overview for Consultant|W|P|venkat@sgdnetworks.com4/01/2006 03:00:00 AM|W|P|Nishanth Technologies|W|P|

In today’s business world it’s all but impossible to escape Microsoft. Either you're using MS applications, developing your own, or negotiating your company’s acquisition by this techno-behemoth. I must that the company is a daily part of my life (in fact I’m typing this article on MS Word). I’ve found however, that although Microsoft develops many versatile business software products, the company’s ‘one size-fits-all mentality goes only so far. I’m referring to the Microsoft CRM system. For you lay-people out there, CRM (customer relationship management) systems are designed to help you gather and interpret customer data in order to anticipate future customer purchasing demands and trends.

Besides costing substantially more than other CRM systems on the market, the Microsoft CRM system lacks some of the great features that come standard with other systems. I like this analogy: Microsoft CRM can be compared to a Cadillac with no extras; no A/C, no four-disc ABS, no cruise control, no sun roof, no radio, no power locks or windows. Sure it’ll get you from point A to point B, but you’ll not be making the trip comfortably. And all this at a premium price. Now you have other CRM systems out on the market; let’s compare these to an option-packed Hyundai. Sure it doesn’t have the long reputation of the Caddy, people may not notice you coming down the road, maybe it only has a 50k mile warranty to the Caddy’s 75k, but all that will be quickly forgotten as you enjoy the deluxe stereo system, sun roof, leather seats while you find the shortest route from A to B with your GPS. Best of all, the sticker price is a third of what they wanted for the Cadillac. Just like you can’t rely on brand name alone to sell cars, Microsoft shouldn’t rely on its former success to sell CRM systems. This is however, par for the proverbial Microsoft course, i.e. Microsoft Office upgrade.

Ok, let’s get back to the Microsoft CRM system. What CRM features might you be interested in that not included in the Microsoft CRM package? How about power dialing? Many comprehensive CRM systems are used by out bound call centers to not only track customer leads, but to call customers to follow up; the bottleneck is that the human hand can only dial so fast. Power dialing allows your sales agents to make up to 40 more sales calls a day. Last time I checked, the Microsoft CRM didn’t offer this option. Voice messaging is another time saving feature that allows your agents to record a sales message designed to elicit a customer call back. Many CRM systems also come with features that make business-to-business (B2B) marketing and sales calls much more effective.

Although Microsoft CRM may tout the easy interface of it’s product with other MS applications, other all-in-one CRM packages either accomplish MS interface, or make MS applications unnecessary with other innovative techniques and technologies. And they do this for less than you’ll pay for a comparable Microsoft CRM system.

|W|P|114388930205493734|W|P|Microsoft CRM and No-Frills Cadillacs|W|P|venkat@sgdnetworks.com4/01/2006 02:59:00 AM|W|P|Nishanth Technologies|W|P|

The cornerstone of successful automated office systems is the ability to convert printed information into electronic data. Document processing applications need to capture and index data accurately and efficiently to bridge that gap.

This capability can be enhanced with the integration of Optical Character Recognition (OCR) software. By this means, extracted data is used to index and save the document into the document management application.

This intelligent document recognition and classification is central to Tokairo’s new contract with a major UK supplier of dairy products. The delivery and receipt procedure works like this:

• When an order is received from a customer a despatch note is issued listing product description, quantities, weight and code

• On delivery the note is signed by the customer along with the customer’s Goods Received Note (GRN) which details the goods actually delivered

Problems arise if goods are damaged, lost or delivered piecemeal, as discrepancies can occur between the despatch note and the customer’s GRN.

The system has been set up so that these documents can be automatically read, matching delivery line items with corresponding items from the company’s despatch notes.

After every delivery, despatch notes, GRNs and any other delivery/receipt documents are scanned by the delivery driver at any one of the company’s 20 depots in the UK.

Coping with different document styles and formats

The company’s system is configured to recognise every GRN’s header and footer, so it can read each item’s line code and quantity. This process is made complicated because each customer uses a different GRN style, format and layout. Also, there can be multiple GRNs for one despatch note – typically when a single delivery goes to several different customer sites.

However, once the OCR software has been correctly configured to read the lines in the different styles of document, accurate reading of forms is high – ranging from 85% to 90%. A threshold can be set by users so that any document that falls below a certain level (e.g. 80%) is entered manually. So any document that can be read less than 80% accurately is flagged up for manual indexing. Anything above this value is saved automatically.

The system automatically consolidates this process by matching the different documents and line items in the original order, and stores all documents in the appropriate order folder.

Automatic invoice amendment

Any discrepancy is automatically flagged up and investigated. This generates an amendment to the sales invoice issued to the customer, which in turn reduces the company’s debtor days by ensuring that the sales invoice matches the customer’s GRN.

Should there be any discrepancies or delays in receiving payment, staff have online access to all delivery information stored in the order folders.

Integrating intelligent document recognition and classification technology provides significant customer benefits:

• Reduced administrative overheads • Improved business visibility • Reduced invoicing errors and attendant disputes and delays • Increased cashflow by minimising debtor days • Improved customer service • Enhanced corporate image

|W|P|114388918123952696|W|P|Bridging the Gap between Paper and Data|W|P|venkat@sgdnetworks.com4/01/2006 02:58:00 AM|W|P|Nishanth Technologies|W|P|

COMMAND LINE FUNCTION

A powerful command line script processor has been introduced to SQL Delta 3.1. The script processor provides the user with a mechanism for controlling SQL Delta by remote control, allowing databases to be compared and changes scripted without any user intervention. The script language is standard XML and provides a variety of commands for configuring and controlling SQL Delta. In addition to the standard comparison and script functions the user can export reports in various formats including HTML format and then have those reports automatically emailed to the appropriate user. Even scripts can be emailed as attachments if a change is detected in the database.

“We have designed the script processor to provide users, especially DBA’s, with the convenience of programmatic style control of SQL Delta without the need to dig out a compiler and build an application. Even so a programmer can very easily create a seamless execution of SQL Delta from within their own application if they desired” Jay Bailey – SQL Development Manager.

Owner Mapping

SQL Delta 3.1 now provides object ownership mapping and now it is possible to perform comparisons between databases with different users and different ownership configurations. The user can map on a user to user basis or a many to one user basis and there is no limit to the number of users that can be mapped.

Other New Features

Improved tools such as “star view” checking to ensure all views that may use “select * ..” are up to date and a qualify names tool for checking to see if stored procedures include qualified names, therefore ensuring the best performance from your server.

Sydney, 10th May 2005 – TASC have released SQL Delta version 3.1, a high performance SQL schema and data comparison tool for analysis and synchronization of databases.

Version 3.1 of SQL Delta offers the following new feature and improvements and is available now http://www.sqldelta.com

Founded in 1991, The Australian Software Company (TASC) is an Information Technology solutions provider developing customer orientated applications. Over the past years we have developed a vast range of software applications.

Our specialty is developing systems based on TASC's business and systems analysis. The development of these systems is done using our range of components, which have been built, tested and implemented for various clients. These components, plus our quality assured methodologies, enable us to build high quality systems in a timely manner. Typically we develop our software using the Microsoft Windows or NT platforms, although we are able to develop in differing areas especially when relating to Web/Java based systems. We also use a variety of database servers although this is dependent on the client and their available technology.

|W|P|114388913452372906|W|P|New SQL Delta Version 3.1|W|P|venkat@sgdnetworks.com4/01/2006 02:57:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB Admin touches.

• The first script transfers salesperson and sales territory from Customer master file to Project master table

update PA01101
set
SLPRSNID=b.SLPRSNID,
SALSTERR=b.SALSTERR
from
PA01101 a
join RM00101 b on a.CUSTNMBR=b.CUSTNMBR
where a.SLPRSNID<>b.SLPRSNID or a.SALSTERR<>b.SALSTERR

• The second scripts unlocks Project Accounting user, this rare and funny one – really hard to get it from Microsoft Business Solutions Tech Support site:

delete PA000001 where userid='put user id here'

• The third script is really advanced one – it is for users trying to place billing address with contact info on the PA invoice form at the bottom section – address comes from Contract – not from the project

/* Updates Primary Bill To Address Code for Billing invoice to be the one from Contract Master table, instead of Primary Billing Address Code from Customer */

update PA13100 set PRBTADCD=c.PRBTADCD from PA13100 a join PA13200 b on a.PADocnumber20=b.PADocnumber20 join PA01201 c on b.PAPROJNUMBER=c.PAPROJNUMBER

/*
update PA13100 set PRBTADCD=c.PRBTADCD
from PA13100 a join PA13200 b on a.PADocnumber20=b.PADocnumber20 join
PA01101 c on b.PACONTNUMBER=c.PACONTNUMBER
*/
/*
Fill user defined 1 on the Billing HDR to contact person from the appropriate customer master address rec.
*/
update PA13100
set PAUD1 = left(b.CNTCPRSN,20)
from PA13100 a join RM00102 b on a.CUSTNMBR = b.CUSTNMBR and a.PRBTADCD = b.ADRSCODE
|W|P|114388904589868765|W|P|SQL scripts for Project Accounting: Microsoft Great Plains series - overview for developer|W|P|venkat@sgdnetworks.com4/01/2006 02:56:00 AM|W|P|Nishanth Technologies|W|P|

Are you ready? SQL Server 2005, the next-generation data management and analysis software from Microsoft, will deliver increased scalability, availability, and security to enterprise data and analytical applications. SQL Server 2000 Reporting Services is a comprehensive, server-based reporting solution that can author, manage, and deliver both paper-oriented and interactive, Web–based reports.

Develop better understanding of Microsoft .NET Developer Tools

2.) ROI and Business Value of Microsoft SQL Server & SQL Reporting Services

In this session, we’ll take a look at technical and business scenarios where Microsoft SQL Server & SQL Reporting Services provide value. We’ll show you how to make basic value quantifications based upon those scenarios. David will also review the value proposition and selling points for Microsoft SQL Server & SQL Reporting Services. The key portion of this session will include introduction to and training on a value-based tool developed for the specific purpose of accelerating SQL Server implementations. This training will include guidance on how to position the results with your customers. In depth demonstration.

Speaker: David Kirkman, MCSE+I and Partner Technical Specialist responsible for partner technical sales readiness and business case development for Northern California Small-Midmarket Solutions & Partners. 9 years in technology as a technical project manager, and business case developer.

3.) Microsoft .NET Developer Tools

During this session you will learn how Partners can leverage developer tools and technologies to maximize customer impact with minimal investment. How the next generation of tools from Microsoft will increase efficiency in development projects; develop a better understanding and vision for Visual Studio .NET and Microsoft .NET.

Speaker: Marc Wolfson is a Developer Solution Specialist on the Developer and Platform Evangelism. Marc has been with Microsoft for four years focusing exclusively on Developer Tools and technologies. Marc is responsible for supporting a healthy developer eco-system in Northern California highlighting the productivity of Microsoft’s developer tools as well as the ease of integrating Microsoft Platforms Technology. Marc was one of the founders and Chief Technologist of Nextera, technology consulting firm acquired by Knowledge Universe in 1999. While at Nextera, Marc provided development and platform architecture guidance to many fortune 500 customers. While at Nextera, Marc served on the Microsoft Partner Advisory Committee for developer technologies including the inception of .NET and C#. Marc has over 20 years of experience in the industry and has guided customers through the client-server trend, Business Process Engineering, Workflow and Document Imaging, the introduction of the Web, Year 2000, Dot Com explosion and implosion, and the adoption of XML, .NET and Java technologies.

|W|P|114388901169518420|W|P|MCP Market News: Microsoft SQL Server & SQL Reporting Services|W|P|venkat@sgdnetworks.com4/01/2006 02:55:00 AM|W|P|Nishanth Technologies|W|P|

People often ask me: What image file formats will Photoshop open or save in? What are the advantages/disadvantages?

Photoshop has the capability to open and save many different graphic files. Here are some of the most popular ones.

Note: When you open an image file other than a Photoshop one, that image will default to the background layer.

.psd, .pdd, .eps Photoshop File. This format preserves the information in all the layers. If you're going to continue working with a picture, this is the best format to use. File size can be quite large, however. Note: It is advisable to save your work in the most up to date Photoshop format available. For example: if you have Photoshop CS and are sent a Photoshop 7 file, you should save it as a Photoshop CS file to preserve any elements that may not be supported by Photoshop 7.

.jpg, .jpeg .jpe This format compresses the images, so that information (details and colour subtleties) are lost. You can choose how much you want to compress the image. Good format for use on the web. Small file sizes. Millions of colours.

tif, .tiff Common in use with early scanners. Will produce high quality images, but very large files. Not for use on the web.

.gif Pronounced both "Gif" and "Jif", this file is one of the most popular for web graphics as it loads quickly. 8 bit format (256 colours max.). It has possibilities for transparent colour and animation.

.png New format for use on the web that is intended to replace both gif and jpeg. Compressed, millions of colours, transparencies. It compress in a different way than jpeg, and has advanced possibilities, such as alpha channel (opaque or partly transparent colours). The only trouble is: Internet Explorer doesn't support these! In 8 bit (256 colours) mode it compresses better than gif.

.bmp Windows bitmapped image. Used by Microsoft Windows applications. Good quality, large file size. Not for use on the web.

.wmf Windows MetaFile. Useful for clipart, and can be used to make large area, small sized background files.

.pcx Older general purpose format. Practically obsolete now. Not for use on the web.

.psp Internal format for Paint Shop Pro, useful if you want to swap files between these two applications.

.pcd Kodak PhotoCD format, used with Photo Developing - although most photo processors will save your photos as jpegs if you ask them to.

.pdf Portable Document File. Adobe's file system that allows electronic cross platform sharing of documents.

So what's the best format for web graphics: gif or jpeg?

The general rule of thumb is to use gifs for diagrams, line drawings, illustrations, and images that contain large areas of flat colour, and jpegs for photographs and images with continuous colour tones. The jpeg format has a very good compression rate, but compression reduces the quality of the image, so it's best to experiment with the tools in Image Ready until you have the optimal quality/file size. The gif format, on the other hand, has a smaller file size - but a limited range of colours.

|W|P|114388897290838431|W|P|Photoshop Files and Formats|W|P|venkat@sgdnetworks.com4/01/2006 02:54:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity. Dexterity in turn was built with conception of graphical cross-platform transferability (in time – 1992 – mostly Mac and MS Windows). Plus Dexterity had database abstraction level (through C programming language). The result of such a shrewd future-looking architecture – Great Plains ReportWriter has multiple restrictions and drawbacks.

Let’s first look at the advantages of using ReportWriter:

• Seamless integration with Great Plains forms – the most typical scenario – you modify SOP_Long_Invoice_Form or SOP_Blank_Invoice_From and then print your invoices with modified form – usually with your logo and changed formats and positions of the fields

• Parameters Entry Forms. Each existing report (Reports section) has associated parameters entry form. Restrictions:

• No Cross-Modules links. You can not associate report with the tables from non-related modules. For example you can not have Sales Order Processing (SOP) and Purchase Order Processing data on the same report (you actually can – but you need Dexterity programmer help)

• Custom Reports. You do not have parameters entry interface for your custom reports, but you could use restrictions to restrict the selection. Custom reports could be used to export data from Great Plains in text (and then Excel format)

Advanced ReportWriter programming

• Rw_ functions in Great Plains Dexterity. When you need cross-modules data on the same report (Bill of Lading, which you could produce on the base of Picking List) you need to move the report you want to customize into your custom DYNAMICS.DIC and fill the gaps with RW_ functions – these are allowed to be placed on the report with parameters

If ReportWriter doesn’t do the job:

• Crystal Reports. Current version 8.0 and 8.5 (July 2005) are MS SQL Server based, where Crystal Report could work at will and produce all the desired links – we recommend you to base Crystal Report on SQL Stored Procedure or SQL View. You call Crystal Report engine via Modifier/VBA – you need Customization Site Enabler license. If you are on Great Plains Standard version: 7.5, or Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Btrieve/Pervasive SQL/Ctree – you need to install Pervasive SQL driver (or Faircomm driver for Ctree)

|W|P|114388891993986156|W|P|Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW - ReportWriter - Tips for Developer|W|P|venkat@sgdnetworks.com4/01/2006 02:53:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Office program is a programming tool called Visual Basic for Applications (VBA) that comes with Microsoft Excel, Word, Outlook, Power Point, and Publisher. VBA can make your repeating jobs automatic. It also can customize Excel, Word and other Office procedures for your own needs. From Office version 2000, all the Office programs are equipped with VBA.

Hand-On experience is the key to be a good programmer. Programming tutorials are the easier way to learn any computer programs including VBA. For example, a tutorial can show people how to use VBA to automate (make automatic) an Excel routine like updating the fonts and sizes for a range of cells, or automatically pops up a calendar for selecting a date. VBA can also be used as a tool to automate Word mail-merge or create a text file from a Word document. VBA can even be used as a tool to automate email alert in the Outlook Inbox or scheduling task to do.

VBA can make one application like Excel work with another application like Word and Outlook, or any other combination. To make Excel work or control Word is called Excel automates Word. Likewise, Word works with or controls Outlook is called Word automates Outlook.

There can be many applications of automation that was introduced in the previous paragraph. For example, we can write a VBA application to make Word read an Excel address list that is saved in a spreadsheet, and then show the addresses in the Word document. Also, we can write an application to use Word to automate Outlook for reading the contact and any other data in the Contact or other folders. Or, we can use Outlook to read in Word or Excel scheduling list and use it to schedule tasks in Outlook.

Writing VBA programs is quite straightforward and can be learned in a short period, providing that there are tutorials that are well organized and illustrated with many pictures. After going through a few tutorials, the learner can explore on himself or herself the other possibilities with the programming. Learning programming is not as hard as people think. Rather it can be a fun experience to see the programs work.

There are a few free VBA learning tutorials at www.Viccompinc.com. If you would like to learn beyond the free tutorials, you can sponsor us with the other low cost tutorials. You can also request a tutorial for your own needs with the request entry of the Contact page.

|W|P|114388887108906243|W|P|You Can Write Microsoft Office Program in About 60 Minutes|W|P|venkat@sgdnetworks.com4/01/2006 02:53:00 AM|W|P|Nishanth Technologies|W|P|

Logistics automation is often considered as barcoding extension to Sales Order Processing, Purchase Order Processing, Inventory Control modules. Software extensions makers may disagree with this simplification, but budget solution works exactly like barcoding extension and is usually done via Great Plains Dexterity, Modifier with VBA and SQL stored procedures. If your company is looking for implementing automated inventory bin/item pickup and conveyer – then you need specialized software. However if you just envision your warehouse workers with barcode scanners – then read this article to understand your options with Microsoft Business Solutions Great Plains.

• Warehouse Automation. When you are looking for warehouse management automation – you should research supply chain management applications available on the market. Usually they are expensive and targeted to large logistics clients. You can use Microsoft Great Plains inventory module features, such as locations or sites, serial/lot number tracking, inventory count, inventory transfers and combine these with simple VB-based barcoding to feed documents from your barcode scanners to Great Plains directly.

• Random Weight. Food distribution – you might be purchasing food in cases or other variable weight units and resell them in pounds or kilograms to end customer. So – you need parallel quantities tracking with probably serial numbering for each case. This is typical customization for Inventory, Sales Order Processing (SOP) and Purchase Order Processing (POP) modules in Great Plains. It should be done in Great Plains Dexterity to provide seamless interface for GP users. In addition to parallel weight measures (cases and pounds) you may also need average weight control to prevent issues with your warehouse workers

• Recurring Customer Orders. You may figure out that majority of your customers order the same items each time with regular intervals. In this case you can have customer typical order screen to automate order taking. Plus – you may have associated and replacement items logic incorporated in this screen.

• Automated Shipments. If you sell on consignment – you may simply send trucks to your customers every day with recommended combination of items, based on historical data – day of the week, holidays, seasonal variations, etc. And barcode could help you in automatic picking ticket printing and allocation

|W|P|114388881677926410|W|P|Microsoft Great Plains Logistics & Warehouse Management - Implementation & Customization Highlights|W|P|venkat@sgdnetworks.com4/01/2006 02:52:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Great Plains could be tuned and setup to fit most of horizontal markets. You can deploy third party modules or build your own custom logic in Great Plains Dexterity. Today we’ll look at the options to automate building & construction business. We’ll try to use technical language to be understood by programmer, technical consultant, IT system/database administrator, web developer.

• Project-Oriented business. Construction company is project oriented. You incur expenses, labor, inventory against the building and stick to the budget in order to meet the expected profit. Microsoft Great Plains has Project Accounting module with budgeting, expenses, inventory, labor. If you need phases with their budgets – you should probably look for one of the third party project modules, such as WennSoft JobCost. If you are established business with decades of history – you might still be using such legacy (and very efficient in Phasing functionality) Project module as Intellisol Project Accounting – in this case you are looking to convert it to either Great Plains Project Accounting or other current third party module.

• Financing. Builders usually finance the projects. When you do construction project budgeting – you need automatic financing cost estimation. This is MS SQL Server stored procedure, incorporated into Great Plains Dexterity customization for project accounting module.

• Sales. It is natural way to discount the property if potential customer is willing to finance it or pay upfront for the future property. In Great Plains Receivables Management (RM) or Sales Order Processing (SOP) modules – you should have discounting quote/invoice. The discount amount is based on the phase of the construction

• Warranty. Certain percentage should be placed aside for warranty and payment to repair crews or subcontractors. Microsoft Great Plains has Field Service Suite of modules with repair automation logic/functionality. Expect the needs to customize it via Great Plains Dexterity or Great Plains Modifier with VBA

• Customization Technologies. Microsoft Great Plains is build with Great Plains Dexterity – this is former Great Plains Software programming language and IDE, it was designed in the earlier 1990th. Dexterity allows your customization work it Great Plains graphical environment and security realm. VBA/Modifier – it is for light customization of existing Great Plains screens – you can place your custom button through Modifier and then attach VBA script to this button – feel free to use ADO to connect to the database. Web applications – your can deploy eConnect to incorporate Great Plains objects into your web application – eConnect was initially designed for eCommerce developers. Crystal Reports – is reporting tool of choice.

|W|P|114388877555067396|W|P|Microsoft Great Plains in Construction & Building - Implementation & Customization Highlights|W|P|venkat@sgdnetworks.com4/01/2006 02:51:00 AM|W|P|Nishanth Technologies|W|P|

Microsoft Great Plains serves the wide spectrum of horizontal markets. Great Plains could be considered as ERP platform, which you could expand with third party modules or advance with your own in-house custom functionality. The best approach would be reasonable and balanced combination of existing modules and new custom logic. In this small article we’ll give some highlights on Microsoft Business Solutions Great Plains implementation and setup in Oil & Gas industry, especially for companies, specializing in off-shore platform installation and drilling.

• Fixed/Production Assets. Crude oil and gas production is a highly asset intensive activity, all the assets: wellheads, drills, offshore platform itself, etc. must be regularly and appropriately maintained. No wonder, that petroleum production is 24x7 with minimal downtime for repair, to maximize output produced and to minimize costs. In Microsoft Great Plains you can utilize combination of Fixed Assets module, where you depreciate your large assets – such as platform itself plus Great Plains Manufacturing with the emphasis on Capacity Resource Planning. Considering that it is not a real manufacturing, but rather allocation of your production assets and time – you could use Great Plains Project Accounting just to allocate resources, or even Great Plains Dexterity customization to serve resources allocation and assignment to the cost centers

• Logistics. Oil & Gas production is under the strict safety and environmental standards and requirements at the company, industry and governmental levels. These requirements imply best practices and efficiency in logistics, from procurement of materials to the receipt of those materials at the relevant wellsite - the right materials, right on time, at the right location. In Microsoft Great Plains you use Inventory (IV), Sales Order Processing (SOP) and Purchase Order Processing (POP) modules to automate your Logistics via Barcoding, automated shipping/receiving, etc. You combine these technologies: Great Plains Dexterity, VB/VBA (Barcoding reading and uploading to GP), MS SQL scripting, .Net web publishing.

• Production Phases. Drilling, Water/Gas preparation for injection, oil processing, cleaning, leaks monitoring – these could be set up as phases in your light manufacturing or project accounting module. You will need custom logic to be implemented in Great Plains Dexterity.

• Market Size. Estimated number of offshore drilling platforms worldwide is about 7,000. Current trend is total expenses reduction, which in turn encourages companies management to revise ERP efficiency and cost plus analyze the evolution in computer technologies.

|W|P|114388873050702422|W|P|Microsoft Great Plains Oil & Gas - Implementation & Customization Highlights|W|P|venkat@sgdnetworks.com4/01/2006 02:49:00 AM|W|P|Nishanth Technologies|W|P|

Mike Dunville* had a decision to make. As the new operations manager for Alpha Staffing, he wanted to make a difference at the dynamic staffing firm. The principals of the firm had charged him with making the day-to-day operations run smoothly and efficiently while they concentrated on growing the business in today's challenging economy.

With his background in operations and finance in the insurance industry, Mike had confidently and successfully translated some of those service practices into Alpha's daily staffing and recruiting operations. Now it was time to take the next step, and modernize the hodge-podge of computer systems that until now had been reasonably adequate for their three-office operation.

But where to start? He needed a real staffing software package. Mike knew that the custom system his former employer, an insurance giant, had implemented the year before had done wonders to improve efficiency and overall profitability. It had also taken three years to develop, and another to implement. In fact, when he had left, they were still making "customizations" -- a process he figured would go on forever.

Mike didn't think that Alpha could invest that kind of time or money. Could he could bring in some business software consultants and work with them to develop a tailored package in a shorter period of time? Mike knew that the continued success of Alpha Staffing, and its entrance into new markets and business lines would be greatly dependent on a successful staffing software system implementation.

This reinforced Mike's doubts that one of the "off-the-shelf" staffing software packages would fit their needs, even if it were quicker and easier to implement. The more he thought about it, the more Mike felt that his decision on business automation would be his biggest, and if wrong, his last. He reached for a bottle of antacid.

Mike's business is unique, like yours. Special. Unlike any other competitor in the whole wide world of staffing. Your business practices are equally different. As a result, your staffing business requires specialized information technology that addresses those unique needs. You are convinced that with the right IT infrastructure -- the right staffing software -- you will be more efficient, productive, and profitable. If you subscribe to this common belief, you, like Mike, have three options to achieve that end:

1. Develop your own custom staffing software and technology infrastructure;

2. Hire a consulting firm to develop the staffing software and IT for you;

3. Buy from a staffing software/IT vendor familiar with your industry.

Of these three options, which do you think is most likely to work the best, cost the least, and get implemented the fastest?

If you, like the high-profile public staffing firms of Norrell (now Spherion) and Manpower choose to develop your own software solution, you too may have a very expensive future write-off to enjoy. In fact, Manpower's write-off for its failed three-year software development effort in the late 1990's was pegged at $57 Million.

The right answer to this perplexing question is to buy from a staffing software vendor who is intimately familiar with the industry.

Surprised? After all, you're special, unique, different, right? Well, not exactly. Yes, it is very true that you and your competitors differ in a number of important areas, such as management styles and objectives. However, you and all of your competitors also share a wealth of common traits, such as tracking employees and candidates, performing the business transactions of orders and assignments, making payroll, and billing customers.

These shared business issues are at the core of your staffing and recruiting business, and it is these issues that a staffing software vendor familiar with your industry is best qualified to address. After all, such a vendor has researched the issues to develop the necessary technology. These industry-specific software vendors can often implement a solution that can handle 80 percent to 90 percent or more of your business operational needs. (It should be noted however, that vendor solutions may vary greatly in quality, efficiency, and cost-effectiveness, depending on their expertise and previous success in the marketplace).

But let's say that the "90 percent solution" that an industry-familiar vendor has to offer just isn't enough for you. You want it all. Or you want some features or functions that the vendors don't have.

Your options then are to either do the job yourself or hiring the project out to outside consultants. Both are similar in that you, the client, assume the overall project management risks, and, in the case of doing the job yourself, the programming chores for your unique staffing software. If you decide to take either of these routes, do so with extreme care -- as industry surveys indicate that there is nearly a 60 percent probability of its failure.

According to one survey of thousands of software projects, conducted by the Standish Group of Hanover, Massachusetts, four of 10 software projects failed outright. To make matters worse, an additional 33 percent of software projects were completed late, went over budget or were completed with fewer features and functions than originally specified. Can your staffing business afford to make that kind of risky investment?

In an even more unexpected finding, the study also revealed that the use of IT consulting houses -- even highly respected companies such as Andersen Consulting (now Accenture) and Lockheed Martin -- increased the risk of a project's failure. This is astonishing because such consulting firms have staked their reputations on and are hired for their claimed expertise at developing or implementing enterprise software from such giants as SAP and PeopleSoft.

But the reason for their poor results is not so surprising -- as it pointed to business practices that leave a lot to be desired, frequently at the considerable expense of their clients.

It should be no wonder then that dissatisfaction with IT contractors has reached an all-time high. A poll of 200 MIS managers conducted by Information Week revealed that 63 percent of them had either eliminated or rebid an IT service contract within a year. This was typically due to unacceptable performance or failure to deliver as promised.

Why the low success rate of home-grown "Do-It-Yourself" software projects?

With a success rate of only roughly 40 percent, you might be tempted to accept the premise that the very complexity of custom software would have a bearing on the success or failure of project. To a degree, this is true, however, the three main causes of software development failure, as determined by industry surveys, are not related to the technology itself, but to experience, management, and politics. They are:

1. Inexperience: Technologies and programming methods change rapidly. This means that both business-side and/or contract programmers and program managers are not always up to speed on the latest development technology. What is more important, IT-oriented program managers and programmers are rarely totally familiar with the business issues to be addressed, and so may not be able to make the connection to the best technology needed to address them.

Consulting companies, including the largest and most well-known of the accounting/IT consulting firms, often use novice talent, fresh out of school, to handle programming and management chores. This inexperience leaves clients open to potentially massive cost-overruns or, worse, a system that never works even after years of development.

You probably won't hear much about these consulting firm failures though; both the firms and their clients have a vested interest to keep such admissions of failure quiet. Only when it reaches the "public scandal" or "write-off" stage does such information become public knowledge.

2. Management mis-objectives: Any firm trying to develop a staffing software project for itself must first fully and clearly define the objectives for the project. Few do this to the extent needed.

Software development and implementation is an incredibly complex process, even for a moderately sized firm. Senior management must be involved from the get-go. End-user considerations are paramount if the technology is to be fully accepted. Questions regarding business practices, methods, and future business or technology possibilities must be answered.

Critical to the success of the project is both established accountability and an understanding that software development is inherently risky due to rapidly advancing programming technology. It's useful to remember that the billions of dollars allocated to correcting Year 2000 computer problems were the result of management and programming decisions made, in some cases, in the 1960's.

At a time when CEO's often focus on the performance of the next quarter, trying to plan and manage something that may take years and millions of dollars is difficult at best. Even with long-range planning and management, mis-steps are fairly typical. And it takes unusually strong and pragmatic business leadership to admit that they've taken the wrong development road and make any needed course changes.

3. CYA CIO's: The CEO who does not want to get involved in software or IT projects is often tempted to place all of his eggs in the basket of a trusted CIO or similar IT manager. Doing so may set the firm up for a humpty-dumpty fall.

Years ago, the MIS department was often referred to as the "glass house", where massive mainframes resided, presided over a technical priesthood whose mystic incantations were the interface between the "big iron" and the information needed to run the business. Today, business-savvy CIO's and networked computer systems are the rule.

However, the firm's CIO and the MIS department may still have a vested interest in the technology and methodology with which they are already familiar. They may want to protect their turf at all costs. As a result, their tendency is to do things "the way we've always done them", only bigger and more expensively.

At the other extreme are sometimes visionary CIO's who see a new IT project as an opportunity to bring in the latest and greatest technology, without fully understanding it or its applicability to the business. Here, they may apply an attitude that if the business sotware is "not invented here", it won't work right.

Either way, the firm loses, (although the CIO and MIS department staff may gain some new programming skills they can use on their next job).

Can you ensure the success of any "Do-It-Yourself" home-grown software project?

With so many variables -- technology, management, business practices, internal politics, competitive issues, and more, it is virtually impossible to predict the success of any custom software development project. At best, you've only got a 40 percent chance of success. You can, however, improve your chances somewhat by following a few simple guidelines:

1. Establish goals. The most important thing is to define, exactly, what you want to accomplish. What is your firm's business plan? How does IT relate and contribute to it? What should its objectives be? Be realistic in setting the goals, then document them. Get buy-in on these goals from senior management all the way to end-user.

2. Establish budget and time specifications. No matter how you cut it, software development is all about time and money. Working from your goals, consider the cost to develop the software, AND those areas where budget and time requirements can increase exponentially. This includes testing, documentation, implementation, and end user training. And don't forget ongoing support, development, and "bug" fixing.

3. Establish project milestones. Hand-in-hand with establishing your budget and time-frame -- determine what goals you have to achieve in the development process to complete the project on-time and on-budget. Some of these milestones should be, as NASA says, "GO—NO GO", milestones; that is, if not achieved, the project doesn't fly. Remember, 40% of all projects fail outright, so be prepared to cut your losses.

4. Obtain warranties and guarantees. When dealing with outside consulting firms, this is crucial. It is all too easy to point fingers after the fact, less so if clear communication between client and consulting firm spells out the expected results. And the consequences of failure. Have a "Plan B" that you can, if necessary, fall back on.

5. Avoid "mission creep". There is often a temptation to add features and functions beyond the scope or goals of the project as it progresses. This is especially true as new technology raises the "wow" factor of the possible. Stick to the established goals and avoid the quick-sand of the "never-ending" software development.

Can you succeed with the pragmatic alternative?

If all the preceding talk of the failure rates of custom software development makes you think it may not be worth the gamble, you've one viable option left. Go back and talk to those industry-specific staffing software vendors some more.

Find out exactly what they have to offer, and what they have on the boards for the future. Can their "90 percent" software be customized for the other five percent or ten percent you believe you just HAVE to have? Or, do you really need that five percent more?

Look at your own business with a critical eye to determine if your business practices can or should be adjusted to fit the available IT solutions. Remember that with any highly experienced staffing software vendor you're buying all the improvements they've made over the years for many, many clients. You may find that, while the software solution offered may not be exactly what you want, it will in all likelyhood measurably enhance the productivity of your current operations.

Above all, remember that you're in the staffing business, not the speculative, expensive, and time-consuming software development business. Stick to your own core business competencies, with the understanding that software and technology should support and enhance your business operations, efficiencies, services, and profits.

And what about Mike Dunville and Alpha Staffing? Well, he thought it through, had a lot of talks with everyone on the staff from top down, rated all of the staffing software vendors to find the one that met 80 percent of their expected needs and had the most experience and the best R&D and support capabilities, and bought it.

That was last year. So far this year sales are up 15 percent, billable hours per desk are up 20 percent, and net margin is up 12 percent. They'll add two more offices soon without a hitch, and staff retention is better as well. Mike really enjoyed passing out the big bonus checks to everyone. And getting one himself.

*Mike Dunville is a fictitious character, as is Alpha Staffing. His story, however, is fairly typical of the clients who have come to VCG, Inc. for their staffing software needs.

|W|P|114388863012220997|W|P|Lowering The Risks In Developing Do-It-Yourself Software Projects|W|P|venkat@sgdnetworks.com