ItemList Lookup in Consumption Journal form.

navuser1

Dear all,

I have faced a problem regarding ItemList Lookup. The "Item No." field (in the Consumption Journal form) can not Lookup the Item List Form properly.

The Code under the Item No. - OnLookup(VAR Text : Text[1024];) : Boolean definitely create a problem.

What can I do ?? :-k

ara3n

The Item lookup on consumption journal works fine for me.
What kind of problem do you run into?

navuser1

Thanks for your reply Rashed!!

I am not able to go from Item No. 1000 Bicycle (Consumption Journal Form) to Item No. 1000 Bicycle ( Item List Form) thru Lookup. It always direct me the previous Item No. (Item List Form) where the cursor was.

Lookup is not working perfect in NAVIN version Base db (Nav 5.0 SP1).

AdamRoue

Why are you doing this and not using the function to populate the journal. Also why would you consume 1000 when you make 1000 - your issue is not clear.

navuser1

AdamRoue wrote:

Why are you doing this and not using the function to populate the journal. Also why would you consume 1000 when you make 1000 - your issue is not clear.

Item No.(s) is different. It is an Example.

ara3n

yes, this is an issue. that it takes you to a different Item no on the item journal table (which is the consumption journal).

I've reported it to MS to fix.


Here is the link and the solution to the problem.


https://connect.microsoft.com/dynamicss ... kID=496500

navuser1

Yaa!!
This is the reply which I'm waiting for. 8)
Thanks Rashed for your support.

ara3n

You are welcome. And make sure you vote on it.

David_Singleton

Hmm this looks like the same bug they had in version 3.10? They fixed that in 3.60, has it found its way back again?

ara3n

David Singleton wrote:

Hmm this looks like the same bug they had in version 3.10? They fixed that in 3.60, has it found its way back again?

Yes, In 3.6 the code was on onLookup trigger.
In later version they created a function called Itemlookup and moved the code in there but also changed it.

Item No. - OnLookup()
IF "Entry Type" = "Entry Type"::Output THEN BEGIN
  SetFilterProdOrderLine;
  IF FORM.RUNMODAL(FORM::"Prod. Order Line List",ProdOrderLine) = ACTION::LookupOK THEN BEGIN
    ProdOrderLine.SETRECFILTER;
    VALIDATE("Item No.",ProdOrderLine."Item No.");
  END;
END ELSE BEGIN
  IF Item.GET("Item No.") OR Item.GET(xRec."Item No.") THEN ;
  IF FORM.RUNMODAL(FORM::"Item List",Item) = ACTION::LookupOK THEN
    VALIDATE("Item No.",Item."No.");
END;

New code

LookupItemNo()

IF "Entry Type" = "Entry Type"::Output THEN BEGIN
  SetFilterProdOrderLine;
  IF FORM.RUNMODAL(FORM::"Prod. Order Line List",ProdOrderLine) = ACTION::LookupOK THEN BEGIN
    ProdOrderLine.SETRECFILTER;
    VALIDATE("Item No.",ProdOrderLine."Item No.");
  END;
END ELSE BEGIN
  ItemList.LOOKUPMODE := TRUE;
  IF ItemList.RUNMODAL = ACTION::LookupOK THEN BEGIN
    ItemList.GETRECORD(Item);
    VALIDATE("Item No.",Item."No.");
  END;
END;

They removed in 2009 the code from the Itemlookup trigger. So that it Item journal now works in 2009, but consumptions journal still calls this functions.