Hi Team,
I am working on a requirement in which I am creating the duplicate of Variance analysis statement report. I want to pass some additional filters in this report as per the business requirement.
I have created duplicate of standard query InventCostReport - as I want to fetch only those items where default order setting is Purchase order. To achieve this, I added the datasource InventItemSetupSupplyType under InventCostTrans datasource and added the relation as defined the relation like below screenshot and passed the range on defaultOrderType as 0. Also I am passing the range on InventCostTrans .CostTransRefType as 1.
Now when I am running the report, this range seems working but when I am adding a specific item to run the report, its not running for that item but running for all the items.
Somehow its not accepting the item passed in record to include option while running the report. Please guide what am I doing wrong here.
Somehow its not accepting the item passed in record to include option while running the report. Please guide what am I doing wrong here.
Please guide.
Thanks
Categories:
291,661
