ERP, SQL Server, Sharepoint, Report Designers and Business Intelligence

Cloud Computing Practice Overview

2011-12-02T12:00:00.000-05:00

Bessemer Venture has been an advocate of Software-as-a-Service (SaaS) for years now. They've compiled a one-pager of all potential providers of cloud services in different areas of the business. Get the one-pager here.

Apple's iPhone forcing smartphone industry change by Computerworld

2011-07-30T23:54:00.000-04:00

The intensely competitive smartphone industry is becoming an increasingly challenging space. Analysts say Apple [AAPL] has achieved the largest share of hardware sales and revenue, putting competitors on any current platform (Android, Microsoft, RIM, etc.) under lots of pressure. In this environment, surely it won't be long until another round of mergers and acquisitions begins? [ABOVE: Thanks

Cloud war already started?

2011-06-27T20:38:00.000-04:00

For months, I've been waiting for somebody to write an article about cloud-based services which features bigwigs like Micrsoft, EMC, Apple and some unknown players in the market. The day finally came but I was more disappointed than excited about the article as it failed to recognized other David's in the market. Also, what do you consider players in this market and how do you classify them in

The Dynamics Decade

2011-06-01T17:37:00.001-04:00

I liked this article because it shows you the history of the company I've grown to follow and the individuals who have contributed to its success over the years. Here's an excerpt from the article: Microsoft originally created a Microsoft Great Plains Business Solutions brand headed by Great Plains Chairman and CEO Doug Burgum, who became a Microsoft senior vice president and president of

The New York City SharePoint Developers User Group Monthly Meetup

2011-03-25T13:01:00.000-04:00

Wednesday, April 20, 20115:30 PM Microsoft Office NYC - 6th Floor 1290 Avenue of the Americas New York, NY

Required apps for Cloud computing

2011-03-25T12:37:00.001-04:00

You've done your research and know the differences in business model between the 3 areas of cloud computing: SaaS (software-as-a-service). WAN-enabled application services PaaS (platform-as-a-service). Foundational elements to develop new applications IaaS (infrastructure-as-a-service). Providing computational and storage infrastructure in a centralized, location-transparent service So you

Integrating with Dynamics GP - Part II

2011-03-25T11:01:00.001-04:00

One of the more complex integration in this project were the customer payments integration and Revenue. The entry point of the integrated data in GP will be in two (2) windows: General Ledger and Bank Deposits. The General Ledger integration were the entries originally created from the Revenue & Expense Deferral (RED) module. Now that the subledger is non-resident to GP, we have to create the

NYC Sharepoint Developers User Group Meetup

2010-10-01T17:43:00.002-04:00

The NYC Sharepoint Developers User Group will meet again on Oct. 20 at the Microsoft office in the Avenue of Americas, NY. The topic for October is "Word Automation Services in Sharepoint 2010" by Kenneth Cooper. Join us by visiting the website here.

IntraLinks Holdings Inc. is now public

2010-09-29T10:54:00.003-04:00

IntraLinks is now a public company (NYSE: IL). Our company is a cloud services provider of online secure exchanges for different industries including Financial services, Life Sciences, Alternative Investments, Real Estate, Legal, Manufacturing and others. To check our stock in NYSE, here's the link: http://www.nyse.com/about/listed/il_news.html Here's a clip of our CEO in Bloomberg: http://

Integrating with Dynamics GP

2010-07-15T15:35:00.004-04:00

I've been through a lot of GP integrations and most of them were very straight forward. In my current environment we have integrations from different sources including Salesforce to SOP module, IT Asset management to Fixed Assets module(including bar-code implementation), ADP to GL, and others. The current work will be considered the most challenging as we're moving the AR subledger to a new

Jack Dorsey on Twitter and Square

2010-07-12T11:37:00.001-04:00

I was watching Beyond the Boardroom this weekend with their guest Twitter Founder Jack Dorsey. Jack introduces his new product - Square, a revolutionary mobile credit card reader that plugs into the audio port of compatible smart phones and laptops. Also in this episode, Jack discussed the importance of Twitter in business including applications built around Twitter. Here's an excerpt from the

Watch the World Cup

2010-05-12T09:42:00.002-04:00

Here's a good website to find a popular venue based on your team for the World Cup. The website also shows the schedule of the preliminary games. Click here to go to the website.

Convergence 2010 - Exciting Atlanta

2010-05-04T13:45:00.000-04:00

