web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    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.

  • Suggested answer
    Suresh Kulla Profile Picture
    50,245 Super User 2025 Season 2 on at

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

  • Sunny10 Profile Picture
    2 on at

    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 ....

  • Sunny10 Profile Picture
    2 on at

    I will check n revert

  • Sunny10 Profile Picture
    2 on at

    Currently 50000 lot no generated for item wip00006

  • Sunny10 Profile Picture
    2 on at

    i mean 50000 to 80000 lot nos open at wip00006 stage

  • Sunny10 Profile Picture
    2 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans