I have a client that has recently been purchased by a larger entity. The new company would like to change the fiscal year and purge all historical detail from before the acquisition. Their preference is to start a totally new company that only has detail from the acquisition date forward. This would entail copying all the master files, e.g., AR, AP, GL, SO, PO, IM, etc. and then exporting and importing current transactions. Is this even possible? Would the current transactions have to be imported into a transaction file and updated or can we just import them into the current open files? Since we are on Sage 100 2016 Premium, it is possibly we could just dump data from the past using SQL, but I am not sure how this would impact the sub-modules and the ability to drill down into supporting registers.

Has anyone ever successfully done this?