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.

11 comments:

Anonymous said...

Incredible! This blog looks exactly like my old one!
It's on a completely different topic but it has pretty much the same layout and design. Superb choice of colors!

Feel free to surf to my site - Professional accounting

Anonymous said...

Saved as a favorite, I love your website!

Also visit my blog - Architects johannesburg architectural services Johannesburg

Anonymous said...

I used to be able to find good info from your blog posts.


Also visit my webpage :: IT support Johannesburg

Anonymous said...

You should take part in a contest for one of the best websites on
the internet. I most certainly will recommend
this web site!

Also visit my webpage - Ppe johannesburg

Anonymous said...

Hello to every body, it's my first go to see of this weblog; this website contains remarkable and truly fine material for visitors.

Visit my homepage: family portraits Cape Town

Anonymous said...

After going over a number of the blog articles on your website, I truly appreciate your technique of blogging.
I book-marked it to my bookmark site list and will be checking back soon.

Take a look at my web site too and tell me what you think.


My blog post :: property development

Anonymous said...

After I originally commented I seem to have clicked on the -Notify me when new comments are added- checkbox and from now on every time a comment is added I recieve four emails with the same comment.

Is there an easy method you can remove me from that service?
Thank you!

Stop by my web page click this site

Anonymous said...

These are in fact fantastic ideas in regarding blogging. You have touched some fastidious points
here. Any way keep up wrinting.

Also visit my blog post; click the site

Anonymous said...

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!

Here is my blog post - more info

Anonymous said...

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!


Look into my web site - Click Here

Anonymous said...

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.

my blog post ... More information