Error: "Another User modified........"
Deep
Member Posts: 569
Dear All,
I am facing a problem.
I have got a boolean say Boolean1 on Gen. Journal Line. On the Journal Voucher Form, I want to mark all the boolean 1 of the same document no.=True or False when I click on the first line boolean1. For example.
DocNo. Amount Boolean1
DOC001 100.00
DOC001 200.00
DOC001 300.00
DOC002 100.00
DOC002 200.00
Now when I click on First line boolean1, all the three lines with the same document no. (DOC001) must be true automatically. The scene should be like below after clicking line 1.
DocNo. Amount Boolean1
DOC001 100.00 TRUE
DOC001 200.00 TRUE
DOC001 300.00 TRUE
DOC002 100.00
DOC002 200.00
The error is, when I click the first line, the booleans get update on the table, but the form flashes an error " ANother User has modified the record for the Gen.Jour. Line after you retrieved it from the database."
The code has been written on the table field=Boolean1.
Kindly help with your suggestions.
I am facing a problem.
I have got a boolean say Boolean1 on Gen. Journal Line. On the Journal Voucher Form, I want to mark all the boolean 1 of the same document no.=True or False when I click on the first line boolean1. For example.
DocNo. Amount Boolean1
DOC001 100.00
DOC001 200.00
DOC001 300.00
DOC002 100.00
DOC002 200.00
Now when I click on First line boolean1, all the three lines with the same document no. (DOC001) must be true automatically. The scene should be like below after clicking line 1.
DocNo. Amount Boolean1
DOC001 100.00 TRUE
DOC001 200.00 TRUE
DOC001 300.00 TRUE
DOC002 100.00
DOC002 200.00
The error is, when I click the first line, the booleans get update on the table, but the form flashes an error " ANother User has modified the record for the Gen.Jour. Line after you retrieved it from the database."
The code has been written on the table field=Boolean1.
Kindly help with your suggestions.
Regards,
Deep
India
Deep
India
0
Answers
-
In the form in the OnAfterValidate of the boolean1-checkbox put CurrForm.UPDATE;
Tino Ruijs
Microsoft Dynamics NAV specialist0 -
Remove the code from table Boolean field onvalidate .Write in Form Boolean field Onvalidate then CURRFROM.UPDATE .0
-
In table level create one function and put the code you written in Onvalidate of boolean1 into that function.In Form level OnAfterValidate call that function and then write
currform.update
Hopefully it will work ..0 -
Yeah. Thanks bappaditya44.
It works.Regards,
Deep
India0
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
- 322 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
