This blog was created to help architects and administrators of different enterprise solutions including document management, databases, ERP, CRM and Business Intelligence.

Friday, March 25, 2011

Integrating with Dynamics GP - Part II

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 middleware to do this. It was a mix of SSIS & Dexterity and since the host system was on Oracle we had to create Linked Servers.

The Bank Deposits is pretty straight forward as customer payments were received from the billing system, the entries are booked to GP as cash and a separate GL entries are created.

Another complexity in this project is the data migration of the subscription contracts in GP. We were using a 3rd-party product and we made customizations which slices the contracts on an annualized basis. All active contracts were migrated so billing can continue on the new system.

Lastly, reporting and Smartlist. Given that subledger reports will be coming out of the new system, the reconciliation process between GL & Subledger will change. Smartlist reports for subledgers goes away as well.

you're really a good webmaster. The site loading speed is amazing. It seems that you are doing any unique trick. Furthermore, The contents are masterwork. you have performed a wonderful task on this matter!

My developer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the costs.But he's tryiong none the less. I've been using WordPress on numerous websites for about a year and am concerned about switching to another platform. I have heard great things about blogengine.net. Is there a way I can import all my wordpress posts into it? Any kind of help would be greatly appreciated!

I'm impressed, I must say. Seldom do I encounter a blog that's both equally educative and amusing, and without a doubt, you've hit the nail on the head. The problem is something which not enough men and women are speaking intelligently about. I am very happy that I came across this during my hunt for something concerning this.