web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Physical Inventory by Inventory Dimension Report-Datasource

(0) ShareShare
ReportReport
Posted on by 492

Hello Team,

Kindly Let me know the datasource for Physical Inventory by Inventory Dimension Report Datasource. We want to remove unwanted data printed on report. Attached snap for your reference. Kindly support

pastedimage1595941548675v1.png

I have the same question (0)
  • nmaenpaa Profile Picture
    101,166 Moderator on at

    How do you define "unwanted data"? Perhaps you can already filter it out by using the filters in the report launch dialog?

  • Senthil Yadav Profile Picture
    492 on at

    Hello Nikolaos,

    In attached snap you can see the Data highlighted. We dont want to print the data on report. We are aware about Filters in report. User is not aware of the Data which has these highlighted transactions, so we want to remove it from the Datasource. Can you please assist. Thank You.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Senthil,

    Removing data from the database can be very dangerous and mess things up.

    I would rather recommend modifying the report or even exporting the data to excel for reporting where you can exclude those lines easily.

    Best regards,

    Ludwig

  • Senthil Yadav Profile Picture
    492 on at

    Hello Ludwig,

    Thanks for your suggestion, can you please let me know how can we modify the report so as to get required data from Report. Users are not ready to export report into Excel and delete unwanted data. They want it to be removed from report itself, because this data will be displayed in every month Inventory Report.

  • Suggested answer
    nmaenpaa Profile Picture
    101,166 Moderator on at

    What exact data do you want to exclude? Is it this one item in your screenshot? You can hardcode a range in the report query to always exclude something, but first you need to define what you want to exclude.

  • Senthil Yadav Profile Picture
    492 on at

    Hello Nokoloas,

    Yes we want to exclude the data shown in screenshot, exactly we dont know what data the users will be excluding. The users concern is only one thing that if the stock for these items is not present in system it should not be displayed on report and also these transactions shown in report are of no use for them. So they dont even want to display it on Report.

  • Suggested answer
    nmaenpaa Profile Picture
    101,166 Moderator on at

    Ok, so the answer is that you want to exclude this one item completely.

    In theory it seems easy but it might actually be a bit tricky.

    The report is using InventDimPhys Query in AOT.

    Locate the query, expand the data source properties, go to Ranges. Here you could add a new hidden range for ItemId, excluding the item that you don't want to show. But this report already has a visible range for ItemId. If you have two ranges for the same field, they are considered as "OR", not "AND", so your range would not work. You can test it yourself.

    Another option would be to modify Classes\InventDimPhysDP\processReport, and modify the query in x++ before it's sent to InventSumDateEngine class. You could check if the query data source has a range for ItemId.

    If it doesn't, you can simply add your range to the query.

    If it does, you need to enhance the existing range. As mentioned, adding two ranges for the same field are considered as "OR", but if you use "expressions in query ranges", you can achieve two "AND" conditions in the same field: docs.microsoft.com/.../using-expressions-in-query-ranges

    I think this is how you can fulfill the requirement.

  • nmaenpaa Profile Picture
    101,166 Moderator on at
    [deleted]
  • nmaenpaa Profile Picture
    101,166 Moderator on at

    Ah, or did you mean that you want to hide all items which don't have stock in the system?

    But in your screenshot you had many such cases, and yet only one item was marked by you.

    It's really important to define (and describe) your requirement in a clear way - that's the prerequisite for starting technical design for the solution.

  • Senthil Yadav Profile Picture
    492 on at

    Hello Nikoloas,

    Yes we want here two things, First we have many lines as present in the screenshot positive and negative Qtys being displayed. we want to eliminate all those items from the report and yes second requirement is hide all the items which dont have stock in the system.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 678 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 407 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 283 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans