Locking Question

Mauddib
Member Posts: 269
Hi all,
Im a little baffled by Navision locking here. There is a user here that posts a large job once a day.
During this time everyone is able to post purchases and sales perfectly. No issues.
However there is a scheduled job that fills a Gen. Journal for me. If I go in while the user is working to POST this journal I am told
"Journal Dimension Table is locked by user XXXXXX".
or
"Gen. Journal Line Table is locked by user XXXXXX".
What is the posting of sales and purchases orders doing that posting my Gen Journal is not? How come I am locked and they arent? The posting of sales orders USES the Gen. Journal, so surely it should be blocked too.
Is there something I can do to my automatically filled Gen. Journal to allow it to bypass the locks like Sales Orders do.
Im a little baffled by Navision locking here. There is a user here that posts a large job once a day.
During this time everyone is able to post purchases and sales perfectly. No issues.
However there is a scheduled job that fills a Gen. Journal for me. If I go in while the user is working to POST this journal I am told
"Journal Dimension Table is locked by user XXXXXX".
or
"Gen. Journal Line Table is locked by user XXXXXX".
What is the posting of sales and purchases orders doing that posting my Gen Journal is not? How come I am locked and they arent? The posting of sales orders USES the Gen. Journal, so surely it should be blocked too.
Is there something I can do to my automatically filled Gen. Journal to allow it to bypass the locks like Sales Orders do.
0
Comments
-
The Navision posting routing use the Journal lines temporary which means there is no locking.
If you only use the Journal lines a a buffer you can do the same.
If you look at codeunit 80 & 90 you should see that the variable has the temprorary property.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions