GL: How to reverse the historical data and make the TB available only with the opening Balance in R1
Hi Friends,
I have a strange requirement. We have started a company in Oracle R12.1.3, with the opening TB loaded as of Dec-13 and then continued with the normal data entry till now (Jun-2016).
Now finance dept has decided to have some amended transactions started from Jan-14 on wards with the same opening balance of Dec-13. What is the best way to achieve this?
I think we need to reverse all the AP and AR transactions and transfer to GL and also revering the manual entries in the same period in which they were created. But not sure, will it work or not, as P&L items difference gets transferred to Retained Earnings on every