I always give my feedback a week after the conference but I take notes during all the action is happening so I don't forget the important stuff later. Here's some notes that I've kept and wanted to share with everyone: - I was surprise on the number of Dynamics GP attendees this year. After the keynote session more than half stayed for the next session which was on the next version - Dynamics

Sharepoint 2010 and SQL database mirroring

2010-05-01T23:47:00.002-04:00

http://blogs.technet.com/b/wbaer/archive/2010/05/03/database-mirroring-in-sharepoint-2010.aspxHere's my first article on Sharepoint 2010, it's about creating a SQL database mirroring for the environment. Click here to read the article.

InfoView for Crystal Reports

2010-02-24T23:32:00.001-05:00

Finally started working on publishing all my Crystal Reports to InfoView, a web application from Business Objects Enterprise (BOE). Infoview runs on the web browser and is utilized to run and schedule Crystal Reports or any other report.

Business Intelligence experiences

2010-01-28T16:36:00.002-05:00

During my 17-plus years of being a business owner or employee, I've had the opportunity to implement, feed, test or used a Business Intelligence (BI) product including Cognos, Microsoft's PerformancePoint Server Planning(discontinued) and now Business Objects. I like the look and feel of this product but wonder what will change in 2010 since SAP took over. Nowadays, database vendors provide

Windows 7 is now the fastest selling OS

2010-01-07T23:31:00.004-05:00

Last night at the CES 2010 keynote, Microsoft CEO Steve Ballmer announced that Windows 7 has become the fastest selling operating system in history....read it here Amazon.com Widgets

Information Rights Management (IRM)

2009-11-12T09:35:00.006-05:00

Here's an interesting article from Fahim Siddiqui, EVP of Intralinks, Inc. His article can help organizations in understanding the complexity of applying encryption and permissioning to corporate information. Read article here

Revenue and Expense Deferral

2009-11-10T16:55:00.007-05:00

What is Revenue and Expense Deferral (RED)? Revenue Deferral is considered a liability until it becomes relevant to the business at hand, such as a payment received for work that has not yet been performed. opposite of deferred charge. Expense Deferral refers to an item that will initially be recorded as an asset but is expected to become an expense over time and/or through the normal operation

Get Customers with more than one address

2009-10-10T11:46:00.001-04:00

Here's a simple SQL statement that I've used to help me resolve some of our issues be it customer, vendor or item master files: Select custnmbr, Count(ADRSCODE) As AddressCount From RM00102 Group By custnmbr Having Count(ADRSCODE) > 1 or if you want detail use this Select * From RM00102 Inner Join ( Select CUSTNMBR, Count(ADRSCODE) As AddressCount From RM00102 Group By CUSTNMBR Having

SQL script to show last invoice detail of every customer

2009-09-15T14:29:00.003-04:00

Copy and paste this to SQL Server Enterprise Manager: select distinct a.custnmbr,a.LSTTRXDT,a.lsttrxam,b.sopnumbe from rm00103 a join sop30200 b on a.custnmbr = b.custnmbr and a.LSTTRXDT = b.docdate /* show in ascending order */ order by custnmbr asc

Planning SQL Upgrade

2009-04-24T13:46:00.003-04:00

So you finally decided to upgrade to SQL Server 2008 but it's been awhile since you looked at options for your Raid configurations. Here's a summary of what your options are: Raid 0 - data is spread in different disk (disk stripping) but lacks redundancy PROS - performs well on read and write CONS - Failure of disk means data is lost Raid 1 - known as disk mirroring no disk stripping.

SQL Wildcards

2009-04-20T15:53:00.003-04:00

We implemented Multicurrency module and part of this implementation is changing the naming convention of our customers in Great Plains. We want to easily identify what kind of customer are they. Currently, our customer id ends in 001 so we decided to change it to whatever the contract currency is. So let's say ABC has a EURO contract with us then their customer id will then be ABCEUR instead of

Proud Uncle

2009-03-26T18:05:00.003-04:00

I'm so proud of my niece, Guia del Prado, that I wanted to congratulate her in my blog for being featured in her schools website - University of Nevada, Reno : www.unr.edu .She's currently the news editor for the campus magazine - Insight.

Convergence 2009 update

2009-03-25T10:39:00.005-04:00

Just came back from Convergence 2009 - New Orleans and found this year quite a disappointment as I didn't see a lot of value to the seminars, GP ver 11 and the future of products around Dynamics GP. Here are my updates this year: 1) GP ver 11 - The presenter in the kiosk didn't show a lot of functionality as she said they're still finalizing the list but I like the option of printing a form to