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.
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?
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.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,258
André Arnaud de Cal... 949 Super User 2025 Season 2
Sohaib Cheema 631 User Group Leader
