Federico,
From another thread with Connie Fu, I've picked up a bit more understanding.
Reversed transactions are final - though they are still in Clarity, they are not accessible/useful anymore, except for if one wants a report written on what transactions have been reversed. Therefore, I know understand the 'bring them back in' comment. And, when bringing them back in, I can make them 'not chargeable.'
However, many of the transactions are from timesheets. I don't think there is away to bring reversed transactions back in, except by possibly adjusting and posting the timesheets. Also, the imported transactions cover a spread of years - therefore I may not be able to get the original source data, as much of it came from multiple systems, downloaded to Excel and then xogged into Clarity. Even if possible to find, the work effort to do so is insurmountable.
Therefore, I really need a means to adjust what is there.
Wondering, if one could XOG out WIP tranactions, modified them and xogged them back, would they then appears as adjusted transactions needing approval? Or, can I just run an update script on PPA_WIP, changing Chargeable from 1 to 0? From what I can find (which may be not enough), it appears that PPA_WIP is the end of the line for transaction data, as long as I'm not creating invoices or chargebacks, which I'm not, yet. So, if I update Chargeable from 1 to 0 via script, I should be safe.
This is not a SOX issue for us as our Clarity finanical data is not used for anything outside of Clarity - its only used for project costing within the project management environment - not used for any of our financial book processes (not used in company p&l, taxes, investor report etc.).
Dale