| |
| |
|
|
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:
Software - Google News |
|
|
|
RELATED ARTICLES
Microsoft Great Plains Payroll Module Customization Scenarios It is now common thing when large corporation selects mid-market ERP or so-called standard functionality MRP solution as its corporate accounting system. Microsoft Business Solutions Great Plains is very good candidate. Fleet Maintenance Software Reviews Innovative Maintenance Systems (IMS) is one company that offers solutions for companies in need of fleet maintenance software. One of their most popular products is Fleet Maintenance Pro®. Reduce TCO: The Java Database Way TCO (Total Cost Ownership) is the buzzword in today's business world. This metric helps enterprise managers assess direct and indirect costs and benefits derived from their investment on IT components and services. Ukraine: a Prospective Player on the World Software Outsourcing Market The destruction of the Soviet Union about 15 years ago, made a huge country with a great level of IT science divided into small bricks. Nowadays, despite Russia's expansion into the world software development market, Ukraine keeps playing an important role here too. Screenplay and Script Writing Software When it comes to screenplay software each screenwriter needs to determine what they need from the program they purchase and pick one that fits their specific needs. Screenwriting software doesn't write the screenplay for you. Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution - Microsoft CRM. Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision. Imagine if Everyone Working In Your Office Was In Synch? Microsoft-Outlook is a pretty amazing program. So much more than simply an e-mail client, it provides a task list, a powerful calendar with recurring scheduling capabilities, wonderful electronic sticky notes, mail-merge capability with MS-Word support and so much more. Microsoft Business Solutions Partner - How to Launch New IT Consulting Practice In the new era of internet marketing the problem of severe competition comes into the first position. If you look back into 1990-th you will find high tech companies using traditional sales techniques: purchasing local and regional businesses contact lists, making cold calls and then trying hard sales closing techniques, such as "selling to the top" - IBM style, selling to VITO (very important top officer), etc. 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. Huddle Up; Groupware on Three It could just be me, but my experiences with document collaboration remind me of a football game. It sounds crazy, I know, but working with a group and sending emails off to other members of the group caries with it that familiar uneasy sensation of Thanksgiving Day football games, where I often play quarterback and just as often wonder whether members of my family will catch the pass, and if they do, what they will do with the ball. Explore the Internet in a Whole New Way For a long time now Microsoft's Internet Explorer has ruled as 'King of Internet browsers'. Like many of Microsoft's products an initially brutal marketing campaign pushed Internet Explorer into the mainstream's consciousness and from then on it was the logical, default choice. Hear It in Digits Music downloads are off the charts! We're listening to digital music in the digital era.The driving force behind the phenonmena is the technonolgy called MP3. Quick Summary of Basic and Common Linux Commands There are many commands that are used in linux on a daily basis, ones that everyone should know just to get by. Like back in the days of DOS, you had to know how to work with the command line and how to navigate around. Fundraising Software - How Can That Help Me? Fundraising software lets you connect with donors in a way that is unlike any communication you've ever had before. You can diversify your fund raising efforts with software and manage all of your day-to-day activities. Photoshop Files and Formats People often ask me: What image file formats will Photoshop open or save in? What are the advantages/disadvantages?Photoshop has the capability to open and save many different graphic files. Here are some of the most popular ones. ERP Consulting: Microsoft Great Plains Partner Future Directions In the Clinton era the status quo was simple: you serve your local clients and if you want to expand your business - open offices in other business metros. Great Plains Software was granting generous margins on the software sales and stimulated local leading VARs/Partners/Resellers with so-called orphan leads - customers who lapsed in payment annual enhancement program or called Great Plains Software directly to comply about quality of service by their VAR. How To Identify, Cure and Prevent Spyware/Adware Infections Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use. How to Choose the BEST Charting Software I suggest that you do not spend a lot of money on charting software as most perform very similar functions. Often the price is inflated to capitalize on the mentality that expensive is better. ERP Implementation: Success Factors As seeing large number of implementations - in our case these are Microsoft Business Solutions Products: Great Plains, MS CRM, Navision - we would like to give you our opinion on what should you consider to do to secure implementation success. These principles should work as for large corporation as well as for midsize and even small business. IBM Lotus Domino or Microsoft Exchange? IBM Lotus Domino or Microsoft Exchange?The severe competition continues for many years between two main leaders in collaboration solutions - IBM and Microsoft. Whether the choice of a platform influences the ordinary user? The both of software giants put efforts to improve working conveniences for end Internet users.
|
| home | site map |
| © 2006 |
