Cannot delete Warehouse Activity Line in SQL version

Alex_Chow
Member Posts: 5,063
I'm using Navision 5.0 with SQL 2005.
When I'm trying to delete lines from the Warehouse Activity Line table (table 5767), I'm getting the following error:
Is anyone else experiencing this problem? The debugger and client monitor doesn't seem to pick this up...
When I'm trying to delete lines from the Warehouse Activity Line table (table 5767), I'm getting the following error:
--------------------------- Microsoft Dynamics NAV --------------------------- The Warehouse Activity Line does not exist. Identification fields and values: Activity Type='Put-away',No.='PU006380',Line No.='30000' --------------------------- OK ---------------------------
Is anyone else experiencing this problem? The debugger and client monitor doesn't seem to pick this up...

Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
0
Comments
-
I tried deleting the data from this table using standard version, and it seems to work fine.
Upon further analysis, the error seems to be cause from this snippet of code on the DeleteRelatedWhseActivLines function on the OnDelete trigger.WhseActivLine2.DELETE; // to ensure correct item tracking update
Let me see why this is not working. Will update you guys as soon as I find out more. Unless someone else beats me to it.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Hmm... I'm not sure why delete the record before doing processing. In the meantime, I've commented this code out since the client doesn't use item tracking.
If anyone has more time to investigate and elaborate on why the .DELETE is there would be greatly appreciated.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Warehouse is a little "big" strange module, made in a way which is not "clean&clear". For me it is better to not ask "why" and correct the :bug: without question... 8)0
-
LOL!
Yeah, I agree with you. Most WHM implementations are highly customized.
This seems strange as there's a comment specifically put in on the .DELETE.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Dang... Apparently, remove that line of code causes the Lines to NOT be deleted when the header is deleted...
It looks like this is a pretty big :bug: in NAV 5.0 using SQL if you're using WHM Directed Pick and Put-away.
Looks like I need to write my own OnDelete trigger...Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
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