ERP, Databases, Sharepoint, Report Designers and Business Intelligence

Dynamics GP 2013

2012-09-24T11:32:00.000-04:00

This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here. Most of the improvements were geared to improving security, integration with other Microsoft products and the Web client. I was reading the installation guide of the web client and the requirements were pretty basic including the Web server OS which can either be Windows Server 2008 R2 or 2012

ETL tools

2012-07-30T21:33:00.002-04:00

Following are top ETL tools used for extracting, cleaning, transforming and loading data to a data warehouse: Oracle Warehouse Builder (OWB) SAP Business Objects Data Integrator (BODI) IBM Data Stage Microsoft SQL Server Integration Services (SSIS) SAS Data Integration Studio Talend Open Studio Clover ETL Adeptia Integration Suite

Former Citi VP of Treasury Sentenced

2012-07-06T19:05:00.001-04:00

In this age of compliance and tight security, how can one still manage to embezzlement more than $22 million? Well Mr. Gary Foster did, the former vice president at Citigroup Inc.’s treasury finance department was sentenced to 97 months in prison for fraud related to his embezzlement. Foster embezzled funds from various Citigroup accounts by transferring money to Citigroup's cash account and

LinkedIn error

2012-04-10T11:02:00.000-04:00

LinkedIn is acting up today as I'm getting this error a lot - Sorry, there was a problem processing your request. Please try again. Even on simple links, it doesn't work.

10 things you should know about NoSQL databases

2012-02-22T19:01:00.005-05:00

Did you hear about the latest trend in databases? If not then you should read this article about NoSQL or "not only SQL". NoSQL vary from your classic relational database management system (RDBMS) as they do not use SQL as their primary query language. These data stores may not require fixed table schemas, usually do not support join operations, may not give full ACID (atomicity, consistency,

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