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

(0) Share

Report

Posted on by CharlotteC

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.

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 307,820 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Charlotte,

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

Like (0)

Report
Copy link

Link copied!

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 Cal... 307,820 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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 19 on at

Like (0)

Report
Copy link

Link copied!

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?
Tiberian 2 on at

Like (0)

Report
Copy link

Link copied!

Hey Charlotte, I am facing the same issue and I am wondering how you solved the caching error? Thx