# Utitliy for Go-Live **URL:** \ **Category:** Developers Forum\ **Created:** [August 27, 2005, 9:34pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207 "2005-08-27T21:34:01Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![TallMikey](https://avatars.discourse-cdn.com/v4/letter/t/cab0a1/32.png) [@TallMikey](https://www.dynamicsuser.net/u/TallMikey)\ **Post date:** [August 27, 2005, 9:34pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/1 "2005-08-27T21:34:01Z")
Hello Everyone - I thought I saw somewhere a utility that clears out the transactional ledgers and registers to use on a test database just before taking the customer live. For example, we dataport in the customers, etc., set them up and make test transactions while tweaking the setup. After that just before go live we want to clear out the ledgers and registers and do the final data conversion. Is there a utillity already made that will clear out these tables? Thanks, Michael ---
**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\ **Post date:** [August 28, 2005, 9:47am UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/2 "2005-08-28T09:47:46Z")
I have one I use, you can get a copy here :- [http://www.go-live.us/prod01.htm](http://www.go-live.us/prod01.htm) Under …Create a clean database. becarefull and test it to suit your needs!!! ---
**Author:** ![danielekwall](https://avatars.discourse-cdn.com/v4/letter/d/4bbf92/32.png) [@danielekwall](https://www.dynamicsuser.net/u/danielekwall)\ **Post date:** [August 28, 2005, 11:03pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/3 "2005-08-28T23:03:09Z")
In 3.70 and 4.1 there is a standard tool for this. Go under Setup Checklist - Functions and Implementation. The last tab has a button called Clean that removes all transactions. The only thing it doesn’t do (from what I found so far) is resetting the number series. Regards Daniel ---
**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\ **Post date:** [August 29, 2005, 6:06pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/4 "2005-08-29T18:06:19Z")
Hi Daniel, this sounds great, but I can’t seem to find this in 3.70? Where is this function (is it a codeunit or a report)? ---
**Author:** ![naveenjain](https://avatars.discourse-cdn.com/v4/letter/n/e47774/32.png) [@naveenjain](https://www.dynamicsuser.net/u/naveenjain)\ **Post date:** [August 29, 2005, 6:23pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/5 "2005-08-29T18:23:20Z")
Its in Navision 3.70B OR in 4.0 with Service Pack 1 ---
**Author:** ![naveenjain](https://avatars.discourse-cdn.com/v4/letter/n/e47774/32.png) [@naveenjain](https://www.dynamicsuser.net/u/naveenjain)\ **Post date:** [August 29, 2005, 6:26pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/6 "2005-08-29T18:26:52Z")
It is actually in 8600 Objects range. Form 8600 Implementation etc. ---
**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\ **Post date:** [August 29, 2005, 6:39pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/7 "2005-08-29T18:39:58Z")
Thanks, I am looking at 3.70A. DOn’t have 3.70B on me here, but will take a look at it some time later. [8D] ---
**Author:** ![nilsm](https://avatars.discourse-cdn.com/v4/letter/n/82dd89/32.png) [@nilsm](https://www.dynamicsuser.net/u/nilsm)\ **Post date:** [August 29, 2005, 11:52pm UTC](https://www.dynamicsuser.net/t/utitliy-for-go-live/10207/8 "2005-08-29T23:52:41Z")
At least with 3.70B, I found a couple of ledger and dimension tables that are missing and that should absolutly be included: 271 Bank Ledger Entry 355 Ledger Entry Dimension 359 Posted Document Dimension You might also consider to delete order entry and journal lines, to make sure not to post any test or training data: Tables 36, 37, 38, 39, 81, 356, 357, 358 … for those who prefer code, add the following lines at the end of the function DoCleaning, before the Window.Close: ` CleanTable(36); CleanTable(37); CleanTable(38); CleanTable(39); CleanTable(81); CleanTable(271); CleanTable(355); CleanTable(356); CleanTable(357); CleanTable(358); CleanTable(359); ` Otherwise, this whole new tool is really great and helpful… Saludos Nils