Dear ERP LN Experts,
I facing a problem to filter my Item Code in my report script.

example :
List of item code as per below

FV/111U/12345678
FN/123U/45665546
WE/112U/56765765
OT/343U/13243244
DM/345U/23432450

Result appear which I want the Item Code are:
FV/111U/12345678
FN/123U/45665546
OT/343U/13243244

my filter criteria is which my Item code contain FVXXXXU ,FNXXXXU,OTXXXXU.

Please Help. :confused:

Hi,

You can filter out the items at report script as follows:
hold.item(1;2) = "FV" & hold.item(7;1) = "U"and so on ...

Make sure you left align the variable before operations.

Regards,
Amit

Hi,
below is my script:

if not isspace(tpest200.item(10;47)) then
if (hold.item(10;2)="FV" and hold.item(17;1)="U") then
itm =tpest200.desc
des =""
else
itm = tpest200.item(10;47)
des = tpest200.desc
endif
else
itm = tpest200.desc
des= ""
endif

BUT error prompt when compile the report.
rtpest240011001( 100): Error: ';' not expected.
rtpest240011001( 107): Error: 'else' not expected.
rtpest240011001( 110): Error: 'endif' not expected.
rtpest240011001( 100): Error: Unresolved reference to function 'hold.item'.

4 ERRORS REPORTED.


Please help! :o

Hi,

I had explained you the scenario taking 'hold.item' as the variable. In your case, you should use tpest200.item.

Regards,
Amit