Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Inventory on-hand by w...
Finance | Project Operations, Human Resources, ...
Unanswered

Inventory on-hand by warehouse V2 - zeros in Available On Hand and Ordered Quantity when Exporting

(0) ShareShare
ReportReport
Posted on by CharlotteC 19

Hi All

Got a strange issue today where the Inventory on-hand by warehouse V2 entity has set the AVAIALBEONHANDQUANTITY and ORDEREDQUANTITY to zero for all products.  In the system the information is displaying correctly, just when you export to either a Datalake or an Excel sheet.

I have been happily exporting this table without problem for a few years.

Has anyone had this happen before?  I need these columns for a PBI report so would appreciate any help.

**************UPDATE*********************

Incase anyone else has this issue, it was caused by a caching error on the entity itself.

  • Tiberian Profile Picture
    Tiberian 2 on at
    Inventory on-hand by warehouse V2 - zeros in Available On Hand and Ordered Quantity when Exporting
    Hey Charlotte, I am facing the same issue and I am wondering how you solved the caching error? Thx
  • CharlotteC Profile Picture
    CharlotteC 19 on at
    RE: Inventory on-hand by warehouse V2 - zeros in Available On Hand and Ordered Quantity when Exporting

    Hi
    Yep tried a new export job, tried republishing the entity to the data lake both which were unsuccessful.  We have noticed that the staging table seems to be caching and after a quick test of changing the date on one of the rows we found that the data pulled through to both the Excel export and the data lake.

    Have you any suggestions on disabling caching on entities?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,099 Super User 2025 Season 1 on at
    RE: Inventory on-hand by warehouse V2 - zeros in Available On Hand and Ordered Quantity when Exporting

    Hi Charlotte,

    Have you tried creating a new export project? Do you then still have this issue? As I'm not aware of your situation, I would not be able to guess what might be different between your production and UAT environment.

  • CharlotteC Profile Picture
    CharlotteC 19 on at
    RE: Inventory on-hand by warehouse V2 - zeros in Available On Hand and Ordered Quantity when Exporting

    Hi 
    No changes to the environment since the last update was run in around 8 weeks ago.  No customisations to that entity that I am aware of either.
    The wierdest part is that our UAT environment (which holds the same data, same versions etc.) seems to be working fine.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,099 Super User 2025 Season 1 on at
    RE: Inventory on-hand by warehouse V2 - zeros in Available On Hand and Ordered Quantity when Exporting

    Hi Charlotte,

    Do you know if there was any change to this environment? E.g. deployed a Microsoft version update and/or customizations?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,099 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,880 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans