Can't split new line when doing the put away transaction

primagusti

Dear All,

I have some problem when doing split line function in the warehouse good handling order by order/inventory put aways, when I reach number 19999 or 29999 or 49999 the following warning is appear, is this a bugs in dynamic navision or my setting is wrong.

Look at the line number 19999 item RM super Rice, when I want split it again to 480 the warning is appear "the warehouse activity line alraady exist". this warning always show when the line number format 4 last digit using 9999, ex. 19999, 29999, 39999, 49999 etc.




for information : i use navision 2009 R2, clasic version.

location card setup of this transaction :

- require put away = Yes

- require pick = Yes

- bin mandatory = Yes

I Have analyze this problem and I found wrong logic in table cause by this code
........
LineSpacing :=
(NewWhseActivLine."Line No." - WhseActivLine."Line No.") DIV 2
.......

you can get that code on Table 5767 Warehouse Activity Line\SplitLine(WhseActivLine).

Look at the following figure, when line number reach 19999, navision system can't add new line number. is this a bugs, is there a hotfix for patching this bugs.


I have triying change the formula but my license not authorize me for do some changing. the following table are the running result by that logic.



Please help me, because if this not solve, i can't use navision, because every transaction I must split minimum to 100 lines. using current logic can only split to 15 line.

Thanks for your help

Regards,


Prima

MarkHamblin

The line numbering logic is fairly standard in NAV - almost all "lines" forms/tables use it. And yes, it can be painful sometimes.

Without addressing why you need to split the put away 100 times (which seems strange), your best bet is probably a processing report that generates the activity lines you need. That way you can use any line numbering logic you like. Should be a pretty simple report - there's really no magic behind splitting lines in Inventory Put Aways (Warehouse Put Aways would be a tiny bit more work).

- Mark

primagusti

Hi Mark,

I think this is not seems strange, because let say company import 350container, every container has own lot number and will be located into 1 bin in the warehouse. so when the goods coming into the warehouse I need to split the container into 350 lines which have information bin location and lot number and also expire date.

- Prima