Cannot delete Warehouse Activity Line in SQL version

Alex_Chow

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:

---------------------------
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...

Alex_Chow

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.

Alex_Chow

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.

kine

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)

Alex_Chow

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.

Alex_Chow

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...