Software Information |
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
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Falling in Love With More Than One Screensaver: The Fun Part Having from five to ten and more favorite screensavers is cool. But how do you enjoy them all in a straightforward and convenient way? Draw the power you need from the little yet useful tools discussed in this article!As you remember, earlier in my article What to Do if You Fall in Love With More Than One Screensaver we discussed the standard way of switching between multiple screensavers. Helping Newbies Understand Professional Software The Windows registry is a huge database that ensures normal computer operation. Installing and uninstalling software can make your registry a mess, leading to decreased PC performance and causing computer crashes. Microsoft Great Plains PM: Payables Management Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Payables Management (PM) module improves control over your payables. Microsoft Great Plains GL: General Ledger - Overview For Consultant Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features. Rapid Application Development - Is it Really a Need of Today? Rapid Application Development (RAD) is a software development methodology. In this competitive world, software product delivery time should be as little as it can be. OS 101: Suggestions for Choosing an Operating System An operating system (abbreviated OS) is essentially the path through which a computer accesses files, games, the Internet, and all vital stored information. The OS is the most important program on a computer because it runs all of the other programs. Free Software: How Not To Get More Than You Bargained For! I completed an experiment recently. I wanted to find out exactly what software I could get free on the Internet. Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP Enabling Chinese input is quick and easy, there are only a few steps you need go through to install the Chinese Language support and input method before you can type Chinese in your word processor or other program.We have broken the steps to 3 different sections for your easier to read and follow. Your Computer May Be Infected, Heres How To Check (NOT about virus) NOTE: Please take time to read on - it may be vital for your PC's security. If you are not in the mood, just save it or print it out for later reference. Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager? Many reasons made GBM a unanimous choice for experts, one of them is the fact that with the set of features it offers, it's definitely the easiest to use."Genie Backup Manager Professional has a clear, simple interface which lets you manage the application without problems and in just a few minutes," the UK's Personal Computer World (PCW) stated in its Feb 2005 review of GBM, in which it selected the application for its Highly Recommended award. The Top 5 Wrong Reasons For Not Hiring Testers Considering whether or not your software company should hire a dedicated team of testers? Here are the Top 5 Wrong Reasons why you shouldn't.We Have a Beta ProgramSome people feel that the best way to debug a system is to ship it to your customers and wait for trouble tickets. netstat - Linux Command to Display Networking Information In linux, one of great commands for finding out information about your network connections is "netstat". It provides you interface information, statistics, connections, and a lot of other really great information about your computer. Microsoft Great Plains Implementation - Overview for IT Director/Controller What is installation in the language of technology? Installation has server and client sides. Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. Intro to UNIX Shells A UNIX Shell is in simplest terms, a command line interpreter, that takes the users input and gives it to the Kernel. If you are familiar with DOS, you will remember the 'command. How the Firefox: How to... Manual Helped Me A few months back I really got sick of my computer always being slow and having system errors. So I started doing a bit of research and heard of a new browser called "Firefox". What is a Document Manager without Version History? Document Manager and Version HistoryIn previous articles I have discussed the usefulness of a document manager, such as groupware, in organizing document sharing. I have also discussed the role that a Version History plays in a good document manager. Alien Intruders! You probably didn't casually invite, or extend a formal attendance requestto, these undesirables known as viruses.Regardless of your opinions, such cyber-nomads may call on you, complete andactive, with their destructive payloads. Lotus Domino Implementation and Development: Infrastructure - Present and Future Domino server is a buffer between the operation system and the application. On the other hand Domino server - consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Corporate ERP Selection: Microsoft Great Plains In our opinion, traditional approach when you select ERP/MRP system for large or mid-size company by functionality, database and hardware platform should be revised. We are convinced that new generation of Windows servers plus the reliability of relatively inexpensive database platform, such as Microsoft SQL Server, enable large corporation to decrease the cost of hardware, database and ERM software, plus have good internal support by hiring Microsoft certified professionals, available on the market in your area. Groupware: Avoid the Ad Hoc Shuffle GroupwareEfforts are continually made to manage the unavoidable ad hoc business process, but ad hoc processes do not necessarily mean a pile of messy, shuffled documents, at least not anymore. Groupware is software which tracks and manages the ad hoc business collaboration. |
home | site map | contact us |