Display cross reference number for specific item & custo

johnsogj

Hello, I'm creating a report that displays all items and associated information for each. One field I must display is the Cross Reference Number for customer "X" which is stored in the Item Cross Reference table. How can I code for this? Here is what I tried, but the report comes back blank in this column for all records:

Xref.SETCURRENTKEY("Item No.","Variant Code","Unit of Measure", "Cross-Reference Type No.");
Xref.SETFILTER("Cross-Reference Type No.", 'C00010');
Xref.SETFILTER("Item No.",Item."No.");
Xref.SETFILTER("Variant Code",' ');
Xref.SETFILTER("Unit of Measure", 'EA');
XNo := Xref."Cross-Reference No.";

idiot

Xref.SETCURRENTKEY("Item No.","Variant Code","Unit of Measure", "Cross-Reference Type No.");
Xref.SETFILTER("Cross-Reference Type No.", 'C00010');
Xref.SETFILTER("Item No.",Item."No.");
Xref.SETFILTER("Variant Code",' ');
Xref.SETFILTER("Unit of Measure", 'EA');
IF Xref.FINDFIRST THEN
XNo := Xref."Cross-Reference No.";[/b]

kriki

I cleaned up your code a little more:

Xref.RESET;
Xref.SETCURRENTKEY("Item No.","Variant Code","Unit of Measure", "Cross-Reference Type No.");
Xref.SETRANGE("Cross-Reference Type No.", 'C00010');
Xref.SETRANGE("Item No.",Item."No.");
Xref.SETRANGE("Variant Code",' ');
Xref.SETRANGE("Unit of Measure", 'EA');
IF Xref.FINDFIRST THEN
  XNo := Xref."Cross-Reference No.";

Always use RESET-SETCURRENTKEY-SETRANGE/SETFILTER. Like this everyone sees directly that at the start of the code there are NO other filters active (and it can also avoid some bugs later when someone else changes something in the object).
-Don't use SETFILTER if you can avoid it. Better use SETRANGE. On the Navision DB it can be faster then a SETFILTER, but never slower. It is more readable because the SETRANGE has a clearer syntax for filtering on 1 value or a range of values.

johnsogj

thank you! it worked perfectly