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,
COST AMNT,
SLSAMNT,
MISCAMNT,
FRTAMNT,
TAXAMNT,
DOCAMNT,
CASHAMNT,
CBKIDCSH,
CASHDATE,
DCNUMCSH,
CHEKAMNT,
CBKIDCHK,
CBKIDCRD,
CHEKNMBR,
CHEKDATE,
DCNUMCHK,
CRCRDAMT,
DCNUMCRD,
CRCRDNAM,
RCTN CCRD,
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 (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. help@albaspectrum.com
Microsoft CRM is relatively new player on the now becoming... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
I've been active in the Cisco Certification track for four... Read More
Words we choose to describe things and phenomena often show... Read More
If you have been using the Internet for any amount... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
We live in a post-industrial age where information is the... Read More
Remember old good days when your company probably had Great... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
Beginning with Domino version R4 it has integration with the... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
Let's first look at your ERP system selection (without Retail... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
The adware and spyware definitions list is very long. But... Read More
An integral part of any quality CRM system is lead... Read More
Fleet Maintenance Management is a critical position in any company... Read More
In a previous article, I wrote about OpenOffice... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
This short paper will expand on two key reasons to... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Now there are Three Steps To Heaven Just listen and... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
We'll give you non formal view, based on our consulting... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
This article will not attempt to advocate the use of... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
If you company is small or mid-size special products or... Read More
Sales are all about leverage, because there is only so... Read More
If your company has regional and worldwide operations, you might... Read More
Do you want to get quality software at a reasonable... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Introduction: The creating of a computer program involves a number... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Software |