Home
>
Software
>
Microsoft Great Plains Integrations ? Retail Management Sample

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,

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

one time home cleaning Morton Grove ..

In The News:

The Berkeley Humanoid Light (BHL) is a lightweight, open source humanoid robot that anyone can build using 3D-printed parts and off-the-shelf components.

Meta’s new AI chatbot is getting personal, and it might be sharing more than you realize.

A new threat targets both Android and iPhone users: SparkKitty, a powerful mobile malware strain that scans private photos to steal cryptocurrency recovery phrases and other sensitive data.

Thanks to a team at the University of California, Davis, there's a new brain-computer interface (BCI) system that's opening up real-time, natural conversation for people who can't speak.

Privacy risks are hiding in plain sight, as your personal data is likely being collected, tracked, and sold without your knowledge.

VenHub, a fully autonomous, AI-powered smart store just opened at the LAX/Metro Transit Center in Los Angeles.

A woman's Facebook account takeover reveals dangerous social engineering tactics and provides lessons on recovery, avoiding scams and enacting stronger security measures.

Shanghai engineers are using 432 walking robots to relocate a complex, preserving Shikumen architecture while creating space for a modern underground hub and cultural center.

Major healthcare data analytics firm Episource had a cybersecurity incident exposing 5 million patients' medical records and personal information in recent breach.

A new sophisticated PayPal scam sends legitimate-looking emails from official PayPal addresses, using phone numbers instead of links to convince victims to download remote access tools.

Fox News' AI Newsletter brings you the latest on this rapidly evolving technology.

The innovative Kara Pod device extracts moisture from air to create mineral-rich water and brew coffee, featuring UV sterilization and compatibility with Nespresso pods.

Gov. Hochul unveiled New York's nuclear power plant project to power a million homes, which faces permit challenges while promising jobs and a cleaner energy future.

SAFE introduces Aerie, an underground luxury bunker combining high-end living with advanced security, wellness amenities and interactive walls simulating panoramic views.

A Facebook scammer posing as Elon Musk tricked a victim with promises of a Tesla and $250,000, requesting gift cards that become untraceable once the codes are shared.

Experience hands-free golfing with the Robera Neo smart caddie that uses AI to follow you, navigate obstacles and carry your clubs with GPS course mapping.

Cybersecurity alert: 16 billion passwords exposed in massive credential database affecting major platforms. Protect your accounts with password managers

The innovative BeBot robot uses electric power to remove pollution from shorelines, covering 20-30 times more area than manual collection while preserving wildlife.

A new ClickFix campaign targets macOS users with fake Spectrum support sites, tricking victims with CAPTCHA failures to paste commands that install information-stealing malware.

AI-powered autonomous trucks from Plus Automation are being tested across the U.S., Europe and Asia to solve logistics challenges while facing regulatory hurdles and labor concerns.

Your health information might feel private and secure with your doctor, but the reality is far more complicated. Data brokers collect a wide range of sensitive health data, from diagnoses and prescription details to personal identifiers, and sell this data to marketers, insurers, and other third parties.

Kepler Robotics has officially introduced its Forerunner K2 "Bumblebee" humanoid robot at the SAIC-GM automotive plant in Shanghai, marking a significant moment in the real-world deployment of advanced robotics.

Scammers never seem to be running out of new ways to try and get their hands on your money – and lately, they've been getting sophisticated.

Thirty people were injured and killed, though the exact number remains currently unknown, when a suicide bomber blew himself up in a Damascus church.

Unexpected password reset alerts signal potential hacking attempts or phishing scams. Learn how to respond and establish stronger security measures for your accounts.

Microsoft Great Plains Integrations ? Retail Management Sample

Software