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
Chicago limo Skokie ..Anti-virus software is used to find, remove or fix files... Read More
The Windows Indexing Service provides you with the ability to... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
As we could imagine, if you are reading this article... Read More
At the end of XX century, in the late 1990th... Read More
Bill of Lading is required report for Logistics and Freight... Read More
There are plenty of articles out there about how to... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
If you have been running Windows XP for a couple... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Fortunately one of the most common reasons cited for the... Read More
It's no secret that software companies operate in a very... Read More
The adware and spyware definitions list is very long. But... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Our hosted solution allow you to run your own search... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
How to delete the user? This is the first problem... Read More
When you first think about multicurrency ? you probably have... Read More
C++ Function templates are those functions which can handle different... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
limo O'Hare Bonfield ..It could just be me, but my experiences with document... Read More
Program Flow is what you think it is. How the... Read More
We live in a post-industrial age where information is the... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
IntroductionPHP can be used for a lot of different things,... Read More
An integral part of any quality CRM system is lead... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
Scrapbooks are very popular these days. I think that almost... Read More
How do you run a program on a remote server... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
I have recently created my first Php program. I wanted... Read More
Is your PC is slow and wimpy? Then you need... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
The objective for Zandi Digital is to make available clever... Read More
All of us know that Microsoft bought former Great Plains... Read More
This is the tutorial where we really get into programming.... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
With any good luck and a good amount of hard... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Software |