Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

counting record message for 15 minits came while select entries and nav 2016 hangup during that time

(0) ShareShare
ReportReport
Posted on by

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

counting-records-process-message-takes-10-to-20-minits.jpg

*This post is locked for comments

  • Sunny10 Profile Picture
    Sunny10 on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    is there any simple method to close the open entries directly from database or from software? becuase negative posting takes too much time to post item tracking item wip00006.

  • Sunny10 Profile Picture
    Sunny10 on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    i mean 50000 to 80000 lot nos open at wip00006 stage

  • Sunny10 Profile Picture
    Sunny10 on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    Currently 50000 lot no generated for item wip00006

  • Sunny10 Profile Picture
    Sunny10 on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    I will check n revert

  • Sunny10 Profile Picture
    Sunny10 on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    Every production entry, NAV hang for 15 minits, at stage wip4 slitting were lot nos generated,  wip4 pouching stage were same lots number taken through select entries, and at last final output stage...  Some minor customization r there as per industry requirements ....

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 44,656 on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    Does it happen on every entry only for this particular entry ? Do you have any customization around this process ?

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: counting record message for 15 minits came while select entries and nav 2016 hangup during that time

    You have to chedk your code with debugging. It seems that NAV is counting (or ordering) records maybe using a non correct key or something similar. In these cases often creating a correct key helps a lot on performances.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans