Skip to main content
Solved

QTY Missing from Inventory Valuation Export to Excel


peter92
Jr Varsity III
Forum|alt.badge.img

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

@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,

 

View original
Did this topic help you find an answer to your question?

4 replies

StevenRatner
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 74 replies
  • Answer
  • November 16, 2023

@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,

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

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

 


peter92
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 17 replies
  • November 16, 2023

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


StevenRatner
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 74 replies
  • November 17, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings