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)

Warehouse request table 5765 Locking issues

(0) ShareShare
ReportReport
Posted on by

Hi

We have several users posting both purchase receipt and sales shipment at the same time of the day

Although they work on different locations and often on different "directions" (Inbound and outbound), we have daily issues with tables locking

I understand tables like sales lines and warehouse shipment headers and lines to be locked when a user is shipping stock.

Yet even users posting purchase receipts or re-opening/ releasing purchase orders are locked when someone else is shipping; and vice versa.

This because of the locking of the warehouse request table that holds both receiving and shipment documents

Our current volumes are about 80 documents a day for an average 1600 lines for which we have lot no and expiration days (Food items)

This results in downtimes of about 20 minutes a day when only one user at the time can post in NAV. Either receiving or shipping stock

Is there any workaround that can help reducing the number of tables locked?

It would be a good start if purchase receipts and sales shipments could be posted at the same time.

Any suggestion is welcome

Many Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,284 Super User 2025 Season 2 on at

    Try to look at how long is it to take to post the warehouse receipt and shipment, and try to reduce it by turning off the automatic cost adjustment or automatic update of Analysis Views.

    Also try to consider implementing posting in batch / queue.

  • Community Member Profile Picture
    on at

    Hi Teddy

    The longest process is the posting on the warehouse shipments. Receipts are usually fine

    Automatic cost adjustments and posting inv cost on GL are off and run on job queues out of office hours

    Analysis view does not update on posting.

    I also monitored the SQL server performance during posting and CPU usage never goes above 30% so a server upgrade should not really make things faster...

    At this stage I have run out of options apart from posting using batches according to Locations/ users. But I guess this would require bespoke developtment

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,284 Super User 2025 Season 2 on at

    Unfortunately there is no post batch in the warehouse. You will need to customize.

    You can add a new checkbox field. User will check the field when they finish the warehouse shipment / receipt.

    Then customize a job queue that post all the flagged warehouse shipment and receipt.

  • Community Member Profile Picture
    on at

    Thanks Teddy

    What you suggest will definitely work for us

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)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans