Re: [SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Can anybody please review if this a good way to restart with booking in 
sql-ledger?.

Luc van Stappershoef wrote:
> Hello Sql-ledgerers,
>
> I have copied the database of a environment where I need to start all 
> over again (after 3 months). But I want to keep some information (like 
> parts, customers suppliers, ledger etc)
>
> I have experimented a bit and I think the following works:
>
> -*Copy database*
> -*Delete the content of all the of the following tables: *acc_trans, ap, 
> ar, assembly, audittrail, business, dpt_trans, exchangerate, 
> exchangerate, gifi (Does not apply in my country), gl, inventory, 
> invoice, JCitems, oe, orderitems, partstax ( I will need to redo this 
> because of mistakes), Status, Yearend
>
> -*The following tables I Kept intact:* Chart, customer,customertax, 
> defaults ( I know i need t alter a few things there when I will start), 
> department, employee, language, makemodel, parts, partscustomer, 
> partsgroup, pricegroup, project(was empty), recurring (was empty), 
> Recurringemail (was empty), Recurringeprint (was empty), shipto (was 
> empty),  sic (was empty), tax, translation, vendor, vendortax, warehouse,
>
>
>  From this I want start all over again (not so much need to be entered),
>
>     * Orderentries,
>     * salesbookings
>     * financialbookings etc
>
>
> I have been playing around a bit and it seems it will work, can anybody 
> comment on this exercise before I start putting in my orders, sales, 
> bookings etcetera. It is allways very painfull to find out you have done 
> things wrong
>
> Tanks in advance
>
> Luc
>
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>