You’re offline. This is a read only version of the page.
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
Thanks Teddy
What you suggest will definitely work for us
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (