Item Journal Takes Forever to Post

midnight

Doing 1 item journal to adjust inventory is taking about 25 mins to complete. If we try to do 2 you can double the time. Used to be fine. Did it in our test environment is about 20 secs. Has anyone else came across this issue. No system changes to speak of. We're on NAV2009 SP1, SQL DB.

Thanks

Marije_Brummel

Is the database optimised/reindexed?

Did you or someone else change some setup value?

How old is the testdb?

In these cases it is often searching for differences.

Noelit

DB might not be optimised and Also did u set up the DB on a different drive from the Drive that has the OS.
Look at the size of the Log file it may also be an issue.

midnight

Thanks for the replys. DB and Os are on different drives. I'm no SQL expert, and don't think a re-index has been done. Can you provide any pointers on how to optimize and reindex?

Thanks

william_marcelinus

Dear,

Have you checked other posting process such as Invoice posting or Warehouse posting?
if other process same as slow the item journal then must be something wrong with your
database.
sometimes even on optimized system and database item journal could be getting slower usually in
end of month. to re-adjust performance, user must re-adjust the stocks.

reference : http://www.advanced-business-systems.co ... urnal.aspx