QTY Missing from Inventory Valuation Export to Excel

  • 16 November 2023
  • 4 replies

Userlevel 2

When pulling a Inventory Valuation report the “QTY on Hand” appears on the report but when exporting that to Excel the QTY is missing.  Anyone have a trick to make the QTY on Hand appear on the exported version?


Best answer by StevenRatner 16 November 2023, 17:30

View original

4 replies

Userlevel 5

@peter92 - The issue sounds like the field called “Qty on Hand” isn’t mapped in the report to be set out to excel.  This will require you to open the report designer and check to make sure the field is mapped correctly.  See my screen shot below,


Userlevel 7
Badge +12

Hi @peter92 Please  adjust Excel export settings in the field properties within the Report Designer.


Userlevel 2

@StevenRatner  - Thanks for the response…..that worked like a charm!

Userlevel 5

@peter92 - Thanks for the update.  Could you please mark the response as “Best Answer”.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved