Item Date Filter on a report

nbangaza

Good Day Everyone,

Is it possible to set a date filter on Item.'Date filter'?
The data item of the report that I created is Item table.
On the OnafterGetRecord() section of the report I want to be able to add code where I can filter on the "Item Ledger entry"."posting date".
I tried the below but it didnt work
ItemLedgerEntry.SETFILTER("Posting Date",Item.GETFILTER("Date Filter"));

So for example if a user when they run the report puts in the following date '010112..031212' the report should only filter for "Item Ledger Entries" within those dates.

Regards,

David_Cox

Try:
OnPreReport or OnPreDataItem
Item.COPYFILTER("Date Filter",ItemLedgerEntry."Posting Date");

If the Item Ledger Entry is an indented record under the item and not in code, then just add it in the Item Ledger entry > Properties > DataItemLink

HTH

David