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

[R P. <arc...@mt...>]

Hello Luc

I have done this type of thing with previous SQL-ledger versions but I have=
n't looked into the database structure for a year and a half.
When i needed to correct a large number of COGS out of order problems I did=
 the following....
=2Dmade a copy of the dataset
=2Dcleaned the orders, invoices and quotes from the copy, by truncating (re=
moving the data from) some of the tables
=2D used a perl script to copy a date range of orders and invoices from the=
 original database to the copy in chronological order.

Can you describe what you want to do in detail ?

=46rom your post I understand that you want to keep:
Parts, Customers, Vendors, Chart of accounts

Is there anything else you need to keep ?

You want to  truncate the partstax table ?... this would force you to edit =
every part to reconfigure it's tax settings.=20
Are all the parts configured wrong for tax ?
Could you keep the partstax table intact and edit the few parts with errors=
 ?


Cheers,
Roy




On Thursday 25 January 2007 12:30 pm, Luc van Stappershoef wrote:
> Can anybody please review if this a good way to restart with booking in=20
> sql-ledger?.
>=20
> Luc van Stappershoef wrote:
> > Hello Sql-ledgerers,
> >
> > I have copied the database of a environment where I need to start all=20
> > over again (after 3 months). But I want to keep some information (like=
=20
> > 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=
,=20
> > ar, assembly, audittrail, business, dpt_trans, exchangerate,=20
> > exchangerate, gifi (Does not apply in my country), gl, inventory,=20
> > invoice, JCitems, oe, orderitems, partstax ( I will need to redo this=20
> > because of mistakes), Status, Yearend
> >
> > -*The following tables I Kept intact:* Chart, customer,customertax,=20
> > defaults ( I know i need t alter a few things there when I will start),=
=20
> > department, employee, language, makemodel, parts, partscustomer,=20
> > partsgroup, pricegroup, project(was empty), recurring (was empty),=20
> > Recurringemail (was empty), Recurringeprint (was empty), shipto (was=20
> > empty),  sic (was empty), tax, translation, vendor, vendortax, warehous=
e,
> >
> >
> >  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=
=20
> > comment on this exercise before I start putting in my orders, sales,=20
> > bookings etcetera. It is allways very painfull to find out you have don=
e=20
> > things wrong
> >
> > Tanks in advance
> >
> > Luc
> >
> >
> >
> >
> >
> > -----------------------------------------------------------------------=
=2D-
> > 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=3Djoin.php&p=3Dsourceforge&CID=
=3DDEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> >
> >  =20
>=20
>=20
>=20
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

=2D-=20
Roy W Pennington
Customer Support
Arch Distributors of Canada
Phone: 204.257.8161