counting records query - NAV 2016

shahsunil10

We have manufacturing process of packaging Rolls / pouch in dynamic nav 2016, we face problem in production order, in production journal while doing consumption when we click select entries nav 2016 shows message counting records and its stuck for 15 minits. Screenshot attach.

i will give example of our one production order as under :
===============================================
we have 5 stage of wip and last stage of finished goods

wip 1 printing suppose we consume 100 kg of roll and output is of 95 kg roll

wip 2 doctoring we consume 95 kg of roll and output 93 kg roll

wip 3 lamination we consume 400 kg of roll and output 350 kg roll - kg increase bececause 1 or 2 layer of other material add

wip 4 slitting we consume 350 kg of roll and output get 300 kg in form on 30 rolls of 10 kg each, we assume- here we face problem because 30 lots of 10 kgs each roll generated at slitting stage. so while creating lots system hang for 15 minits.

wip 5 pouching we consume 300 kg and output get 250 kg - here also while selecting lots system hang for 15 minits

Finished goods stage - consumption get 250 kgs output get 250 kgs here also while selecting lots system hang for 15 minits

Please guide why this happens??

Our mdf data size is 6 GB and LDF data size is 37 GB.. our system configuration is intel xeoncpu e5-2609v3 @ 1.9 ghz, 16 GB RAM, with 100 GB Free space in c and d drive.
We have 15 users of Dynamic NAV 2016.

KTA8

It seems some kind of personalization, I don't remember any of that.

Jose56789

yes it seems kind of personalization dont remember that ask admin