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.