Announcements
No record found.
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.
Hi Charlotte,
Do you know if there was any change to this environment? E.g. deployed a Microsoft version update and/or customizations?
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.
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.
HiYep 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?
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 509 Super User 2026 Season 1
Giorgio Bonacorsi 375
Adis 268 Super User 2026 Season 1
