Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
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
Upon further analysis, the error seems to be cause from this snippet of code on the DeleteRelatedWhseActivLines function on the OnDelete trigger.
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.
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
If anyone has more time to investigate and elaborate on why the .DELETE is there would be greatly appreciated.
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
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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.
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
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...
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