Serialized Inventory problem

[funnie]

I am having a problem with Serialized inventory. Each time I process a day end or do a post in Purchase order the system goes to each and every serial number in the system and add an entry in the Serialized inventory. If you open serialized inventory Serial number edit list menu , then go to transcations each serial number will be having hundreds of transcations to it. My main problem is like its now taking a very long time to process a day end and even when posting PO's it can take upto more than 30 minutes to do a single post. Each of these serial numbers will be having more than 100 transcations attached to it after every dayend processing. At the end of every day end it brings up an error: Record Already Exists and Cannt insert in snumber.

Accpac 5.4 service pack 2
SQL 2000 DB

 

[Jay Converse]

1. SP2 for which modules? SM should SP3. Serialized Inventory should also be SP3, because that fixed some day-end errors.
2. SQL 2005 is faster

 

[ettienne]

There were many issues with serialized inventory and these were all fixed in hotfixes, there are quite a few of them. You need to get the latest service packs and hotfixes installed.