Microsoft Great Plains Integrations ? Retail Management Sample
|
Microsoft Business Solutions is emerging as very attractive vendor for mid-size companies. The strength of its products is in their cross integration potential. This integration strategy will be the software development direction for this Microsoft subdivision. Meanwhile, as of right now ? we have to recommend just to stake on it and deal with custom or in-house developed integration.
If you are developer who needs some sample code to start with ? we are placing Accounts Receivable level integration code ? it pulls info from Microsoft RMS and places it into work tables in Great Plains.
Be aware, that Microsoft Great Plains version 7.5 has out of the box integration with Microsoft RMS 1.2, but it is on GL and POP level only. You can't do check book reconciliation, for example. Currently Microsoft is in decision on who will be coding the integration for Great Plains 8.0 and what the functionality should be. More likely ? it will be Nodus Technologies with the integration on SOP and GL level ? it will deploy Great Plains Dexterity and MS SQL Server stored procs.
And here is the code, you have to deal with RM10301 and distribution RM, also we recommend insert new customers into RM00101 and RM00102:
-- Sales Transaction Record
insert into RM10301
(
DOCTYPE,
RMDTYPAL,
RMDNUMWK,
DOCNUMBR,
DOCDESCR,
DOCDATE,
BACHNUMB,
BCHSOURC,
CUSTNMBR,
CUSTNAME,
ADRSCODE,
COSTAMNT,
SLSAMNT,
MISCAMNT,
FRTAMNT,
TAXAMNT,
DOCAMNT,
CASHAMNT,
CBKIDCSH,
CASHDATE,
DCNUMCSH,
CHEKAMNT,
CBKIDCHK,
CBKIDCRD,
CHEKNMBR,
CHEKDATE,
DCNUMCHK,
CRCRDAMT,
DCNUMCRD,
CRCRDNAM,
RCTNCCRD,
CRCARDDT,
TRDISAMT,
ACCTAMNT,
DISCDATE,
DUEDATE,
LSTEDTDT,
LSTUSRED,
GLPOSTDT,
PSTGSTUS,
CURNCYID,
TXENGCLD
)
select
DOCTYPE = (case
when a.Total > 0 then 1
else 7
end),
RMDTYPAL = (case
when a.Total > 0 then 1
else 8
end),
RMDNUMWK = 'SMS' + replicate('0',
13 - datalength(convert(varchar(13), a.TransactionNumber))) +
convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID),
DOCNUMBR = 'SMS' + replicate('0',
13 - datalength(convert(varchar(13), a.TransactionNumber))) +
convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID),
DOCDESCR = left(a.ReferenceNumber, 29),
DOCDATE = convert(varchar(10), a.[Time], 101),
BACHNUMB = 'SMS'
+ replicate('0',
2 - datalength(convert(varchar(2), a.StoreID))) +
convert(varchar(2), a.StoreID)
+ replicate('0',
9 - datalength(convert(varchar(11), a.BatchNumber))) +
convert(varchar(11), a.BatchNumber),
BCHSOURC = 'RM_Sales',
CUSTNMBR='CASH',
CUSTNAME = 'CASH',
ADRSCODE = 'PRIMARY',
COSTAMNT = (case
when isnull((select round(sum(round(Cost * Quantity,2)),2)
from LINKEDSERVER.HQ.dbo.TransactionEntry
where TransactionNumber = a.TransactionNumber and
StoreID = a.StoreID),0) > 0 and a.Total > 0 then
abs(isnull((select round(sum(round(Cost * Quantity,2)),2)
from LINKEDSERVER.HQ.dbo.TransactionEntry
where TransactionNumber = a.TransactionNumber and
StoreID = a.StoreID),0))
when isnull((select round(sum(round(Cost * Quantity,2)),2)
from LINKEDSERVER.HQ.dbo.TransactionEntry
where TransactionNumber = a.TransactionNumber and
StoreID = a.StoreID),0) 0 and
a.StoreID = '1' and
not exists (select 1 from RM10301 c
where c.RMDNUMWK = 'SMS' + replicate('0',
13 - datalength(convert(varchar(13), a.TransactionNumber))) +
convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID) and
c.RMDTYPAL = (case
when a.Total > 0 then 1
else 8
end)) and
not exists (select 1 from RM00401 c
where c.DOCNUMBR = 'SMS' + replicate('0',
13 - datalength(convert(varchar(13), a.TransactionNumber))) +
convert(varchar(13), a.TransactionNumber) + convert(varchar(10), a.StoreID) and
c.RMDTYPAL = (case
when a.Total > 0 then 1
else 8
end))
and a.[Time] > '01/01/2004'
Happy integrating! if you want us to do the job or use our product - give us a call 1-866-528-0577! help@albaspectrum.com
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Arizona, California, Colorado, Texas, Georgia, New York, Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. akarasev@albaspectrum.com
|
|
|
Microsoft Great Plains Ecommerce: Overview For Developer
Microsoft Business Solutions Great Plains was designed back in the earlier 1990th as first graphical ERP/accounting system for mid-size businesses. The architects of Great Plains Dexterity ? this is the internal mid-shell, all Great Plains was written on, designed it to be easily transferable between graphical operating systems (MAC, Windows, Solaris ? potentially) and database platforms ? initially Great Plains was available on Ctree (both Mac and PC) and Btrieve, a bit later high end version Dynamics C/S+ was available on Microsoft SQL Server 6.5. But the idea was to catch or switch winning/losing database platform ? nobody could predict if MS SQL Server, Oracle or DB 2 become a dominant DB platform, like Windows among OS. All these trade-ins for being potential...(related: Software)
It?s Back!! Wordperfect?s Amazing Comeback
Have you noticed WordPerfect is gearing up for a comeback in a big way? And fortunately, they are succeeding. If you're like me, an ole' diehard WordPerfect 5 user, this is music to my ears. I love Microsoft Word, but I long for some of the features WordPerfect had to offer.Among the great advancements WordPerfect has made are their OfficeReady products. These are customized template packages that allow you to pull up ready-made templates and customize them for your business. You can then easily prepare your documents, spreadsheets and presentations. PowerPoint presentations have never been easier, and if you want to design a newsletter for your business, this is the way to do it. I recommend that you chec...(related: Software)
An Introduction To .net Framework
.Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe. These web-applications adopt open s...(related: Software)
Ssh (scp) Send Files From Windows To Your Linux Box
Not all of us have the luxury of working both at home and at work on a UNIX based system. However that doesn't mean you can't transfer files safely and securely between the two systems.Due to a firewall, I'm unable to use FTP on a non-standard port, from my work, however I am able to use SSH to connect to my home computer.There are many different clients for Windows based systems for SSH connections, however I am fond of PuTTy myself. This document will give you a very brief overview of how to send files from your Windows PC, from a command prompt, to your UNIX style server.Once you have installed the PuTTy Client (full package not just the putty.exe), open a command prompt on your Windows PC (start menu > run > cmd).You.re putty client may not be in ...(related: Software)
Microsoft Ecommerce Web-development: Great Plains Econnect .net ? Highlights For Programmer
In our small article we'll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend. Plus we'll cover what is possible and impossible in eConnect and why.Microsoft Great Plains is one of the most popular ERP in the US, Canada, Australia, New Zealand, Middle East, Latin America, UK and South Africa. Due to the MBS strategy ? Great Plains Dynamics was pulled from other markets, such as continental Europe (Germany, France, Russia) ? where Navision and Axapta are the promoted and recommended solutio...(related: Software)
Should I Use Windows Update?
Should one use Windows Update?This topic has good and valid arguments on both sides. Some would say keeping your windows up to date is essential in keeping it free of the newest, worst viruses and the like. Others would say that updating your windows is overemphasized, unneeded and a waste of time.In the future, Microsoft will have ways of detecting whether your version of windows is actually store-bought, or pirated. With so many copies of pirated windows on the market, such a move by Microsoft is almost required in order to continue cornering the OS market. For instance, when SP 1 (and 2) came out, you had to have an authentic windows serial code in order to download the update. There are of course ways of ...(related: Software)
Brief Notes About Mainframe Software Pricing
We don't think about mainframe software pricing anymore, we just go out buy a server hardware/software "package" from...(related: Software)
Benefits Of Shareware
Shareware has been fighting the stigma of being misunderstood for decades. While corporate software giants can no longer ignore the marketing potential of a trial version, small software startups are struggling with new listings and bandwidth costs. Businesses and individual consumers need to take a closer look at the benefits of taking advantage of shareware marketing. The concept of a trial version is not a new one. Consumer expectations, and the need for immediate satisfaction have spurned the industry to realize the need for instant software. The availability of file downloads in the Internet era, is spurning a revolution of purchasers who never leaving their homes or offices. As a result, the Internet has taken the proliferation of shareware to a new level.Why the Success?Why developers have succeeded using shareware market...(related: Software)
25 Things Mapping Software Can Do For You
1. With mapping software you can create a report that tracks your retirement plan for you.2. Use mapping software to create an Executive Dashboard, which tracks the bottom line.3. Use mapping software to find the snowfall reports for your favorite ski resorts in Idaho.4. You can even use mapping software to explore an interactive map of India for school reports, business, or travel.5. Track your store incoming and outgoing inventory, including shipping information and warehouse location, mapping software.6. You can conveniently book your own airline seat, so you don't need to worry if you are a "window person" as opposed to an "aisle person."7. Know the who, what, when, where, and how of your department by using m...(related: Software)
Can Group Collaboration Software Meet Business Needs?
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric Collaboration," 51 percent of businesspeople utilizing technology such as Mic...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software