Page 1 of 1

Fresh MDB file for new month/Year

Posted: Sat Aug 01, 2009 2:26 am
by Nongkiau
I want to start every month with a new MDB file, but with all items and stock records transferred. First I tried to delete all orders in the POS, but that affected Inventory (sold items were put back on the shelves).

I then tried to delete all orders in the database file, and it seems to be successful. However, I wonder what other data I should delete to get a truly reset database file. InvChange is another table to clean up, would that be correct? Any other tables? Does it damage or affect anything unexpected to do this?

Eskil

Re: Fresh MDB file for new month/Year

Posted: Thu Aug 20, 2009 10:30 am
by Abacre
Yes, you can clean up InvChange table.
What's typical size of your database file at the end of the month?
Can you send your database file (in zip archive) to support@abacre.com? So we could do some performance tests and tuning based on a large database file.