Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Warehouse request table 5765 Locking issues

Posted on by Microsoft Employee

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

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Warehouse request table 5765 Locking issues

    Thanks Teddy

    What you suggest will definitely work for us

  • Verified answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Warehouse request table 5765 Locking issues

    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
    Community Member Microsoft Employee on at
    RE: Warehouse request table 5765 Locking issues

    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

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Warehouse request table 5765 Locking issues

    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.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans