Saturday, June 04, 2005

Tek-tips Question

Using Great Plains 7.5 with SQL 2000. I k now that updating SQL statistics and recompling SQL stored procedures are recommended for monthly maintenance. Are there any other recommended monthly procedures (checking links, reconciling tables), etc... Any help would be appreciated, this has sort of been put upon me quickly.

My response:
On the database side its mostly DBCC commands. In GP, our monthly task includes but not limited to:
1) Paid Transaction Removal
2) Removal of completed Purchase Orders
3)
Removal of completed Sales Orders
4) Removeal of Discontinued Items
5) Removal of Sold Receipts
6) Reconcile Sales Documents (updates Remaining Subtotal, etc.)
7) Reconcile Inventory Quantities

If you have Manufacturing modules:
6) Removal of Cancelled MO's
7) Removal of closed MO's

2 comments:

Anonymous said...

Do You want to find out more about self motivation tips...then go to http://possibility123.com/self-motivation-tips.html..

Dont wait

Anonymous said...

News News News

Wow What is going on with all these homes with severe mold problems. I cant believe the problems we are having in our homes today. It has always been here. ask about Black Mold