Microsoft Great Plains E-commerce ? Additional Considerations For Programmer
|
Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application ? Great Plains Dynamics/Dynamics C/S+/eEnterprise. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger. And this is where Great Plains structure seems to be not transparent. Let's give you highlights:
1. Great Plains Tables Structure. Open Great Plains, if on version 7.5 or prior, Tools->Resource Description->Tables, then you should select Sales series, explore these tables:
2. Sales Order Processing module (SOP)
? SOP10100 ? Sales Order Processing header
? SOP10200 ? Sales Order Processing lines
? SOP10102 ? Sales Distribution Work and History ? it is how Invoices will be distributed in GL ? in case if you are creating quote or sales order with the following processing in GP backend ? you do not need distribution
3. Accounts Receivable module:
? RM00101 ? Customer Master
? RM00102 ? Customer Address Master ? each customer can have multiple addresses for delivering, billing, statement mailing, etc.
4. Possible issues and recommendations:
? If using eConnect ? you may decide to transfer Sales Orders to Invoices automatically with eConnect ? this might be tricky and additional scripting might be needed, especially if you are doing automatic order allocation by line item. If you are trying to relay on eConnect exclusively and not researching Great Plains Architecture ? you will need additions to eConnect from third party vendor, such as Alba Spectrum Technologies, which has the whole set of SOP populating stored procedures
? If you are not using eConnect and creating your own custom stored procedures ? you should probably create orders or other objects in Great Plains and then look at the way how they were recorded in SOP tables
? If you feel that you need to relay on Great Plains engine behind the scenes (because you feel that imitation will require you to rewrite substantial portion of Great Plains logic) ? you could deploy Dexterity triggers from Great Plains side ? this solution requires professional Dexterity programmer and is more reliable and upgrade ? proof
Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com
Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia
|
|
|
Microsoft Great Plains Upgrade ? Things To Consider And Faq
If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.What is upgrade in the language of technology? Upgrade has server and client sides.Server side - upgrade converts tables from old format to the new one. In general words - Microsoft Business Solutions developers may change table structure, append additional fields to add new functionality, things like that. Upgrade copies the table with changes to temporary table, then drops origina...(related: Software)
Microsoft Small Business Manager Ecommerce ? Overview
Microsoft Business Solutions Small Business Manager is scaled down Great Plains Dexterity based version of Microsoft Great Plains or former Great Plains Dynamics/eEnterprise. Small Business Manager first release 7.0 and all the following version was available on MSDE (MS SQL Server 2000 with limited usage and database size ? 2GB maximum). It is nice situation on the market in eCommerce niche ? we see huge number of customers, who have purchased and implemented SBM for their small and mid-size businesses and then realized that customization options for Small Business Manager are very limited: in comparison to Great Plains SBM doesn't have VBA/Modifier, it has very restricted version of Integration Manager. These restrictions lead you, eCommerce developer to direct SQL programming. Again ? being scaled down version of Microsoft Gre...(related: Software)
Instant Messaging Is A Sweet Way To Communicate
MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. I've just been 'hooked up' into Messenger and it's really a different kind of communication, quick, simplistic and even humorous with the capability to express your feelings with 'emotion' cartoons. With Messenger you c...(related: Software)
Groove Network. Are You In It?
If you are in a business that passes documents around to be reviewed and edited over and over before they are ready to be posted for advertising or for a client, then you have probably already heard of a software solution to help keep your "floating" documents organized from Groove Network. You may not be aware that there is another option out there. In this article you will be presented with some basic informati...(related: Software)
Collaboration Software: Index Of Collaboration Software Technologies
Collaboration SoftwareCollaboration Software, also known as group collaboration software or groupware, is software which allows cooperation on a business document between multiple parties on multiple computers. Collaboration software also allows the integration and merging of document changes and versions on a business document.There are two types of collaboration software: IT centered and low IT involvement. IT-centered collaboration software, like many document and content management platforms, requires new IT infrastructure, training, maintenance and support. Low IT involved collaboration software communicates collaborative information ...(related: Software)
Microsoft Great Plains Customization And Development ? Overview For Programmer
When Great Plains Software was designing and developing Great Plains Dynamics/Dynamics CS+/eEnterprise - it placed several fundamental principles into the system1. Computer platform independence. If you consider the situation in the computer software industry those days (earlier 1990-th) - nobody knew which office computer platform will be the winner: IBM PC ...(related: Software)
Microsoft Business Solutions Var/partner Selection ? Overview For It Director/manager/controller
Microsoft Great Plains and Microsoft CRM become more and more popular, partly because of Microsoft muscles behind them. Now Great Plains is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. Microsoft CRM is extremely scalable and fits to all the market niches.<...(related: Software)
Groupware Finds Home In American Business: Collaboration Tool Analysis
What is Groupware?Have you ever had to manage document collaboration in a hurry? No need to be ashamed if you said "yes." Virtually every American business has experienced moments of ad hoc team collaboration. In other words, the ideal business collaboration method involves meticulous record keeping and organization; all deadlines are met; nobody feels rushed. That doesn't sound ...(related: Software)
Microsoft Axapta, Navision Or Great Plains: Erp Selection For Large Corporation
If you would like to pick something from Microsoft, or its ERP subdivision ? Microsoft Business Solutions, and in case of large public company, you should consider these three: Axapta, Navision or Great Plains. We are not talking about Sol...(related: Software)
The True Meaning Of Freeware
The vast majority of us will have, at some point, had freeware games or applications installed on our systems. If you've played an online Java or Flash based game, you've used freeware. In a very real way the Internet itself is freeware, a massive collections of scripts, information, tools and resources that are, for the most part, totally free. But what is it that motivates so many people to put so much work into a project, and then release it totally free of charge? There are a few misconceptions about freeware that I would like to clear up.1.) "Freeware programs are loaded with spy ware and Trojan horses" ? not true. While it is...(related: Software)
The Death Of Windows
I have always regretted how Microsoft price gouges and rips off computer users. I really regret Windows XP activation. I have always intended to convert to Linux, but it isn't easy for a Windows user since version 3.0.Recently, I purchased the book "Moving to Linux" by Marcel Gagne. The interesting thing about the book is that it includes a bootable Linux CD-ROM. "Knoppix" is a specia...(related: Software)
New Sql Delta Version 3.1
COMMAND LINE FUNCTIONA 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 repo...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software