![]() |
|
![]() |
|
![]() |
|
![]() |
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, [email protected]
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
FTP stands for "file transfer protocol". FTP is basically a... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
There is many things more frustrating than surfing a website... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
The objective for Zandi Digital is to make available clever... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
When making a decision to buy any piece of software... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
If you company is small or mid-size special products or... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Just the thought of a duel-boot scares many people away,... Read More
CD and DVD replication is a process that works by... Read More
Microsoft CRM is now on the scene and it is... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
(1) Avoid using the same variable again and again for... Read More
I love new technology. I am still ready to wait... Read More
While I was in college, if you would have asked... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Although statistics often is blamed for various deadly sins --... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
If you have Microsoft Great Plains as main accounting and... Read More
We all already got used to computer monitoring both at... Read More
In the previous ISDN article, we looked at how and... Read More
Fleet Maintenance Management is a critical position in any company... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
The most important benefit of XML is its simplicity. Though... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
What is Software?Software is a set of instruction written to... Read More
People often ask me: What image file formats will Photoshop... Read More
What is a Web Database?A web database is a database... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Finding the best spyware removers to detect and remove spyware... Read More
It is possible that if one avoided all sources of... Read More
For a windows user like me, just can watch with... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
Software Software |