Item List Report - Filter by Unit Of Measure Lookup

ChessExpert

Hi there experts. I was trying to generate an Item Report filtered by Unit Of Measure. But when I put in the Unit Of Measure filter, I am getting this error.
Error:
“Item No. must be field in. Please enter a value.”
I checked the property of Item.”Base Unit Of Measure” field and it has this table relation:
"Item Unit of Measure".Code WHERE (Item No.=FIELD(No.))

I was thinking of modifying the report to support this functionality.
Has anybody done anything like this and how they fixed it.


Thank you in advance.
ChessExpert.

vijay_g

When you lookup to "Base unit of measure" you must insert item code in same(check PK of table "Item Unit of Measure") so better is take a DataItem before item table based on "Unit Of Measure" table and link it with Item Base Unit of Measure.