I'm in IT and trying to come up with a solution to a challenge.
We converted to cloud v11 from on prem v10.
I'm finding the GL staff have to continually go back to on prem system to look at detail around GL Transactions prior to our conversion date in August 2019.
There are line items in v11 from history but they are 'rolled up' and not detailed.
So I've had to keep our on premise servers up until I can come up with best solution.
So before I go down a path, I thought I would reach out to see what others have done.
My thoughts at this point are 1) copy on prem sql db to another enterprise sql server and have our internal developers build a front end for look ups or 2) pull from on prem gltransrel and load into 'LegacyGLTransRel' business class in cloud that I was told about and then figure out how to build a menu, tie to security roles and create list view and form view within config console
Feels like #2 would be best and all then available in one system but I'm not sure how complicated that would be. Assuming would need gltransrel exports by couple months at a time due to volume to reformat for LegacyGLTransRel or figure out how to dbexport to then convert format for dbimport into LegacyGLTransRel.
Any insight would be more than appreciated.
