ItemList Lookup in Consumption Journal form.

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

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.

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

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

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.