Resetting TRANS records

We are testing some G/L Integration; one of the challenges is once we run our Month-End Procedures they are no longer available for testing again.

One way to resolve this is simply to take a backup of the database before running the Month-End Procedures and restoring it if you want to try it again.

A short-cut method, which is working for us is to update the TRANS.Posted field like so:


/*
Testing G/L Integration
set the TRANS.Posted value to 2 to re-integrate or setup transaction for month-end procedures
when the month end procedures are run the value get changed to 4
*/
update
trans
set
posted = 2
where
year(transaction_date) = 2009