Custom Software Development
Free Resources
Custom Software
Database Development
Web Design
Web Services
Contact Us

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


MORE RESOURCES:

New York Times

Apple Updates iPhone Software: Maps, Podcasts Enhanced
Washington Post, United States - 4 hours ago
Apple unveiled early Friday a 2.2 software update for the iPhone, bringing new features such as Google Street View and over-the-air podcast downloads. ...
Lots to like about new iPhone 2.2 software update Ars Technica
Apple releases iPhone Software v2.2 Apple Insider
Apple Releases iPhone 2.2 Software Digitaltrends.com
PDAstreet - I4U
all 175 news articles


Elliott Terminates Tender Offer to Acquire Epicor Software Corporation
MarketWatch - 5 hours ago
... LP and Elliott International, LP (collectively, "Elliott" or "we"), a major shareholder of Epicor Software Corporation (the "Company" or "Epicor"), ...
Hedge Fund Elliott Associates Withdraws Offer for Epicor Software Orange County Business Journal
Epicor dn 19 pct after hedge fund ends hostile bid Forbes
UPDATE 1-Hedge Fund ends offer for Epicor Reuters
RTT News - Barron's Blogs
all 24 news articles


PAR Technology Corporation Releases Next Version of SpaSoft(R) Spa ...
MarketWatch - 5 hours ago
An industry-standard for more than 10 years, SpaSoft is a fully integrated, dynamic activities management/scheduling software solution, ...


Traction Software Introduces Live Blog Micro-Messaging and End-of ...
MarketWatch - 3 hours ago
Live Blogs become a standard feature -- not an extra cost option -- for Traction Software's secure, scalable enterprise class hypertext platform which now ...


Progress Software and QAD Propose A Formula for The Perfect Lean ...
MarketWatch - 5 hours ago
a provider of leading application infrastructure software to develop, deploy, integrate and manage business applications today announced that Progress ...


BBC News

Microsoft to offer free security software to attract beginners
eTaiwan News, Taiwan - 8 hours ago
19 to stop selling personal computer security software and to use free personal anti-virus software instead. The new software called Morro can support seven ...
Spamhaus: Microsoft Now 5th Most Spam Friendly ISP Washington Post
Microsoft: New software not Symantec, McAfee rival Reuters
Microsoft To Stop Paid PC Security Service, Offers Free Anti-Virus ... AHN
NetworkWorld.com - Wall Street Journal
all 305 news articles


Hann’s On Software bouht by Mediware
Bizjournals.com, NC - 1 hour ago
Mediware Information Systems Inc. has bought the assets of Hann’s On Software, a pharmacy-management software provider based in Santa Rosa, for $3.5 million ...
Mediware Acquisition Adds 320 Pharmacy Facilities MarketWatch
Mediware Information buys assets of Hann's On Software - Quick Facts RTT News
Mediware Acquisition Adds 320 Pharmacy Facilities International Business Times
all 19 news articles


Check Point Software Announces Participation in Fourth Quarter ...
MarketWatch - 4 hours ago
Check Point Software Technologies Ltd. ( www.checkpoint.com) is the leader in securing the Internet. Check Point offers total security solutions featuring a ...


DR Systems to Feature Software-Only, Enterprise Web-PACS for ...
MarketWatch - 5 hours ago
With the new zero-download application, clinicians no longer have to download the software before accessing reports and exams on their own computers. ...


Intrinsyc Signs Agreement with Leading OEM to License Destinator(R ...
FOXBusiness - 1 hour ago
Intrinsyc will leverage its technology and Solutions Engineering expertise to customize and integrate its Destinator software to provide a complete ...

Software - Google News

Article Index | home | site map
Powered by Custom Software Development - © 1995 - 2008 Nexus Software Systems