Fixed Asset Volumes

tjf

Has anyone ever experienced any issues or constraints with NAV handling significant Fixed Asset volumes .... I am talking about in excess of 200,000 fixed asset records.

ara3n

FA module hasn't changed for a long time. The highest number of fixed asset that I've worked with was with a client that had 20K records. I've implemented nav for a company that had 150K items. Nav can handle the records, it's other processes that will need to be improved.

The monthly calculation for depreciation would be your bottle neck. When the routine runs it will slow sql and any other users.

I suggest to have a second db where you would restore last night db and run the routine, and transfer the journal lines to production to post.

You would need really good hardware to run this. And do lots of tuning.
How many users and what other areas will they be using?

tjf

Thankyou, apologies I have just checked my posts. Ultimately was not required to follow thru with this.

ara3n

No problem. What was the reason?

tjf

Ultimately we did not get any further with the pre-sales engagement. Cheers.