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 2

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
    2 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
    2 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
    2 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
    2 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
    2 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
    47,688 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
    37,166 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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans