Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Error while deploying report"Physical inventory by inventory dimension (Inventory module)

Posted on by 3,024

8171.png86822.png82776.png6153.png

Dear Experts,

I want to remove some fields from Report"Physical inventory by inventory dimension". I removed it but when i am trying to deploy it. I am facing Error as shown in the above image.

Thanks and Regards,

Shabir Ahmad

  • kvnkk Profile Picture
    kvnkk 796 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    It’s strange behavior.. It’s working for me. I am not sure why it’s not working for you. I will do more analysis and let you know if I found anything more.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    4265.png

    Dear kvnkk,

    check-in above image not only for one field for all of the fields property is "Yes".

    Thanks and Regards,

    Shabir 

  • kvnkk Profile Picture
    kvnkk 796 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    Can you do one more thing.

    Just I changed the field property to yes which I want to hide

    pastedimage1577265731492v1.png

    Saved the report and open though VS

    and changed property and deployed from VS directly.

    Result as below :-

    pastedimage1577266219312v2.png

    But I am not sure whether it is correct procedure or not but it works for me.

    After saving report and try deploy its crashing but saving the changes some how.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    2262.png6165.png6330.png

    Dear,

    Thanks for your valuable suggestion, but it didn't work for me, check the above images.

    Thanks and Regards,

    Shabir Ahmad

  • kvnkk Profile Picture
    kvnkk 796 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    Hi ,

    I just played with this report and got successes some how and will provide you the steps and it may helps you as well.

    it is a Auto design report and using table as direct source.

    - If you want to add new field add it directly in table :- InventSumDateTransReport and refresh  report data-set and drag that filed in to design.

    - if you want to hide the field  change as shown in below screen :-

    pastedimage1577180601702v1.png

    - This report having many static designs in different languages so you may face error while deploying. so what I can suggest you that. 

    just remove record from below table then it will deploy for current language instead of other languages.

    System administration > Setup > Business intelligence > Reporting Services > Report deployment settings.

    pastedimage1577180754002v2.png

    Plz take backup and  try in DEV BOX before going to live..

    Note :- Even  my VS crashed but gone through proper way and didn't face any issue later and report working fine..

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    Hi Shabir,

    Now I understand what you want to achieve. In your first series with screenshots, you showed the inventory dimensions with a remark to remove some of them.

    Can you confirm that the report development part was successful and you are able to do a full x++ compilation and CIL build without errors? Have you also tried to view more information in the Windows event logs?

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    4062.InventoryReport.pngparameterdialog.png

    Dear,

    First thing is, our one department needs to remove these above shown 5 fields in the image from inventory Report and add some other fields. As I tried the report is not letting me remove these fields.If i want to hide how could I?(Green colored column). Further, check the parameter dialog as well, before running report. 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Error while deploying report"Physical inventory by inventory dimension (Inventory module)

    Hi Shabir,

    What exact fields do you want to remove and why? You can control them using the report dialog. If you delete them, then I do think your error is caused by the fact that business logic which controls these fields are not adjusted accordingly.

    Anyway, I would suggest to use the report parameters on the dialog to show or hide columns.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans