Skip to main content

Notifications

Announcements

No record found.

Supply Chain Management forum

Need help with query duplicate query of InventCostReport for variance analysis report

Posted on by 128
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.
Please guide. 
Thanks
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,339 Super User 2024 Season 2 on at
    Need help with query duplicate query of InventCostReport for variance analysis report
    . Hi Karuna,
     
    You are confusing me now. You mentioned that adding the default order type is working, but when adding a range for a specific item. I don't see where you add the item filter. Now you start to talk about costtransreftype. I'm lost here. Are you trying to filter an item or setting a range on the field costtransreftype?
  • Karuna Dogra Profile Picture
    Karuna Dogra 128 on at
    Need help with query duplicate query of InventCostReport for variance analysis report
    Hi Andre,
    As mentioned clearly above, I am adding range in AOT query by adding datasource like below-
    Also, I have added range on the datasource InventCostTrans - field - costtransreftype as 1 but thats not working.
    •  
       
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,339 Super User 2024 Season 2 on at
    Need help with query duplicate query of InventCostReport for variance analysis report
    Hi Karuna,
     
    Can you tell us how you add the range to the specific item? Is that with coding or using the selection option from the user interface? On what data source are you putting a filter?

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans