Are they using serial numbering or configurations? What dimensions is 'Financial invnetory' set for?
Closing will have no impact on these tables record size but for sure closing should be done for several reasons including accurate costing and yes potentially to improve performance (although not by reducing the number of records in the mentioned tables). My guess would be that without closing then the InventSum table is never closed which means onhand calcs etc will look to include all the invetsum records. If you are using serial number then most likely a lot of the invetsum records should be closed (there is a field closed on the table and I believe it also has an index on this field) and so very quickly excluded in any search of records etc Will be interested to know your findings Thanks James -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Shahzad Butt Sent: 19 April 2006 19:45 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory Closing Actions - InventDIM overgrown Hi, one of our client hasn't closed their Inventory ever since they've gone live (2003) and their inventDIM and inventSUM have grown in size terribly. A hundred million rows in each, which is causing serious delays for any operation. I wonder if inventory closing has anything to do with reducing the tables mentioned in size. If not then what other ways can be used to archive these tables? Regards, Shahzad Butt [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/