|
|
|
|
|
|
|
|
|
|
|
If you company is small or mid-size special products or materials exchange broker, you probably have custom in-house made exchange application. Nowadays exchange is done over the internet, so you might have advanced web-based exchange application. Microsoft Business Solutions Great Plains could play the role of the backend: accounting, sales and purchasing ordering, backordering, allocation, collection. In this case we expect tight integration between your exchange application and Great Plains. In this small article we consider industry / market niche specifics and the ways to realize these requirements:
? Exchange Transaction. Exchange transaction usually has two parts: Sales and Purchasing. This transaction should be translated into Great Plains as Sales Order in Sales Order Processing (SOP) and Purchase Order in Purchase Order Processing (POP). Assuming that you have web developers and C#, VB.Net programmers, you can deploy eConnect Distribution ? this is Software Development Kit with sample codes, you can create or modify Great Plains objects, such as Sales Order, Customer record, Purchase Order, Vendor record. One warning about eConnect ? it is designed based on general ERP application principles: you can create work transaction only ? you can not post transaction, this is left for the Great Plains user
? Bill of Lading. In materials selling, when you order something you probably know number of packs or bundles, but you do not know exact weight or length. You get this information when you receive Bill of Lading. You need Bill of Lading automatic integration and qty update in Sales Order or Purchase Order. At this moment you do Sales Order allocation. eConnect, mentioned above should do the job
? Agent Commission. You could use Salesperson, associate him/her with items sold in Sales Order and then calculate and pay commission, using your own formulas.
? Reporting. In the case of integrated web application with Great Plains, we would expect heterogeneous sql queries and reporting, based on these queries and stored procedures. To produce nice and flexible reports ? you usually deploy Crystal Reports and publish them in your web application.
? Transaction Posting. As mentioned above ? this should be preferably done by Great Plains user with approval logic. However if you have thousands transactions per day or hour and it is physically not possible, you should go beyond eConnect functionality and post transactions automatically. You need custom stored procedures, posting and transferring Sales Orders. You can create these procedures yourself or purchase the ones, available on the market.
? Customization Tools: Great Plains Dexterity, Modifier with VBA, Transact SQL scripting to name the most popular.
Good luck and you can always seek our help in customization, implementation, integration and support. Call us: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer





According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Sales are all about leverage, because there is only so... Read More
Background: For many organizations like ours, the interim target of... Read More
Mike Dunville* had a decision to make. As the new... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
There are plenty of articles out there about how to... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
CD and DVD replication is a process that works by... Read More
We all take the computer for granted. I mean, all... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
The vast majority of us will have, at some point,... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
When reading an article where some term is used often,... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
People often ask me: What image file formats will Photoshop... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
The first topic we are going to discuss... Read More
Are you lost in the mess of documents that get... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
The adware and spyware definitions list is very long. But... Read More
We all take the computer for granted. I mean, all... Read More
Microsoft CRM is new player on the CRM software... Read More
I have recently created my first Php program. I wanted... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
While I was in college, if you would have asked... Read More
Before being able to choose a secure Internet communication system,... Read More
When making a decision to buy any piece of software... Read More
Spyware is software or hardware installed on a computer without... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Software Software |