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: 5 Most Crucial Accounting Software Features TechRepublic S.F. Muni software problem causes major downtown transit issues San Francisco Chronicle Severe Flaws Disclosed in Brocade SANnav SAN Management Software The Hacker News SRU benefits from $3.8 million petroleum engineering software donation Slippery Rock University Heads up Kia drivers! The automaker is installing free anti-theft software to impacted car owners WHAS11.com 'We're not learning anything': Kennedy High students frustrated with software that subs for a Spanish teacher Richmond Confidential IRS' hyped Direct File tax software off to a slow start Washington Times Kia hosts anti-theft software updates; drivers raise concerns over effectiveness of the fix First Alert 4 Axway Software: Disclosure of Transactions in Own Shares Business Wire Kia hoping theft prevention software install event will decease stolen vehicles in Louisville - WDRB Ticked off! @bad device software - Ticked off! @bad device software Orlando Sentinel $22.85 Bn AEC (Architecture, Engineering & Construction) Software Global Market Opportunities and Strategies to 2033 Yahoo Finance The Top 3 Software Stocks to Buy in April 2024 InvestorPlace Exclusive | IBM Nears Deal for Cloud-Software Provider The Wall Street Journal Railroad Engineer Sues Union Pacific Over Train Driver Software SupplyChainBrain Kia hosts anti-theft software updates; drivers raise concerns over effectiveness of the fix First Alert 4 MRO Provider Plans Software Launch, Expansion Projects Aviation Week Benign Growth For Upland Software, Inc. (NASDAQ:UPLD) Underpins Stock's 29% Plummet - Simply Wall St NHTSA Opens Recall Query Into Tesla Autopilot Safety Concerns Following Software Update autoevolution Open-Source Software Security Security Boulevard ChargePoint launches expanded fleet software solution | electrive.com www.electrive.com Stream Analyze brings edge AI software to U.S. IoT market FierceElectronics Virtual Meeting Software Market Poised for Global Growth with Forecasted 27.6% CAGR until 2027 EIN News Lawsuits filed over software company may drive up rent prices KOAT New Mexico MS-DOS 4.0 From 1988 Is Now Open-Source Software How-To Geek Scopio Labs gains De Novo clearance for AI bone marrow analysis software and more FDA clearances Mobihealth News EU and UNDP transfer unified electronic case management system software to Ukraine euneighbourseast.eu Autodesk, Nemetschek Agree on Greater Interoperability for Design and Construction Software Engineering News-Record NASA's Voyager 1 Resumes Sending Engineering Updates to Earth NASA Jet Propulsion Laboratory UK software sales for the week ending March 20, 2024 Nintendo Everything AMD Radeon Software Adrenalin 24.4.1 VideoCardz.com Check Point Software Reports 2024 First Quarter Financial Results Check Point Software - Computer vision equips surveillance software with 'privacy protection' Design Products & Applications Swiss Re completes milestone in safety performance assessment of Luminar's LiDAR & software driving system Reinsurance News Solutions Group Services Launches Two New EMS Revenue Recovery Software Programs JEMS (Journal of Emergency Medical Services) JetBrains Celebrates Software Developers iProgrammer Sales Gamification Software Market to Surpass USD 71.2 billion by 2030 Fueled by Growing Adoption of Remote ... StreetInsider.com Amsterdam's Rodeo Software declared bankrupt, after fraud allegations rocked the company Silicon Canals Best video editing software in 2024 Tom's Guide USENIX Security ’23 – Union Under Duress: Understanding Hazards of Duplicate Resource Mismediation ... Security Boulevard Nvidia to buy AI orchestration software provider Run:ai Network World Tesla slashes price for Full Self-Driving software Fox Business Preventing Ransomware Attacks at Scale HBR.org Daily Dutch GRC software firm CERRIX raises funds from Fortino Capital for European expansion Silicon Canals Oracle to leave Austin, move headquarters to Nashville Houston Chronicle |
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 |